Combining csv files columns together Pandas Python

Question

I am trying to combine file1-3.csv so that I could get the expected result. I want to combine all the rows together on all 3 file, but disregard the 1st column as it is the same on all 3 files. How can i do this with pandas.

Code:

import pandas as pd 

file1 = pd.read_csv('STDOutputs_Q1.csv')
file2 = pd.read_csv('STDOutputs_Q2.csv')
file3 = pd.read_csv('STDOutputs_Q3.csv')

Inside file1.csv

element,LNPT,SNPT
[ 2.  2. 30.],89,60
[ 2.  2. 40.],999,77

Inside file2.csv

element,MxU,MxD,TT
[ 2.  2. 30.],17127,-3,0
[ 2.  2. 40.],17141,-40,2

Inside file3.csv

element,TNT
[ 2.  2. 30.],1000
[ 2.  2. 40.],30

Expected Results:

element,LNPT,SNPT,MxU,MxD,TT,TNT
[ 2.  2. 30.],89,60,17127,-3,0,1000
[ 2.  2. 40.],999,77,17141,-40,2,30

pd.concat([d.set_index('element') for d in [file1,file2,file3])? — Umar.H
– Umar.H, Commented Apr 17, 2021 at 1:19

Tiger · Accepted Answer · 2021-04-17 01:27:27Z

1

You can use pd.join like:

q1_2 = file1.join(file2, lsuffix='_Q1', rsuffix='_Q2')
file1-3 = q1_2.join(file3,  rsuffix='_Q3')

Or if the 'element' column is the same for all three data frame, and there are no conflicting column names, you can use pd.merge:

q1_2 = file1.merge(file2)
file1-3 = q1_2.merge(file3)

answered Apr 17, 2021 at 1:27

Tiger

132 bronze badges

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

Collectives™ on Stack Overflow

Combining csv files columns together Pandas Python

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