writing a csv file

ejsaiet at alaska.edu ejsaiet at alaska.edu
Sun Nov 11 19:05:52 EST 2012


Hello,
I have the script below, which it extracts NOAA data from HTML and is planed writes it to a CSV file. Here is the script:

import urllib2
from bs4 import BeautifulSoup
from time import localtime, strftime
import csv

#This script is intended to retrive NOAA data and apend it to a csv file.

# Wait 45 min
#Need to work on this part...


# Go into URL
page = urllib2.urlopen("http://w1.weather.gov/obhistory/PAFA.html")
soup = BeautifulSoup(page)
datemonth=strftime("%m", localtime())
dateday=strftime("%d", localtime())



with open("/home/eyalak/Documents/weather/weather.csv", "wb") as f:
      writer = csv.writer(f)
      table = soup.findAll("table")[3]
      #print table
      for tr in table.findAll("tr", valign="top"):
         a={x.string for x in tr.findAll('td')}
         print str(a)
         writer.writerows([a])

It did not work unless I changed the line a={x.string for x in tr.findAll('td')} to a=list({x.string for x in tr.findAll('td')})

But that disorganizes the data. How can I write the data to a csv file without altering the order prior to the list function.
Thanks
E



More information about the Python-list mailing list