<br><div>Thanks Tim, that worked like magic.<br></div><div><br></div><div>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:</div>
<div><br></div><div>A<br>ACD<br>ACN<br>ACPN<br>AD<br>ADC<br>ALP<br>ANPP<br>APGA<br>APS<br>ARP<br>BNPP<br>CAP<br>CDC<br>CPC<br>CPN<br>CPP<br>DFPF<br>DPP<br></div><div><br></div><div>It is spelt out on different block like this:</div>
<div><br></div><div>
<table><tr height="20" style="height:15.0pt">
<td height="20" width="64" style="height:15.0pt;width:48pt">PARTY</td>
<td width="64" style="width:48pt"></td>
<td width="64" style="width:48pt"></td>
<td width="64" style="width:48pt"></td>
<td width="64" style="width:48pt"></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">A</td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">A</td>
<td>C</td>
<td>D</td>
<td></td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">A</td>
<td>C</td>
<td>N</td>
<td></td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">A</td>
<td>C</td>
<td>P</td>
<td>N</td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">A</td>
<td>D</td>
<td></td>
<td></td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">A</td>
<td>D</td>
<td>C</td>
<td></td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">A</td>
<td>L</td>
<td>P</td>
<td></td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">A</td>
<td>N</td>
<td>P</td>
<td>P</td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">A</td>
<td>P</td>
<td>G</td>
<td>A</td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">A</td>
<td>P</td>
<td>S</td>
<td></td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">A</td>
<td>R</td>
<td>P</td>
<td></td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">B</td>
<td>N</td>
<td>P</td>
<td>P</td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">C</td>
<td>A</td>
<td>P</td>
<td></td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">C</td>
<td>D</td>
<td>C</td>
<td></td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">C</td>
<td>P</td>
<td>C</td>
<td></td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">C</td>
<td>P</td>
<td>N</td>
<td></td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">C</td>
<td>P</td>
<td>P</td>
<td></td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">D</td>
<td>F</td>
<td>P</td>
<td>F</td>
<td></td>
</tr>
<tr height="20" style="height:15.0pt">
<td height="20" style="height:15.0pt">D</td>
<td>P</td>
<td>P</td>
<td><p><br></p></td></tr></table></div><table><tr height="20" style="height:15.0pt"><td><p><div><br></div><div><br></div><div>what could be wrong with this code:</div><div><br></div><div>import csv<br><br>reader = csv.reader(open('stateparty.csv'))<br>
counter = 1<br>header = ["PARTY"]<br>fh = open('stateparty3.csv','wb')<br>writer = csv.writer(fh)<br>writer.writerow(header)<br>for row in reader:<br> if counter == 1:<br> parties = row[1:-1]<br>
for party in parties:<br> writer.writerow([party])<br> counter += 1<br>fh.close()<br></div><div><br></div><div>Thanks for your responses as anticipated.</div><p></p></p></td></tr>
<td><div><tr height="20" style="height:15.0pt">
<td></td>
</tr></div><td><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div><div class="gmail_quote">On Thu, Mar 17, 2011 at 1:00 PM, Tim Golden <span dir="ltr"><<a href="mailto:mail@timgolden.me.uk">mail@timgolden.me.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div class="im">On 17/03/2011 11:56, Dipo Elegbede wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
i wrote a code for extracting information from a csv file into another<br>
csv file.<br>
it worked well but i have an immediate challenge i can't seem to fix.<br>
the new file that is created has an row and then an empty row and then a<br>
row all through the file. how can i make the empty rows not be part of<br>
the file.<br>
</blockquote>
<br></div>
Open the file in binary mode:<br>
<br>
fh = open('stateparty2.csv','wb')<br>
<br>
TJG<br>
_______________________________________________<br>
Tutor maillist - <a href="mailto:Tutor@python.org" target="_blank">Tutor@python.org</a><br>
To unsubscribe or change subscription options:<br>
<a href="http://mail.python.org/mailman/listinfo/tutor" target="_blank">http://mail.python.org/mailman/listinfo/tutor</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Elegbede Muhammed Oladipupo<br>OCA<br>+2348077682428<br>+2347042171716<br><a href="http://www.dudupay.com">www.dudupay.com</a><br>Mobile Banking Solutions | Transaction Processing | Enterprise Application Development<br>
</td></td></table>