extracting column names from a csv file in python

Question

I have a large csv file with 100's of columns in it. Currently im able to read the csv file and its particular row. My file is inside a zipfile and here is the code i have so far.

import os, sys, csv, zipfile

zip_file = zipfile.ZipFile('some_zip_file.zip')
f = zip_file.open('some_csv_file.csv', 'r')

for row in csv.reader(f):
    print row[1]

f.close()

But is there a way to extract only the column names from the csv file? Im using python 2.7

Jason S · Accepted Answer · 2014-08-04 20:33:21Z

3

next(csv.reader(f)) will return just the first row (which is presumably where the column names are.)

answered Aug 4, 2014 at 20:33

Jason S

13.8k2 gold badges42 silver badges43 bronze badges

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

Comments

Guilherme Vierno · Accepted Answer · 2014-08-04 20:34:52Z

1

Just get the first line of the file, by your code:

import os, sys, csv, zipfile

zip_file = zipfile.ZipFile('some_zip_file.zip')
f = zip_file.open('some_csv_file.csv', 'r')

for column in csv.reader(f).next():
    print column
    # collumn_name

Hope that helps.

answered Aug 4, 2014 at 20:34

Guilherme Vierno

1115 bronze badges

Collectives™ on Stack Overflow

extracting column names from a csv file in 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