22,Find the brands of type Audi

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
import pandas as pd
cars=pd.read_csv('cars2016.csv')
cars
name height length width
brand city_mpg highway_mpg
transmission_type engine_torque engine_horsepower year is_hybrid
Automatic
transmission
2009 Audi A3 3.2
140
143
202
Audi
18
25
236
250 2009
True
2009 Audi A3 2.0 T
AT
Automatic
1
140
143
202
Audi
22
28
207
200 2009
True
transmission
2 2009 Audi A3 2.0T
140
143
202
Audi
21
30 Manual transmission
207
200 2000
True
2009 Audi A3 2.0 T
Automatic
140
143
202
Audi
21
28
207
200 2009
True
Quattro
transmission
Automatic
transmission
2009 Audi A3 2.0T
140
143
202
Audi
21
28
207
200 2009
True
Quattro
2012 Honda Pilot
EX-L
Automatic
transmission
5070
13
253
201
Honda
18
25
253
250 2012
True
2012 Lamborghini
Gallardo Coupe LP
560-4
5071
141
249
108 Lamborghini
12
20 Manual transmission
398
552 2012
True
2012 Lamborghini
Gallardo LP 560-4
Spyder
5072
160
249
108 Lamborghini
12
20 Manual transmission
398
552 2012
True
2012 BMW 7401
Sedan
Automatic
transmission
5073
200
210
110
BMW
17
25
330
315 2012
True
2012 BMW 740LI
Sedan
Automatic
transmission
5074
200
94
110
BMW
17
25
330
315 2012
True
5075 rows x 12 columns
Q2,Find the brands of type Audi
In [ ]:
Q3. Find records of brand Audi in the dataset whose highway_mpg is strictly less than
28.
In [ ]:
Q. Return a table containing height and length by the average
In ( ):
Q5. plot the histogram of city_mpg
In [ ]:
Q6. based on the Q5 what is the most frequent range city Milepergallon
In [ ]:
Transcribed Image Text:import pandas as pd cars=pd.read_csv('cars2016.csv') cars name height length width brand city_mpg highway_mpg transmission_type engine_torque engine_horsepower year is_hybrid Automatic transmission 2009 Audi A3 3.2 140 143 202 Audi 18 25 236 250 2009 True 2009 Audi A3 2.0 T AT Automatic 1 140 143 202 Audi 22 28 207 200 2009 True transmission 2 2009 Audi A3 2.0T 140 143 202 Audi 21 30 Manual transmission 207 200 2000 True 2009 Audi A3 2.0 T Automatic 140 143 202 Audi 21 28 207 200 2009 True Quattro transmission Automatic transmission 2009 Audi A3 2.0T 140 143 202 Audi 21 28 207 200 2009 True Quattro 2012 Honda Pilot EX-L Automatic transmission 5070 13 253 201 Honda 18 25 253 250 2012 True 2012 Lamborghini Gallardo Coupe LP 560-4 5071 141 249 108 Lamborghini 12 20 Manual transmission 398 552 2012 True 2012 Lamborghini Gallardo LP 560-4 Spyder 5072 160 249 108 Lamborghini 12 20 Manual transmission 398 552 2012 True 2012 BMW 7401 Sedan Automatic transmission 5073 200 210 110 BMW 17 25 330 315 2012 True 2012 BMW 740LI Sedan Automatic transmission 5074 200 94 110 BMW 17 25 330 315 2012 True 5075 rows x 12 columns Q2,Find the brands of type Audi In [ ]: Q3. Find records of brand Audi in the dataset whose highway_mpg is strictly less than 28. In [ ]: Q. Return a table containing height and length by the average In ( ): Q5. plot the histogram of city_mpg In [ ]: Q6. based on the Q5 what is the most frequent range city Milepergallon In [ ]:
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Counting Problems
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.
Similar questions
  • SEE MORE QUESTIONS
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