1. Learn
    2. /
  2. Courses
    3. /
  3. Intro to data.world in Python

Exercise

Working with multiple datasets

You can load as many different datasets as you’d like from data.world and work with them together. Here we’ve used the load_dataset method to bring in two separate datasets, assigning them each to a variable.

We’ll leave it to you to create a dataframe for each using the dataframes property, and then merge the two dataframes together on the state and stusab fields.

After merging them together, add a new citystate field to your merged dataset, populating it with the concatenated values of the city and state_name fields, separated by , resulting in a city, state format.

Instructions

100 XP
  • Create a police_shootings dataframe from the fatal_police_shootings_data table in int_dataset
  • Create a state_abbrvs dataframe from the statesfipscodes table in fipsCodes_dataset
  • Merge the two dataframes together on the state and stusab fields using the merge() function. Assign to merged_dataframe.
  • Add a citystate column to your merged dataframe, populating it with the concatinated values from the city and state_name columns, separated by ', '.
  • Print first 5 rows of merged dataframe