0

I have three pandas data frames that look like:

import pandas as pd
df1=pd.dataFrame ({
                 'Bus':['AM','AM','WM','PC','CC'],\
                 'IC/Third':['IC','Third','Third','IC','Third'],\
                 'Line':['PRV','PRV1','PRV2','PRV3','PRV4'],\
                 'Amount':[100,100,100,100,100]\
                  })
df1=df1.groupby(['Bus','IC/Third','Line']).agg({'Amount':'sum'})
df1.reset_index()

df2=df1.groupby(['Bus','Line']).agg({'Amount':'sum'})
df2.reset_index()

df3=pd.merge(df1,df2,on=['Bus','Line'],how='left')
df3

I am trying to join dataframes df1 and df2 but get an error. Any ideas why ?

Number Logic
  • 852
  • 1
  • 9
  • 19

0 Answers0