Python Programming Language
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Use Python
![You imported and previewed the EPA Vehicle Emissions dataset by running the following piece of code.
inport pandas as pd
vehicles - pd.read_csv("https://coding-fundamentals.s3.amazonaws.com/vehicles.csv")
vehicles.head()
0
1
2
3
4
citympg cylinders displacement drive highwaympg make
2-
4.1 Wheel
Drive
14.0
14.0
18.0
21.0
14.0
(1) Answer:
(2) Answer:
(3) Answer:
(4) Answer:
6
(5) Answer:
8
8
6
8
2-
5.0 Wheel
Driva
2-
5.7 Wheel
Drive
Rear
4.3 Wheel
Drive
Rear-
4.1 Wheel
Drive
#(1) and (2)
#(3)
19.0
#(4)
20.0
26.0
Buick
Buick
Buick
31.0 Cadillac
19.0 Cadillac
model class year transmissiontype transmissio
Electra Park Large
Avenue Cars
Electra/Park Large
Avenue Cars
Electra/Park Large
Avenue Cars
Fleetwood/DeVille Large
(FWD) Cars
Brougham/DeVille Large
(RWD) Cars
1984
1984
1984
1984
Complete the following code snippet so that when run, you get a message that reads "The average city mileage of the 36973 vehicles in the dataset, is 17.5 mpg with a standard deviation of 4.5..
city - _['_
number round (city['
'].describe()
'])
average round(city[ .], 1)
deviation - round(city[''], 1) #(5)
print("The average city mileage of the vehicles in the dataset, is {} rpg with a standard deviation of {}-*
.format(number, average, deviation))
1984
Automatic
Automatic
Automatic
Automatic
Automatic](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fd31aecad-ffb9-4e10-94d6-20cb7001e99c%2F9303730d-a2dc-4a44-b337-dab359ea5e06%2F78pyqln_processed.png&w=3840&q=75)
Transcribed Image Text:You imported and previewed the EPA Vehicle Emissions dataset by running the following piece of code.
inport pandas as pd
vehicles - pd.read_csv("https://coding-fundamentals.s3.amazonaws.com/vehicles.csv")
vehicles.head()
0
1
2
3
4
citympg cylinders displacement drive highwaympg make
2-
4.1 Wheel
Drive
14.0
14.0
18.0
21.0
14.0
(1) Answer:
(2) Answer:
(3) Answer:
(4) Answer:
6
(5) Answer:
8
8
6
8
2-
5.0 Wheel
Driva
2-
5.7 Wheel
Drive
Rear
4.3 Wheel
Drive
Rear-
4.1 Wheel
Drive
#(1) and (2)
#(3)
19.0
#(4)
20.0
26.0
Buick
Buick
Buick
31.0 Cadillac
19.0 Cadillac
model class year transmissiontype transmissio
Electra Park Large
Avenue Cars
Electra/Park Large
Avenue Cars
Electra/Park Large
Avenue Cars
Fleetwood/DeVille Large
(FWD) Cars
Brougham/DeVille Large
(RWD) Cars
1984
1984
1984
1984
Complete the following code snippet so that when run, you get a message that reads "The average city mileage of the 36973 vehicles in the dataset, is 17.5 mpg with a standard deviation of 4.5..
city - _['_
number round (city['
'].describe()
'])
average round(city[ .], 1)
deviation - round(city[''], 1) #(5)
print("The average city mileage of the vehicles in the dataset, is {} rpg with a standard deviation of {}-*
.format(number, average, deviation))
1984
Automatic
Automatic
Automatic
Automatic
Automatic
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education