merge csv files - python

Question

I am using a for loop to merge csv files on jupyter notebook, however my result returns a list instead of a dataframe. Could someone help me and tell me what I am doing wrong? Thank you in advance.

files = ['babd_light_z1.csv','babd_light_z2.csv','babd_light_z3.csv']
data = []
for f in files:
     data.append(pd.read_csv(f))

type(data) # returns  list

Change data = [] to data = pd.DataFrame() and reassign data in the loop body. — timgeb
– timgeb, Commented May 17, 2020 at 8:56

TonyV · Accepted Answer · 2020-05-22 07:25:09Z

1

You can simply use pd.concat(data, axis=0, ignore_index=True) outside your loop to merge your csv files as in:

files = ['babd_light_z1.csv', 'babd_light_z2.csv', 'babd_light_z3.csv']

data = []

for f in files:
    data.append(pd.read_csv(f))

df = pd.concat(data, axis=0, ignore_index=True)

type(df) should return pandas.core.frame.DataFrame

answered May 22, 2020 at 7:25

TonyV

4414 silver badges5 bronze badges

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

Comments

Balaji Ambresh · Accepted Answer · 2020-05-17 09:02:51Z

0

Give this a shot:

combined = pd.combine(data, axis=0)

answered May 17, 2020 at 9:02

Balaji Ambresh

5,0022 gold badges7 silver badges17 bronze badges

Collectives™ on Stack Overflow

merge csv files - python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related