Separate Rows in reader

Jiewei Huang jiewei24 at gmail.com
Sun Mar 24 09:11:58 CET 2013


On Sunday, March 24, 2013 3:46:49 PM UTC+10, Dave Angel wrote:
> On 03/24/2013 01:20 AM, Jiewei Huang wrote:
> 
> > 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
> 
> >
> 
> 
> 
> There are at least 3 differences to the printouts.  Which difference are 
> 
> you concerned with?
> 
> 
> 
> 1) Moon --> Silly
> 
> 2) square and round brackets in slightly different places
> 
> 3) row 0 suppressed
> 
> 
> 
> Explain which one, or specify a fourth, and also what you have tried to 
> 
> address the question.
> 
> 
> 
> 
> 
> -- 
> 
> DaveA


Sorry my typo in the output here is the correct output that i need :

[('John Konon', 'Ministry of moon Walks', '4567882', '27-Feb'), 
( 'Stacy Kisha', 'Ministry of Man Power', '1234567', 17-Jan')] 

the difference is that i need a [(row two), (row three), (row fouth)] . I do not want to display row one which is ['Name', ' Address', 'Telephone', 'Birthday'] 



More information about the Python-list mailing list