Separate Rows in reader
ypsun
winter0128 at gmail.com
Sun Mar 24 06:58:48 EDT 2013
Jiewei Huang於 2013年3月24日星期日UTC+1上午6時20分29秒寫道:
> Hi all,
>
>
>
> Currently create a simple text-based database of information about people
>
>
>
>
>
> I have a csv file which consist of 3 rows , row 1 2 and 3 is as such:
>
> Name Address Telephone Birthday
>
> John Konon Ministry of Moon Walks 4567882 27-Feb
>
> Stacy Kisha Ministry of Man Power 1234567 17-Jan
>
>
>
>
>
> My codes are :
>
> import csv
>
> original = file('friends.csv', 'rU')
>
> reader = csv.reader(original)
>
>
>
> for row in reader:
>
>
>
> print row
>
>
>
>
>
> and the output is :
>
> ['Name', ' Address', 'Telephone', 'Birthday']
>
> ['John Konon', 'Ministry of Moon Walks', '4567882', '27-Feb']
>
> ['Stacy Kisha', 'Ministry of Man Power', '1234567', '17-Jan']
>
>
>
> But i wanted to make it
>
>
>
> [('John Cleese', 'Ministry of Silly Walks', '5555421', '27-Feb'),
>
> ( 'Stacy Kisha', 'Ministry of Man Power', '1234567', 17-Jan')]
>
>
>
> can someone show me guidance to this issue
>
>
>
> Thanks all
import csv
original = file('friends.csv', 'rU')
reader = csv.reader(original)
result = []
for row in reader:
result.append(tuple(row))
else:
print result[1:]
Is this what you need?
but this allocates memory and will be a trouble when you have a big table :P
Note that I assume your csv file content are comma seperated.
More information about the Python-list
mailing list