How to merge multiple CSV files using Python Pandas

Question

I'm wondering how to merge multiple CSV files using Pandas, but using two specific criteria:

I don't want values to be merged if they have a common key. As in, I don't want data to be merged as it would via a SQL Join. I want all raw data to show as it does in the original CSV file
I want the CSV file values to be merged as new columns, and not as it does in the append function, where it puts the values underneath the first grouping

For example:

CSV File 1
Column A Column B Column C 100 200 300

CSV File 2
Column A Column B Column C 400 500 600

Desired Output
Column A Column B Column C Column A Column B Column C 100 200 300 400 500 600

EdChum · Accepted Answer · 2015-03-19 22:49:12Z

2

You can concatenate them column-wise by passing param axis=1:

In [26]:

pd.concat([df,df1],axis=1)
Out[26]:
   Column A  Column B  Column C  Column A  Column B  Column C
0       100       200       300       400       500       600

answered Mar 19, 2015 at 22:49

EdChum

397k204 gold badges836 silver badges583 bronze badges

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

Collectives™ on Stack Overflow

How to merge multiple CSV files using Python Pandas

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related