Separate Rows in reader

[rusi]

On Mar 24, 10:46 am, Dave Angel <da... at davea.name> 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

Besides does it work as you are describing?
ie your input appears to be tab delimited, whereas the default is ','