Clarification needed about Python CSV file format parsing

Question

Format is like:

CHINA;2002-06-25 00:00:00.000;5,60
CHINA;2002-06-26 00:00:00.000;5,32
CHINA;2002-06-27 00:00:00.000;5,31

and I try to use Python's CSV tools to parse it but cannot understand the paragraph, source:

And while the module doesn’t directly support parsing strings, it can easily be done:

import csv
for row in csv.reader(['one,two,three']):
    print row

Could someone clarify the line ['one,two,three']? How would you use it with format A;B;C?

Ned Batchelder · Accepted Answer · 2011-01-01 22:44:26Z

3

The docs you quote are talking about the difference between parsing csv data stored in a file, and csv data stored in a string. It doesn't have to do with the format of the data.

You should be able to read your data with something like:

import csv
csv_reader = csv.reader(open('data.csv', 'rb'), delimiter=';')
for row in csv_reader:
    # do something with row....

answered Jan 1, 2011 at 22:44

Ned Batchelder

378k77 gold badges583 silver badges675 bronze badges

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

Collectives™ on Stack Overflow

Clarification needed about Python CSV file format parsing

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related