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
icon
Related questions
Question

Use Python Programming Language. Please let me know the answer. 

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
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
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Introduction to computer system
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
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)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education