组合三个不同长度的数据帧

Question

我为此事的长度提前道歉。我正在尝试合并三个不同长度的数据帧，并遇到了一个问题。我将前两个数据帧合并在一起，然后将第三个数据帧合并到该数据帧中

这是第一个数据帧：

                                  id      home team        away team           start time                 site home spread away spread home odds away odds
0   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00              FanDuel         2.0        -2.0      -114      -106
1   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00            BetRivers         1.5        -1.5      -110      -112
2   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00               Unibet         1.5        -1.5      -110      -111
3   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00  Barstool Sportsbook         1.5        -1.5      -110      -112
4   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00           SugarHouse         1.5        -1.5      -110      -112
5   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00           DraftKings         1.5        -1.5      -110      -112
6   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00               BetMGM         2.0        -2.0      -105      -115
7   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00         BetOnline.ag         2.0        -2.0      -111      -111
8   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00            LowVig.ag           2          -2      -107      -103
9   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00    William Hill (US)         2.0        -2.0      -110      -110
10  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00       PointsBet (US)         1.5        -1.5      -110      -110
11  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00               Bovada         1.5        -1.5      -105      -115
12  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00               GTbets         1.5        -1.5      -109      -109
13  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00            Intertops        2.00       -2.00      -115      -105
14  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00          MyBookie.ag         0.0         0.0      -110      -110
15  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00              Caesars         2.0        -2.0      -110      -110

这是第二个：

                                  id      home team        away team           start time                 site  total over line under line
0   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00              FanDuel  238.5      -114       -106
1   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00            BetRivers  238.0      -113       -109
2   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00               Unibet    238      -112       -109
3   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00  Barstool Sportsbook  238.0      -113       -109
4   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00           SugarHouse  238.0      -113       -109
5   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00           DraftKings    238      -113       -109
6   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00               BetMGM  237.5      -115       -105
7   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00         BetOnline.ag    238      -115       -105
8   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00            LowVig.ag    238      -110        100
9   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00    William Hill (US)    238      -110       -110
10  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00       PointsBet (US)    238      -115       -105
11  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00               Bovada    238      -115       -105
12  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00            Bookmaker    238      -110       -110
13  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00            Intertops    238      -110       -110
14  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00          MyBookie.ag  237.5      -110       -110

我一直在使用x_df =pd.merge(xo,xt,how='left',left_on=['id','home team','away team','start time','site'],right_on=['id','home team','away team','start time','site'])合并它们

结果是：

                                  id      home team        away team           start time                 site home spread away spread home odds away odds  total over line under line
0   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00              FanDuel         2.0        -2.0      -114      -106  238.5      -114       -106
1   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00            BetRivers         1.5        -1.5      -110      -112  238.0      -113       -109
2   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00               Unibet         1.5        -1.5      -110      -111    238      -112       -109
3   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00  Barstool Sportsbook         1.5        -1.5      -110      -112  238.0      -113       -109
4   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00           SugarHouse         1.5        -1.5      -110      -112  238.0      -113       -109
5   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00           DraftKings         1.5        -1.5      -110      -112    238      -113       -109
6   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00               BetMGM         2.0        -2.0      -105      -115  237.5      -115       -105
7   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00         BetOnline.ag         2.0        -2.0      -111      -111    238      -115       -105
8   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00            LowVig.ag           2          -2      -107      -103    238      -110        100
9   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00    William Hill (US)         2.0        -2.0      -110      -110    238      -110       -110
10  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00       PointsBet (US)         1.5        -1.5      -110      -110    238      -115       -105
11  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00               Bovada         1.5        -1.5      -105      -115    238      -115       -105
12  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00               GTbets         1.5        -1.5      -109      -109    NaN       NaN        NaN
13  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00            Intertops        2.00       -2.00      -115      -105    238      -110       -110
14  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00          MyBookie.ag         0.0         0.0      -110      -110  237.5      -110       -110
15  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:40:00              Caesars         2.0        -2.0      -110      -110    NaN       NaN        NaN

第一个数据帧中存在第二个数据帧中没有的站点，反之亦然。在排列和总边上都应该有nulls。我认为数据帧也应该有更多的行

这是第三个数据帧：

                                  id      home team        away team           start time                 site home line away line
0   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00              FanDuel       108      -126
1   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00            BetRivers       102      -121
2   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00               Unibet       102      -120
3   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00  Barstool Sportsbook       102      -121
4   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00           SugarHouse       102      -121
5   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00           DraftKings       102      -121
6   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00               BetMGM       110      -135
7   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00         BetOnline.ag       106      -127
8   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00            LowVig.ag       106      -126
9   658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00              Betfair       114      -116
10  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00    William Hill (US)       105      -125
11  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00       PointsBet (US)       105      -125
12  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00               Bovada       105      -125
13  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00               GTbets       101      -129
14  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00            Bookmaker       100      -120
15  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00            Intertops       105      -125
16  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00          MyBookie.ag       105      -125
17  658e6acd85f15c5da10e271d25835b1b  Brooklyn Nets  Milwaukee Bucks  2021-06-07 19:45:00              Caesars       110      -130

第三个数据帧中的站点不在其他两个数据帧中

当我尝试使用x_df2 =pd.merge(xh,x_df,how='inner',left_on=['id','home team','away team','start time','site'],right_on=['id','home team','away team','start time','site'])将其与另一个合并的数据帧合并时，结果是一个空数据帧

组合这三个数据帧的最佳方式是什么？先谢谢你