-1

I have two dataframes as shown below and I am trying to merge them. But the issue is I want all the values for columns 'Type' to be under 'Type'. For example if I have 5 rows under 'Type' value "000800.00" in DF1 and 3 rows in DF2. I want all 8 rows to be together under the row that and so on. Is there anyway I can do that.

I have attached pictures with sample data for what both Dataframes look like.

Sample DF1 data

Sample DF2 data

ZF007
  • 3,708
  • 8
  • 29
  • 48
Deepak
  • 31
  • 5
  • 1
    Please put the information here instead of attaching screenshots. – Raj Nov 05 '19 at 00:48
  • Does this answer your question? [How to join (merge) data frames (inner, outer, left, right)](https://stackoverflow.com/questions/1299871/how-to-join-merge-data-frames-inner-outer-left-right) – Alessandro Da Rugna Nov 05 '19 at 04:31

1 Answers1

0

Use pd.concat:

pd.concat(['df1','df2'],sort=False,ignore_index0True)
ansev
  • 30,322
  • 5
  • 17
  • 31