import pandas as pd
# Read in the data: ManytoMany left.csv ManytoMany right.csv
L = pd.read_csv('ManytoMany left.csv')
Key | Veggies | |
0 | Mon | Broccoli |
1 | Mon | Celery |
2 | Mon | Lettuce |
3 | Wed | Broccoli |
4 | Wed | Celery |
5 | Thu | Broccoli |
6 | Thu | Celery |
7 | Thu | Lettuce |
8 | Fri | Broccoli |
9 | Fri | Celery |
R = pd.read_csv('ManytoMany 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 | Wed | Cherries |
8 | Fri | Apples |
pd.merge(L,R, how='outer')
Key | Veggies | Fruits | |
0 | Mon | Broccoli | Apples |
1 | Mon | Broccoli | Bananas |
2 | Mon | Broccoli | Cherries |
3 | Mon | Celery | Apples |
4 | Mon | Celery | Bananas |
5 | Mon | Celery | Cherries |
6 | Mon | Lettuce | Apples |
7 | Mon | Lettuce | Bananas |
8 | Mon | Lettuce | Cherries |
9 | Wed | Broccoli | Apples |
10 | Wed | Broccoli | Cherries |
11 | Wed | Broccoli | Cherries |
12 | Wed | Celery | Apples |
13 | Wed | Celery | Cherries |
14 | Wed | Celery | Cherries |
15 | Thu | Broccoli | NaN |
16 | Thu | Celery | NaN |
17 | Thu | Lettuce | NaN |
18 | Fri | Broccoli | Apples |
19 | Fri | Celery | Apples |
20 | Tue | NaN | Apples |
21 | Tue | NaN | Bananas |
Functions referenced:
--- The End ---