Exercise

State joins capitals

You would like to join the wages DataFrame with the state_info DataFrame, which contains information about the states, such as capital, area, and so on. Let's get to it!

There are two versions of the state_info dataset:

  • state_info containing the state column;
  • state_info_original, the original version, which contains the State column.

The DataFrames package has been loaded, along with the wages, state_info, and state_info_original DataFrames.

Instructions 1/2

undefined XP
  • 1
    • Perform a left join of wages with state_info, using the column state, saving the result as wages.
  • 2
    • Perform left join of wages with state_info_original, using the column state from wages and State from state_info_original, saving the result as wages.