Your first inner join
You have been tasked with figuring out what the most popular types of fuel used in Chicago taxis are. To complete the analysis, you need to merge the taxi_owners
and taxi_veh
tables together on the vid
column. You can then use the merged table along with the .value_counts()
method to find the most common fuel_type
.
Since you'll be working with pandas
throughout the course, the package will be preloaded for you as pd
in each exercise in this course. Also the taxi_owners
and taxi_veh
DataFrames are loaded for you.
This exercise is part of the course
Joining Data with pandas
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Merge the taxi_owners and taxi_veh tables
taxi_own_veh = taxi_owners.____
# Print the column names of the taxi_own_veh
print(taxi_own_veh.columns)