How can I combine different dataframes into one csv in Python?

Question

I have 2 dataframes with different columns. And I want to combine those into 1 csv file. Both headers should be included and there shouldn't be empty value if columns aren't matched.

df1: Test1|Test2|Test3
       1  |  2  | 3

df2: Test4|Test5|Test6
       4  |  5  | 6

I tried to use pd.concat, but I need the result to be like below:

Test1|Test2|Test3
  1  |  2  | 3
Test4|Test5|Test6
  4  |  5  | 6

Mateo Torres · Accepted Answer · 2022-04-28 12:34:48Z

3

You can do this using Pandas to_csv and setting the mode parameter to "a" for the second DataFrame to avoid overwriting the contents.

df1.to_csv("output.csv", index=False)
df2.to_csv("output.csv", index=False, mode="a")

edited Apr 28, 2022 at 12:34

answered Apr 28, 2022 at 12:23

Mateo Torres

1,6251 gold badge14 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Conquering Over a year ago

Wow! I didn't know about mode="a" until I see your answer. Thanks a lot!

Collectives™ on Stack Overflow

How can I combine different dataframes into one csv in Python?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related