Joining Tables

# This 'str' operation splits each candidiate's full name at each
# blank space, then takes just the candidiate's first name
elections["First Name"] = elections["Candiate"].str.split().str[0]
elections.head(5)

https://ds100.org/course-notes/pandas_3/pandas_3.html#groupby-continued

 

# Here, we'll only consider `babynames` data from 2020
babynames_2020 = babynames[babynames["Year"]==2020]
babynames_2020.head()

https://ds100.org/course-notes/pandas_3/pandas_3.html#groupby-continued

 

Now, ready to join two tables.

pd.merge()

merged = pdmerge(left = elections, right = babynames_2020, \
					left_on = "First Name", right_on = "Name")
merged.head()
# Notice that pandas automatically specifies 'Year_x' and 'Year_y'
# when both merged DataFrames have the same column name to avoid confusion