PANDAS TUTORIALS

Answer Key

1. american_listings = pd.read_csv('american_listings.csv')
2. non_american_listings = pd.read_csv('non_american_listings.csv')
3. listings_subset_a = pd.read_csv('subsetA.csv')
4. listings_subset_b = pd.read_csv('subsetB.csv')
5. listings_subset_a.merge(listings_subset_b, on='vin')
6. american_listings.merge(non_american_listings, on='vin', how='outer', suffixes=(['_american', '_non_american']))
7. listings_subset_a.merge(listings_subset_b, on='vin', how='left', indicator=True)