How to merge vertically several csv files in Python?

Question

I need to merge vertically the data from several CSV spreadsheets in Python. Their structure is identical, I just need to put one table's data on top of the following because they are the months on an annual survey. I tried several methods I found googling but I can't find a way to do something as simple as:

import csv

spreadsheets1 = open('0113_RE_fscom.csv','r')
spreadsheets2 = open('0213_RE_fscom.csv','r')
spreadsheets = spreadsheets1 + spreadsheets2

with spreadsheet as csvfile:
   sales = csv.reader(csvfile)
   for row in sales:
      print row

Allactaga · Accepted Answer · 2014-05-18 11:12:10Z

2

Looks like you simply forgot to iterate over files. Try this code:

import csv

spreadsheet_filenames = [
    '0113_RE_fscom.csv',
    '0213_RE_fscom.csv',
]

for filename in spreadsheet_filenames:
    with open(filename, 'r') as csvfile:
        sales = csv.reader(csvfile)
        for row in sales:
            print row

answered May 18, 2014 at 11:12

Allactaga

1931 silver badge7 bronze badges

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

Comments

gilsho · Accepted Answer · 2014-05-18 11:07:43Z

0

how about this:

import csv
from itertools import izip

with open('0113_RE_fscom.csv', 'r') as f1, open('0113_RE_fscom.csv', 'r') as f2:
   csv1 = csv.reader(f1, delimiter=',')
   csv2 = csv.reader(f2, delimiter=',')
   for line1, line2 in izip(csv1, csv2):
      print line1 + line2

answered May 18, 2014 at 11:07

gilsho

9217 silver badges11 bronze badges

Comments

Jimmy C · Accepted Answer · 2014-05-18 11:23:33Z

0

This is quite simple with pandas.

import pandas as pd
f1 = pd.read_csv('0113_RE_fscom.csv', header=None)
f2 = pd.read_csv('0213_RE_fscom.csv', header=None)
merged = pd.concat(f1, f2)
merged.to_csv('merged.csv', index=None, header=None)

Remove header=None if your files actually do have a header.

answered May 18, 2014 at 11:23

Jimmy C

9,72013 gold badges50 silver badges68 bronze badges

Collectives™ on Stack Overflow

How to merge vertically several csv files in Python?

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related