I don't know what are you going to do with data, but you can save all data in either a list or a dictionary, for example:<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>diet_list = []<br>diet_dict = {}<br><br>for char,meal,ate,qty,com in reader:<br> if char != 'Character':<br>
diet_list.append([char, meal, ate, qty, com])<br> if diet_dict.has_key(char):<br> diet_dict[char].append([meal, ate, qty, com])<br> else:<br> diet_dict[char] = [[meal, ate, qty, com],]<br> <br>
print diet_list<br>print diet_dict<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;">
Thank you for your help<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 09:48:04 -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>Re: Fw: [Tutor] Parsing data from a csv file [NC]</div>
<div><br></div>
<br><font face="sans-serif" size="2">Hello the loops are a bit different,
and I definitely don't know if it's correct but I want to be able to put
each part of the cvs into my future html code.</font>
<br>
<br><font face="sans-serif" size="2">the cvs file is this one: </font>
<br>
<br>
<br><font face="sans-serif" size="2">and can be found there </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>
<br>
<br>
<br>
<br>
<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 09:42 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] Parsing data from a csv
file</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"><br>
</font>
<br><font size="3">On Thu, Mar 24, 2011 at 8:34 AM, louis leichtnam <</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">>
wrote:</font>
<br><font size="3">Hello,</font>
<br>
<br><font size="3">I am to extract a csv file from the web and parse it in
python and after that make it into an html page.</font>
<br>
<br><font size="3">I want to get the data out of the csv file, get rid of
the "," and make it readable. </font>
<br>
<br><font size="3">Questions:</font>
<br><font size="3">I would like to be able to print the line I want but I
don't know how to do it.</font>
<br><font size="3">I would like to modify some lines, and make them cleaner</font>
<br>
<br><font size="3">Can you help me?</font>
<br>
<br>
<br>
<br>
<br><font size="3">import urllib, csv</font>
<br><font size="3">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">"</font>
<br><font size="3">simpsons=urllib.urlopen(url)</font>
<br><font size="3">reader=csv.reader(simpsons,delimiter=',',quotechar='"')</font>
<br><font size="3">a=[]</font>
<br><font size="3">b=[]</font>
<br><font size="3">c=[]</font>
<br><font size="3">d=[]</font>
<br><font size="3">e=[]</font>
<br><font size="3">for char,meal,ate,qty,com in reader:</font>
<br><font size="3"><br>
at this point you have the five fields you want<br>
if you do print char, meal, ate, qty,com you will see your data with the
commas gone<br>
</font>
<br><font size="3"> for x in char:</font>
<br><font size="3"> a.append(x)</font>
<br><font size="3"> for y in meal:</font>
<br><font size="3"> b.append(y)</font>
<br><font size="3"> for z in ate:</font>
<br><font size="3"> c.append(z)</font>
<br><font size="3"> for aa in qty:</font>
<br><font size="3"> d.append(aa)</font>
<br><font size="3"> for bb in com:</font>
<br><font size="3"> e.append(bb)</font>
<br><font size="3">for i in range(1::):</font>
<br><font size="3"> print a[i]+b[i]+c[i]+d[i]+e[i]</font>
<br>
<br><font size="3"><br>
These for loops puzzle me. It looks like you are iterating over each
character in each variable, then creating a list containing each character.<br>
I don't think you want to do that.<br>
<br>
The for i in range(1::): will give you an error. The range parameter
needs to be something with a length, like a string, or a list, or a tuple.<br>
<br>
Can you show a little bit of your data file, and give us the traceback
and output of your program? </font>
<br><font size="3">_______________________________________________<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><font size="3"><br>
<br>
<br>
-- <br>
Joel Goldstick<br>
</font>
<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>
<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></blockquote></div><br>