Extracting data from a CSV file in Python

Question

I just got my data and it is given to me as a csv file.

It looks like this in data studio(where the file was taken).

Counts  frequency
300     1
302     5
303     7

Excel can't handle the computations so that's why I'm trying to load it in python(it has scipy :D).

I want to load the data in an array:

Counts = [300, 302, 303]
frequency = [1, 5, 7]

How will I code this?

Daniel Roseman · Accepted Answer · 2009-10-06 16:18:31Z

9

Use the Python csv module.

answered Oct 6, 2009 at 16:18

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

1 Comment

Sam007 Over a year ago

my delimiter is ' how do I use the delimiter= then?

nosklo · Accepted Answer · 2009-10-06 16:47:09Z

7

import csv

counts = []
frequencies = []

for d in csv.DictReader(open('yourfile.csv'), delimiter='\t'):
    counts.append(int(d['Counts']))
    frequencies.append(int(d['frequency']))

print 'Counts = ', counts
print 'frequency = ', frequencies

answered Oct 6, 2009 at 16:47

nosklo

224k58 gold badges299 silver badges299 bronze badges

3 Comments

wildfire Over a year ago

an error appears saying that there's no such file as data.csv

S.Lott Over a year ago

@wildfire: When using this code, perhaps you should include the actual name for your actual .csv file in your actual working directory.

nosklo Over a year ago

@wildfire: of course you need to include the full path to the file on your system, instead of the example "yourfile.csv" I've put into the code.

Collectives™ on Stack Overflow

Extracting data from a CSV file in Python

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related