Pandas 교차 조인

1 개요

Pandas 교차 조인

Pandas 크로스 조인

Python

CPU

4.0s

MEM

96M

4.1s

Reload

Copy

import pandas as pd
df1 = pd.DataFrame({'Date':['1/1/2020','1/2/2020','1/3/2020','1/4/2020'],'CountryID':[1,1,3,4],'Units': [40,25,30,35]})
df1

	Date	CountryID	Units
0	1/1/2020	1	40
1	1/2/2020	1	25
2	1/3/2020	3	30
3	1/4/2020	4	35

Copy

df2 = pd.DataFrame({'ID':[1,2,3],'County':['USA','Canada','Panama']})
df2

	ID	County
0	1	USA
1	2	Canada
2	3	Panama

Copy

df1['key'] = 1
df2['key'] = 1
pd.merge(df1, df2, on='key').drop(columns='key')

	Date	CountryID	Units	ID	County
0	1/1/2020	1	40	1	USA
1	1/1/2020	1	40	2	Canada
2	1/1/2020	1	40	3	Panama
3	1/2/2020	1	25	1	USA
4	1/2/2020	1	25	2	Canada
5	1/2/2020	1	25	3	Panama
6	1/3/2020	3	30	1	USA
7	1/3/2020	3	30	2	Canada
8	1/3/2020	3	30	3	Panama
9	1/4/2020	4	35	1	USA
10	1/4/2020	4	35	2	Canada
11	1/4/2020	4	35	3	Panama

2 같이 보기

• 교차 조인
• Pandas 조인

3 참고

• https://www.geeksforgeeks.org/python-program-to-perform-cross-join-in-pandas/