e. Filter the vehicles that have mpg greater than 40 (inclusive) and acceleration greater than 11 (inclusive)f. Create a new dataset (variable) called ‘averages’ that groups by class and calculates means of msrp, acceleration and mpgg. Using ‘averages’ data, create the following 3 lineplots: mean msrp (y-axis) vs. class (x-axis), mean acceleration (y-axis) vs. class (x-axis) and mpg (y-axis) vs. class (x-axis) vehiclePrius (1st Gen)Tino2000 35354.97Prius (2nd Gen) 2000 26832.25Insight200018936.41Civic (1st Gen)200125833.38Insight2001 19036.71Insight200219137.01Alphard2003 38084.77Insight2003 19137.01Civic200314071.922004 36676.12004 19237.31200420355.64200430089.64200558521.14200526354.44200529186.21200519387.76200518236.33200519322.562005 16343.69200532647.26200634772.42006 29853.25200664547.56200636012.72006 29524.75EscapeInsightPriusSilverado 15 2WDLexus RX400hCivic (2nd Gen)HighlanderInsightCivicEscape 2WDAccordSilverado 15 2WDMercury MarinerCamryLexus GS450hEstimaAltimayear msrp1997 24509.74acceleration mpg class7.46 41.26 Compact8.254.1 Compact7.97 45.23 Compact9.52 53.0 Two Seater7.04 47.04 Compact9.52 53.0 Two Seater9.71 53.0 Two Seater8.33 40.46 Minivan9.52 53.0 Two Seater8.62 41.0 Compact10.32 31.99 SUV9.35 52.0 Two Seater9.9 46.0 Midsize9.0912.76 28.23 SUV7.63 39.99 Compact12.7629.4 SUV9.71 52.0 Two Seater8.2641.0 Compact9.52 29.0 SUV14.93 28.0 Midsize11.11 17.0 Pickup Truck8.98 32.93 SUV11.28 33.64 Midsize18.65 33.4 Midsize9.26 47.04 Minivan13.29 32.93 Midsize17.0 Pickup Truck

NOTE: Since programming langauge is not mentioned. Therefore answering question in Python…

Answered: e. Filter the vehicles that have mpg…

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

See similar textbooks

Related questions

Concept explainers

Question

e. Filter the vehicles that have mpg greater than 40 (inclusive) and acceleration greater than 11 (inclusive)

f. Create a new dataset (variable) called ‘averages’ that groups by class and calculates means of msrp, acceleration and mpg

g. Using ‘averages’ data, create the following 3 lineplots: mean msrp (y-axis) vs. class (x-axis), mean acceleration (y-axis) vs. class (x-axis) and mpg (y-axis) vs. class (x-axis)

vehicle
Prius (1st Gen)
Tino
2000 35354.97
Prius (2nd Gen) 2000 26832.25
Insight
2000
18936.41
Civic (1st Gen)
2001
25833.38
Insight
2001 19036.71
Insight
2002
19137.01
Alphard
2003 38084.77
Insight
2003 19137.01
Civic
2003
14071.92
2004 36676.1
2004 19237.31
2004
20355.64
2004
30089.64
2005
58521.14
2005
26354.44
2005
29186.21
2005
19387.76
2005
18236.33
2005
19322.56
2005 16343.69
2005
32647.26
2006
34772.4
2006 29853.25
2006
64547.56
2006
36012.7
2006 29524.75
Escape
Insight
Prius
Silverado 15 2WD
Lexus RX400h
Civic (2nd Gen)
Highlander
Insight
Civic
Escape 2WD
Accord
Silverado 15 2WD
Mercury Mariner
Camry
Lexus GS450h
Estima
Altima
year msrp
1997 24509.74
acceleration mpg class
7.46 41.26 Compact
8.2
54.1 Compact
7.97 45.23 Compact
9.52 53.0 Two Seater
7.04 47.04 Compact
9.52 53.0 Two Seater
9.71 53.0 Two Seater
8.33 40.46 Minivan
9.52 53.0 Two Seater
8.62 41.0 Compact
10.32 31.99 SUV
9.35 52.0 Two Seater
9.9 46.0 Midsize
9.09
12.76 28.23 SUV
7.63 39.99 Compact
12.76
29.4 SUV
9.71 52.0 Two Seater
8.26
41.0 Compact
9.52 29.0 SUV
14.93 28.0 Midsize
11.11 17.0 Pickup Truck
8.98 32.93 SUV
11.28 33.64 Midsize
18.65 33.4 Midsize
9.26 47.04 Minivan
13.29 32.93 Midsize
17.0 Pickup Truck

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 4 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions