0

I have 2 dataframes df1 and df2 having columns as df1['date','customer_id','category_name'] and df2['date','customer_id','category_name']. I want values from df1 which matches in df2 on columns 'customer_id' & 'category_name'.

So I tried this:

df_final = df1[(df1['customer_id']==df2['customer_id'])&(df1['category_name']==df2['category_name'])]

but it is showing 'ValueError: Can only compare identically-labeled Series objects' dataframes enter image description here

ThePyGuy
  • 17,779
  • 5
  • 18
  • 45
LALIT GAUTAM
  • 3
  • 1

1 Answers1

0

Try using merge

df_final = pd.merge(df1, df2, on=["customer_id", "category_name"], how="left")
Raymond Toh
  • 779
  • 1
  • 8
  • 27