Ok, I think what you are trying is to get all data in a string list:<br><br>import urllib, csv<br>url=r"<a href="http://www.cs.columbia.edu/~joshua/teaching/cs3101/simpsons_diet.csv">http://www.cs.columbia.edu/~joshua/teaching/cs3101/simpsons_diet.csv</a>"<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><br><div class="gmail_quote">2011/3/24 <span dir="ltr"><<a href="mailto:l.leichtnam@gmail.com">l.leichtnam@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">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?<br>
<div class="im">Sent from my BlackBerry® on the MetroPCS Network<br>
<br>
</div><div><div></div><div class="h5">-----Original Message-----<br>
From: Rafael Durán Castañeda<br>
<<a href="mailto:rafadurancastaneda@gmail.com">rafadurancastaneda@gmail.com</a>><br>
Sender: tutor-bounces+l.leichtnam=<a href="http://gmail.com" target="_blank">gmail.com</a>@<a href="http://python.org" target="_blank">python.org</a><br>
Date: Thu, 24 Mar 2011 15:51:34<br>
To: <<a href="mailto:tutor@python.org">tutor@python.org</a>><br>
Subject: Re: [Tutor] Fw: Fw: Parsing data from a csv file [NC]<br>
<br>
_______________________________________________<br>
Tutor maillist - <a href="mailto:Tutor@python.org">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>
<br>
</div></div></blockquote></div><br>