Splitting string by comma in python

Question

I have a csv file that contains

"VANS, PASSENGER TYPE",CHEVROLET,H1500 EXPRESS AWD,5.3,8,Auto(L4),4,832,9,12,10,11.5,16.2,13.2268,E,,,,,,,,,,3900,310-340,CLKUP ,2,15,30-Jun-07,DERIVED

All I am trying to do is split by comma, do only problem with my current solution is that the first entry which happens to be "VANS, PASSENGER TYPE" has a comma but I am not interested in splitting that.

Currently I am doing something like this

with open("file.txt", "r") as ins:
   foo = ins.split(",")

did not know about that module.... Looks interesting...Let me try that out! — tawheed
– tawheed, Commented Mar 27, 2015 at 2:25

Avinash Raj · Accepted Answer · 2015-03-27 02:35:46Z

6

It's better to use csv module.

import csv
with open('file') as f:
    reader = csv.reader(f)
    for line in reader:
        print(line)

Output:

['VANS, PASSENGER TYPE', 'CHEVROLET', 'H1500 EXPRESS AWD', '5.3', '8', 'Auto(L4)', '4', '832', '9', '12', '10', '11.5', '16.2', '13.2268', 'E', '', '', '', '', '', '', '', '', '', '3900', '310-340', 'CLKUP ', '2', '15', '30-Jun-07', 'DERIVED']

edited Mar 27, 2015 at 2:35

answered Mar 27, 2015 at 2:28

Avinash Raj

175k32 gold badges247 silver badges289 bronze badges

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

Collectives™ on Stack Overflow

Splitting string by comma in python

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