我有一個(gè)名為“合并人身”的數(shù)據(jù)幀： OverallAtt201819 OverallAttCurrentstudents 5bf3e06e9a892068705d8415 98.670213 93.3333335bf3e06e9a892068705d8416 97.340426 98.3606565bf3e06e9a892068705d8417 98.936170 95.0000005bf3e06e9a892068705d8418 98.936170 97.5409845bf3e06e9a892068705d8419 98.404255 97.540984我還有另一個(gè)名為“這年”的數(shù)據(jù)幀：students5bf3e06e9a892068705d8415 22400.05bf3e06e9a892068705d8416 24000.05bf3e06e9a892068705d8417 22800.05bf3e06e9a892068705d8418 23800.05bf3e06e9a892068705d8419 23800.0但是，當(dāng)我嘗試根據(jù)學(xué)生將兩個(gè)數(shù)據(jù)幀合并在一起時(shí)，它會(huì)重新創(chuàng)建學(xué)生列，而不是合并它。這是我的代碼：MergeAttendance2 = pd.merge(MergeAttendance, ThisYearSess, on='students')這是它產(chǎn)生的東西： OverallAtt201819 OverallAttCurrent \students 5bf3e06e9a892068705d8415 98.670213 93.333333 5bf3e06e9a892068705d8416 97.340426 98.360656 5bf3e06e9a892068705d8417 98.936170 95.000000 5bf3e06e9a892068705d8418 98.936170 97.540984 5bf3e06e9a892068705d8419 98.404255 97.540984 OverallSessionsAttendedSoFar students 5bf3e06e9a892068705d8415 22400.0 5bf3e06e9a892068705d8416 24000.0 5bf3e06e9a892068705d8417 22800.0 5bf3e06e9a892068705d8418 23800.0 5bf3e06e9a892068705d8419 23800.0 如何阻止它再次添加到學(xué)生列中？
1 回答
慕容3067478
TA貢獻(xiàn)1773條經(jīng)驗(yàn) 獲得超3個(gè)贊
IIUC：并且列被設(shè)置為兩個(gè)數(shù)據(jù)幀中的您的，那么您可以嘗試以下操作：studentsindex
MergeAttendance2 = MergeAttendance.merge(ThisYearSess, left_index=True, right_index=True, how="outer")
print(MergeAttendance2)
輸出：
OverallAtt201819 OverallAttCurrent OverallSessionsAttendedSoFar
students
5bf3e06e9a892068705d8415 98.670213 93.333333 22400.0
5bf3e06e9a892068705d8416 97.340426 98.360656 24000.0
5bf3e06e9a892068705d8417 98.936170 95.000000 22800.0
5bf3e06e9a892068705d8418 98.936170 97.540984 23800.0
5bf3e06e9a892068705d8419 98.404255 97.540984 23800.0
添加回答
舉報(bào)
0/150
提交
取消