Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #41815

Re: Separate Rows in reader

X-Received by 10.224.172.134 with SMTP id l6mr6145137qaz.7.1364194371702; Sun, 24 Mar 2013 23:52:51 -0700 (PDT)
X-Received by 10.50.135.10 with SMTP id po10mr2192981igb.4.1364194371661; Sun, 24 Mar 2013 23:52:51 -0700 (PDT)
Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!ca1no5883053qab.0!news-out.google.com!k8ni11100qas.0!nntp.google.com!ca1no5883052qab.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups comp.lang.python
Date Sun, 24 Mar 2013 23:52:50 -0700 (PDT)
In-Reply-To <adf4e759-2825-4ec8-9992-a0a6a91c0843@googlegroups.com>
Complaints-To groups-abuse@google.com
Injection-Info glegroupsg2000goo.googlegroups.com; posting-host=130.102.82.130; posting-account=Ku_GgAoAAACcsiNwXg5lFaSDSrqhcidb
NNTP-Posting-Host 130.102.82.130
References <fdcdb6d8-c63a-4909-8b56-13204a0d474c@googlegroups.com> <adf4e759-2825-4ec8-9992-a0a6a91c0843@googlegroups.com>
User-Agent G2/1.0
MIME-Version 1.0
Message-ID <4e1e93e5-14bd-4408-9c92-3c340e558deb@googlegroups.com> (permalink)
Subject Re: Separate Rows in reader
From Jiewei Huang <jiewei24@gmail.com>
Injection-Date Mon, 25 Mar 2013 06:52:51 +0000
Content-Type text/plain; charset=UTF-8
Content-Transfer-Encoding quoted-printable
Xref csiph.com comp.lang.python:41815

Show key headers only | View raw

On Sunday, March 24, 2013 9:10:45 PM UTC+10, ypsun wrote:
> 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)
> 
> print [tuple(row) for row in reader][1:]
> 
> 
> 
> is this you want?
> 
> Note that:
> 
>     1) I assume your csv file content are seperated by comma
> 
>     2) this way allocates your memory, will be a trouble when a big table :P

Hi guys, i got into another situation i was told not to use csv library and currently my code is :

f = open('friends.csv', 'rU')
for row in f:
        
        print [row for (row) in f]

output :
['John Cleese,Ministry of Silly Walks,5555421,27-Oct\n', 'Stacy Kisha,Ministry of Man Power,1234567,17-Jan\n']

i need it to become :
[('John Cleese', 'Ministry of Silly Walks', '5555421', '27-Oct'), ('Stacy Kisha', 'Ministry of Man Power', '1234567', '17-Jan')]

guide me please

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Separate Rows in reader Jiewei Huang <jiewei24@gmail.com> - 2013-03-23 22:20 -0700
  Re: Separate Rows in reader Dave Angel <davea@davea.name> - 2013-03-24 01:46 -0400
    Re: Separate Rows in reader rusi <rustompmody@gmail.com> - 2013-03-24 00:34 -0700
      Re: Separate Rows in reader Jiewei Huang <jiewei24@gmail.com> - 2013-03-24 01:18 -0700
    Re: Separate Rows in reader Jiewei Huang <jiewei24@gmail.com> - 2013-03-24 01:11 -0700
      Re: Separate Rows in reader Dave Angel <davea@davea.name> - 2013-03-24 09:03 -0400
      Re: Separate Rows in reader Tim Chase <python.list@tim.thechases.com> - 2013-03-24 08:49 -0500
        Re: Separate Rows in reader rusi <rustompmody@gmail.com> - 2013-03-24 08:57 -0700
          Re: Separate Rows in reader Tim Chase <python.list@tim.thechases.com> - 2013-03-24 13:28 -0500
            Re: Separate Rows in reader rusi <rustompmody@gmail.com> - 2013-03-24 19:08 -0700
    Re: Separate Rows in reader Jiewei Huang <jiewei24@gmail.com> - 2013-03-24 01:11 -0700
  Re: Separate Rows in reader ypsun <winter0128@gmail.com> - 2013-03-24 03:58 -0700
  Re: Separate Rows in reader ypsun <winter0128@gmail.com> - 2013-03-24 04:10 -0700
    Re: Separate Rows in reader Jiewei Huang <jiewei24@gmail.com> - 2013-03-24 23:52 -0700
      Re: Separate Rows in reader rusi <rustompmody@gmail.com> - 2013-03-25 06:51 -0700
        Re: Separate Rows in reader Jiewei Huang <jiewei24@gmail.com> - 2013-03-25 18:05 -0700
          Re: Separate Rows in reader Dave Angel <davea@davea.name> - 2013-03-25 21:40 -0400
            Re: Separate Rows in reader Jiewei Huang <jiewei24@gmail.com> - 2013-03-25 20:33 -0700
              Re: Separate Rows in reader MRAB <python@mrabarnett.plus.com> - 2013-03-26 03:48 +0000
                Re: Separate Rows in reader Jiewei Huang <jiewei24@gmail.com> - 2013-03-26 00:24 -0700
                Re: Separate Rows in reader Jiewei Huang <jiewei24@gmail.com> - 2013-03-26 00:24 -0700
                Re: Separate Rows in reader Jiewei Huang <jiewei24@gmail.com> - 2013-03-27 02:35 -0700
                Re: Separate Rows in reader rusi <rustompmody@gmail.com> - 2013-03-27 04:18 -0700
                Re: Separate Rows in reader Jiewei Huang <jiewei24@gmail.com> - 2013-03-27 15:12 -0700
                Re: Separate Rows in reader Jiewei Huang <jiewei24@gmail.com> - 2013-03-27 15:26 -0700
                Re: Separate Rows in reader rusi <rustompmody@gmail.com> - 2013-03-27 18:24 -0700
                Re: Separate Rows in reader Steven D'Aprano <steve+comp.lang.python@pearwood.info> - 2013-03-28 01:32 +0000
                Re: Separate Rows in reader Jiewei Huang <jiewei24@gmail.com> - 2013-03-27 02:35 -0700
                Re: Separate Rows in reader Tim Roberts <timr@probo.com> - 2013-03-28 21:28 -0700
            Re: Separate Rows in reader Jiewei Huang <jiewei24@gmail.com> - 2013-03-25 20:33 -0700
  Re: Separate Rows in reader Jiewei Huang <jiewei24@gmail.com> - 2013-03-24 18:15 -0700

csiph-web