Pandas Joins for Spreadsheet Users
John Miller
Principal Data Scientist
teams.merge(positions, left_on='player_id', right_index=True)
or
positions.merge(teams, left_index=True, right_on='player_id')
current.merge(drafted, on='name', suffixes=('_current', '_drafted'))
current.merge(drafted, how='outer', on='name', suffixes=('_current', '_drafted'),
indicator=True)
current.merge(drafted, on='name', suffixes=('_current', '_drafted'),
sort=True)
Pandas Joins for Spreadsheet Users