1. Learn
    2. /
  2. Courses
    3. /
  3. Pandas Joins for Spreadsheet Users

Exercise

Suffixes and indicators

Well, it seems the scatter plot hasn't settled any wagers. And source data in the merged data frame isn't as helpful as you expected: it's hard to tell what data is current and what is from the past when players were drafted. merged data frame

It's time to use some of those optional parameters for .merge() and clarify the data. current and draft are still available from the last exercise.

Instructions 1/4

undefined XP
  • 1
    • Merge the data frames on player_id just as before and view the result.
  • 2
    • Add suffixes of '_current' and '_draft' to clarify the origin of columns. View the result.
  • 3
    • Add the 'indicator' parameter to show the data frame(s) containing each row.
  • 4
    • Finally, sort by player_id using the 'sort' parameter and view the first 5 rows of the result.