One-to-many merge with multiple tables
In this exercise, assume that you are looking to start a business in the city of Chicago. Your perfect idea is to start a company that uses goats to mow the lawn for other businesses. However, you have to choose a location in the city to put your goat farm. You need a location with a great deal of space and relatively few businesses and people around to avoid complaints about the smell. You will need to merge three tables to help you choose your location. The land_use
table has info on the percentage of vacant land by city ward. The census
table has population by ward, and the licenses
table lists businesses by ward.
The land_use
, census
, and licenses
tables have been 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 land_use and census and merge result with licenses including suffixes
land_cen_lic = ____