How I can merge two pandas pivot tables? When I try run my code I have error: keyerror
JavaScriptx61data_pivot= pandas.DataFrame(data.pivot_table(values = 'NR_ACTIONS', index=["HOUR", "OPID", "NAME"], columns='CONTACTED_PERSON_NEW', aggfunc='sum'))2data_pivot.fillna(0, inplace=True)3data2_pivot= pandas.DataFrame(data2.pivot_table(values = 'AMOUNT_PA', index=["HOUR", "OPID", "NAME"], columns='PA_TYPE', aggfunc='sum'))4data2_pivot.fillna(0, inplace=True)5all_data = pandas.merge(data_pivot, data2_pivot, 'left', on = ["HOUR", "OPID", "NAME"] )6
Advertisement
Answer
answer for my question is :
JavaScript
1
8
1
data_pivot= pandas.DataFrame(data.pivot_table(values = 'NR_ACTIONS', index=["HOUR", "OPID", "NAME"], columns='CONTACTED_PERSON_NEW', aggfunc='sum'))2
data_pivot.fillna(0, inplace=True)3
data_pivot.reset_index( inplace=True)4
data2_pivot= pandas.DataFrame(data2.pivot_table(values = 'AMOUNT_PA', index=["HOUR", "OPID", "NAME"], columns='PA_TYPE', aggfunc='sum'))5
data2_pivot.fillna(0, inplace=True)6
data2_pivot.reset_index( inplace=True)7
all_data = pandas.merge(data_pivot, data2_pivot, 'left', on = ["HOUR", "OPID", "NAME"] )8