I Have a question about how to merge dataframe using conditon.
I have two dataframe
df1:
Pro fg material_df1 qty_df1
01 f01 m01 1
01 f01 m02 1
01 f01 m03 1
01 f01 m05 1
02 f01 m01 2
02 f01 m03 2
df2:
fg material_df2 qty_df2
fg01 m01 1
fg01 m02 1
fg01 m03 1
fg01 m04 1
Result :
PRO fg material_df1 qty_df1 material_df2 qty_df2
01 f01 m01 1 m01 1
01 f01 m02 1 m02 1
01 f01 m03 1 m03 1
01 f01 NAN NAN m04 1
01 f01 m05 1 NAN NAN
02 f02 m01 2 m01 1
02 f02 m03 2 m03 1
02 f02 NAN NAN m02 1
02 f02 NAN NAN m04 1
Joni Wekin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.