[Tutor] CSV Ouptut concern...

[Joel Goldstick]

On Thu, Mar 17, 2011 at 8:53 AM, Dipo Elegbede <delegbede at dudupay.com>wrote:

>
> Thanks Tim, that worked like magic.
>
> I now have another challenge on the same file, in this case, i am trying to
> extract just a column as PARTY, I successfully wrote the header but instead
> of having each element in a single excel block like this:
>
> A
> ACD
> ACN
> ACPN
> AD
> ADC
> ALP
> ANPP
> APGA
> APS
> ARP
> BNPP
> CAP
> CDC
> CPC
> CPN
> CPP
> DFPF
> DPP
>
> It is spelt out on different block like this:
>
>  PARTY    A    A C D   A C N   A C P N  A D   A D C   A L P   A N P P  A P
> G A  A P S   A R P   B N P P  C A P   C D C   C P C   C P N   C P P   D F
> P F  D P P
>
>
>
>
> what could be wrong with this code:
>
> import csv
>
> reader = csv.reader(open('stateparty.csv'))
> counter = 1
> header = ["PARTY"]
> fh = open('stateparty3.csv','wb')
> writer = csv.writer(fh)
> writer.writerow(header)
>
> for row in reader:
>       if counter == 1:
>           parties = row[1:-1]
>           for party in parties:
>               writer.writerow([party])
>       counter += 1
> fh.close()
>
> Thanks for your responses as anticipated.
>
>
>
>
>
>
>
>
>
>
> On Thu, Mar 17, 2011 at 1:00 PM, Tim Golden <mail at timgolden.me.uk> wrote:
>
>> On 17/03/2011 11:56, Dipo Elegbede wrote:
>>
>>> i wrote a code for extracting information from a csv file into another
>>> csv file.
>>> it worked well but i have an immediate challenge i can't seem to fix.
>>> the new file that is created has an row and then an empty row and then a
>>> row all through the file. how can i make the empty rows not be part of
>>> the file.
>>>
>>
>> Open the file in binary mode:
>>
>> fh = open('stateparty2.csv','wb')
>>
>> TJG
>> _______________________________________________
>> Tutor maillist  -  Tutor at python.org
>> To unsubscribe or change subscription options:
>> http://mail.python.org/mailman/listinfo/tutor
>>
>
>
>
> --
> Elegbede Muhammed Oladipupo
> OCA
> +2348077682428
> +2347042171716
> www.dudupay.com
> Mobile Banking Solutions | Transaction Processing | Enterprise Application
> Development
>
> _______________________________________________
> Tutor maillist  -  Tutor at python.org
> To unsubscribe or change subscription options:
> http://mail.python.org/mailman/listinfo/tutor
>
>
You want row[1] from each iteration of row.  So instead of this:

for row in reader:
      if counter == 1:
          parties = row[1:-1]
          for party in parties:
              writer.writerow([party])
      counter += 1
fh.close()


Do this:

for row in reader:
    if counter == 1:
        party = row[1:2]
        write.writerow(party)
   counter += 1


What is the counter for?



-- 
Joel Goldstick
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20110317/3725a6c9/attachment-0001.html>