import pandas as pd
raw_data1 = {'name': ['Willard Morris', 'Al Jennings', 'Omar Mullins', 'Spencer McDaniel'], 'age': [20, 19, 22, 21], 'favorite_color': ['blue', 'blue', 'yellow', "green"], 'test_one': [88, 92, 95, 70]} df1 = pd.DataFrame(raw_data1) df1
raw_data2 = {'name': ['Willard Morris', 'Al Jennings', 'Omar Mullins', 'Spencer McDaniel'], 'test_two': [87, 94, 97, 72], 'test_three': [78, 100, 90, 85]} df2 = pd.DataFrame(raw_data2) df2
df3 = df1.merge(df2, how='left', on="name") df3.head()
Get better at data science interviews by solving a few questions per week
Find a bug? Submit a suggested change on Github, or message me on Twitter.