Combine csv files to one csv file in Python 3 [duplicate]

Question

I am a Python beginner but i would like to ask something that i did not find in the forum.

I have multiple csv files into a folder which contain data like this (structure is identical to all of them):

File1.csv

Original
7200
118800
0
-955.8
7075
1080
115628.57
3171.4

File2.csv

And so on.

I would like to make a script in Python 3 that copies them to one csv file one column after another. Could you offer me please some help?

I would recommend looking at the pandas module and the functions to_csv and read_csv and concat. I would probably just do this with the unix tools tr and cat myself. — tommy.carstensen
– tommy.carstensen, Commented May 31, 2017 at 17:09
In the resulting csv file, do you want everything in one long column, or each file added into a new column? — chickity china chinese chicken
– chickity china chinese chicken, Commented May 31, 2017 at 17:14
The assistance of Brad Solomon was great, the solution works like a charm. — mixalis31
– mixalis31, Commented Jun 1, 2017 at 12:03

Brad Solomon · Accepted Answer · 2017-12-01 13:00:48Z

0

Say your files are named File1.csv, File2.csv, and File3.csv.

import pandas as pd

pieces = []
for num in [1, 2, 3]:
    s = pd.read_csv('folder/subfolder/File%d.csv' % num) # your directory
    pieces.append(s)
newcsv = pd.concat(pieces, axis=1) # this will yield multiple columns
newcsv.to_csv('folder/subfolder/newcsv.csv')

edited Dec 1, 2017 at 13:00

answered May 31, 2017 at 17:25

Brad Solomon

41.2k39 gold badges167 silver badges260 bronze badges

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

Comments

marc_s · Accepted Answer · 2017-06-09 12:58:43Z

0

Make sure you have pandas installed and import it like this :

import pandas as pd

Read your two different csv using pd.read_csv():

df1=pd.read_csv('file1.csv')
df2=pd.read_csv('file2.csv')

Then add an other column to your first dataframe using (make sure it's the same size):

df1['Renovated'] = pd.Series(df2['Renovated'],index=df1.index)

In the df1 you should now have two columns do it for as many csv you have.

To finish to save your final csv with all columns just do :

df1.to_csv('finalName.csv', index=False)

edited Jun 9, 2017 at 12:58

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered May 31, 2017 at 17:34

Simon

1731 gold badge2 silver badges10 bronze badges

Collectives™ on Stack Overflow

Combine csv files to one csv file in Python 3 [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related