Question

For Jupyter Notebook we have opened up a file using pandas but I am confused on this question and how to do it.

1. Create a new dataframe that only contains the data where fuel is “regular” AND MPG is over 21. Call it Auto_sub. Label each section using markup to state what you are doing and what you see

Answer 1

#CODE

import pandas as pd
import numpy as np

df=pd.read_csv('database.csv')
df.head()

#IF your MPG contains string type data remove it from dataframe
df=df[df['MPG'].apply(lambda x: True if isinstance(x,int) else False)]
Auto_sub=df[(df['fuel'].str.lower()=='regular') & (df['MPG'] > 21)]#We are using lower to make non-case sensitive

Auto_sub.shape#To get the shape of Auto_sub

Auto_sub.head()#To view the data