<br><br><div class="gmail_quote">On Thu, Mar 24, 2011 at 1:45 PM, <span dir="ltr"><<a href="mailto:l.leichtnam@gmail.com">l.leichtnam@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<p>Sent from my BlackBerry® on the MetroPCS Network</p><hr><div><b>From: </b> Louis LEICHTNAM <<a href="mailto:louis.leichtnam@sgcib.com" target="_blank">louis.leichtnam@sgcib.com</a>>
</div><div><b>Date: </b>Thu, 24 Mar 2011 11:51:26 -0400</div><div><b>To: </b><<a href="mailto:l.leichtnam@gmail.com" target="_blank">l.leichtnam@gmail.com</a>></div><div><b>Subject: </b>Fw: [Tutor] Fw: Fw: Parsing data from a csv file [NC]</div>
<div><br></div>
<br><font color="#800080" face="sans-serif" size="1">----- Forwarded by Louis
LEICHTNAM/us/socgen on 03/24/2011 11:51 AM -----</font>
<br>
<p></p><table width="100%">
<tbody><tr valign="top">
<td width="40%"><font face="sans-serif" size="1"><b>Louis LEICHTNAM/us/socgen</b></font>
<p><font face="sans-serif" size="1">03/24/2011 11:48 AM</font>
</p></td><td width="59%">
<table width="100%">
<tbody><tr valign="top">
<td>
<div align="right"><font face="sans-serif" size="1">To</font></div>
</td><td><font face="sans-serif" size="1">tutor-bounces+l.leichtnam=<a href="http://gmail.com" target="_blank">gmail.com</a>@<a href="http://python.org" target="_blank">python.org</a>,
<a href="mailto:joel.goldstick@gmail.com" target="_blank">joel.goldstick@gmail.com</a>, <a href="mailto:tutor@python.org" target="_blank">tutor@python.org</a>, <a href="mailto:rafadurancastaneda@gmail.com" target="_blank">rafadurancastaneda@gmail.com</a></font>
</td></tr><tr valign="top">
<td>
<div align="right"><font face="sans-serif" size="1">cc</font></div>
</td><td>
</td></tr><tr valign="top">
<td>
<div align="right"><font face="sans-serif" size="1">Subject</font></div>
</td><td><font face="sans-serif" size="1">Re: Fw: [Tutor] Fw: Fw: Parsing data
from a csv file [NC]</font><a href="Notes:///852577BC000C6413/DABA975B9FB113EB852564B5001283EA/60677866DC5D96E58525785D00560CBB" target="_blank">Link</a></td></tr></tbody></table>
<br>
<table>
<tbody><tr valign="top">
<td>
</td><td></td></tr></tbody></table>
<br></td></tr></tbody></table>
<br>
<br><font face="sans-serif" size="2">For example the line 1 in the csv file
is:</font>
<br>
<br><font face="sans-serif" size="2">Barney Gumble, Breakfast, Duffbeer,
1, I could?ve gone to Harvard</font>
<br>
<br><font face="sans-serif" size="2">and I want to be able to clean it and
turn it into:</font>
<br>
<br><font face="sans-serif" size="2">Barney Gumble had for beakfast 1 Duffbeer
while thinking "I coul?ve gone to Harvard"</font>
<br>
<br><font face="sans-serif" size="2">so basically using in this line the
column0 + "had for " + column 1 + column3 + column2 + "while
thinking"+column4</font>
<br>
<br><font face="sans-serif" size="2">and I want to be able to do this for
every line, except for line0.</font>
<br>
<br><font face="sans-serif" size="2">My end game is, after I'm able to do
this, I want to write an Html using python that shows those cleand lines</font>
<br>
<br><font face="sans-serif" size="2">Thanks for your help</font>
<br>
<br>
</blockquote><div><br>If the code below is doing what you like:<br><br><font size="3"> list_string.append("%s %s %s %s %s"
% (char, meal, ate, qty, com))<br><br>change it to this: <br></font><font size="3"> list_string.append("%s had for %s %s %s while thinking '%s'"
% (char, meal, qty, ate, com))<br>
</font><br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<br>
<br>
<p></p><table width="100%">
<tbody><tr valign="top">
<td rowspan="2" width="40%"><font face="sans-serif" size="1"><b><a href="mailto:l.leichtnam@gmail.com" target="_blank">l.leichtnam@gmail.com</a></b>
</font>
<p><font face="sans-serif" size="1">03/24/2011 11:39 AM</font>
</p><table border="1">
<tbody><tr valign="top">
<td bgcolor="white">
<div align="center"><font face="sans-serif" size="1">Please respond to<br>
<a href="mailto:l.leichtnam@gmail.com" target="_blank">l.leichtnam@gmail.com</a></font></div></td></tr></tbody></table>
<br>
</td><td width="59%">
</td></tr><tr valign="top">
<td>
<table width="100%">
<tbody><tr valign="top">
<td>
<div align="right"><font face="sans-serif" size="1">To</font></div>
</td><td><font face="sans-serif" size="1">Louis LEICHTNAM/us/socgen@socgen</font>
</td></tr><tr valign="top">
<td>
<div align="right"><font face="sans-serif" size="1">cc</font></div>
</td><td>
</td></tr><tr valign="top">
<td>
<div align="right"><font face="sans-serif" size="1">Subject</font></div>
</td><td><font face="sans-serif" size="1">Fw: [Tutor] Fw: Fw: Parsing data from
a csv file [NC]</font></td></tr></tbody></table>
<br>
<table>
<tbody><tr valign="top">
<td>
</td><td></td></tr></tbody></table>
<br></td></tr></tbody></table>
<br>
<br>
<br><font size="3">Ok, I think what you are trying is to get all data in
a string list:<br>
<br>
import urllib, csv<br>
url=r"</font><a href="http://www.cs.columbia.edu/%7Ejoshua/teaching/cs3101/simpsons_diet.csv" target="_blank"><font color="blue" size="3"><u>http://www.cs.columbia.edu/~joshua/teaching/cs3101/simpsons_diet.csv</u></font></a><font size="3">"<br>
simpsons=urllib.urlopen(url)<br>
reader=csv.reader(simpsons,delimiter=',',quotechar='"')<br>
<br>
list_string = []<br>
<br>
for char,meal,ate,qty,com in reader:<br>
if char != 'Character':<br>
list_string.append("%s %s %s %s %s"
% (char, meal, ate, qty, com))<br>
<br>
print list_string<br>
<br>
Doing something like this you can format all strings as you want and keep
them into a list<br>
</font>
<br><font size="3">2011/3/24 <</font><a href="mailto:l.leichtnam@gmail.com" target="_blank"><font color="blue" size="3"><u>l.leichtnam@gmail.com</u></font></a><font size="3">></font>
<br><font size="3">Thanks, what I'm trying to do is extract the data from
the csv file, clean it to make each line into a sentence.<br>
<br>
But for this I think I need to use a dictionary for each and enter the
words of each columns in one no?</font>
<br><font size="3">Sent from my BlackBerry® on the MetroPCS Network<br>
</font>
<br><font size="3">-----Original Message-----<br>
From: Rafael Durán Castañeda<br>
<</font><a href="mailto:rafadurancastaneda@gmail.com" target="_blank"><font color="blue" size="3"><u>rafadurancastaneda@gmail.com</u></font></a><font size="3">><br>
Sender: tutor-bounces+l.leichtnam=</font><a href="http://gmail.com/" target="_blank"><font color="blue" size="3"><u>gmail.com</u></font></a><font size="3">@</font><a href="http://python.org/" target="_blank"><font color="blue" size="3"><u>python.org</u></font></a><font size="3"><br>
Date: Thu, 24 Mar 2011 15:51:34<br>
To: <</font><a href="mailto:tutor@python.org" target="_blank"><font color="blue" size="3"><u>tutor@python.org</u></font></a><font size="3">><br>
Subject: Re: [Tutor] Fw: Fw: Parsing data from a csv file [NC]<br>
<br>
_______________________________________________<br>
Tutor maillist - </font><a href="mailto:Tutor@python.org" target="_blank"><font color="blue" size="3"><u>Tutor@python.org</u></font></a><font size="3"><br>
To unsubscribe or change subscription options:</font><font color="blue" size="3"><u><br>
</u></font><a href="http://mail.python.org/mailman/listinfo/tutor" target="_blank"><font color="blue" size="3"><u>http://mail.python.org/mailman/listinfo/tutor</u></font></a><font size="3"><br>
</font>
<br>
<br><pre>*************************************************************************
This message and any attachments (the "message") are confidential, intended
solely for the addressee(s), and may contain legally privileged information.
Any unauthorised use or dissemination is prohibited. E-mails are susceptible
to alteration. Neither SOCIETE GENERALE nor any of its subsidiaries or
affiliates shall be liable for the message if altered, changed or falsified.
*************************************************************************
</pre>
</blockquote></div><br><br clear="all"><br>-- <br>Joel Goldstick<br><br>