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.