PANDAS TUTORIALS

Filtering DataFrames Exercise Answer Key

Answer Key

  1. listings = pd.read_csv('unclean_listings.csv')
  2. listings[listings['transmission' == ' Automatic Transmission']]
  3. listings[(listings['drivetrain'] == ' FWD') | (listings['transmission'] == ' Manual Transmission')]
  4. listings.query("location == ' Chicago, IL'")
  5. listings.query(~"transmission == ' Manual Transmission'")