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