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.
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.
This exercise is part of the course
Pandas Joins for Spreadsheet Users
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Merge data frames and view the result
players = ____.merge(draft, how='outer', ____=True, ____='player_id')
print(____.head())