import pandas as pd
# Read in the data: 1to1 left.csv 1to1 right.csv
L = pd.read_csv('1to1 left.csv')
Key | Veggies | |
0 | Mon | Broccoli |
1 | Tue | Celery |
2 | Thu | Lettuce |
3 | Fri | Spinach |
R = pd.read_csv('1to1 right.csv')
Key | Fruits | |
0 | Mon | Apples |
1 | Wed | Bananas |
2 | Thu | Cherries |
3 | Sat | Dates |
pd.merge(L,R, how='left')
Key | Veggies | Fruits | |
0 | Mon | Broccoli | Apples |
1 | Tue | Celery | NaN |
2 | Thu | Lettuce | Cherries |
3 | Fri | Spinach | NaN |
Functions referenced:
--- The End ---