Python BeautifulSoup Print Info in CSV

Posted by Codin on Stack Overflow See other posts from Stack Overflow or by Codin
Published on 2013-10-28T15:33:04Z Indexed on 2013/10/28 15:54 UTC
Read the original article Hit count: 204

Filed under:
|

I can print the information I am pulling from a site with no problem. But when I try to place the street names in one column and the zipcodes into another column into a CSV file that is when I run into problems. All I get in the CSV is the two column names and every thing in its own column across the page. Here is my code. Also I am using Python 2.7.5 and Beautiful soup 4

from bs4 import BeautifulSoup
import csv
import urllib2

url="http://www.conakat.com/states/ohio/cities/defiance/road_maps/"

page=urllib2.urlopen(url)

soup = BeautifulSoup(page.read())

f = csv.writer(open("Defiance Steets1.csv", "w"))
f.writerow(["Name", "ZipCodes"]) # Write column headers as the first line

links = soup.find_all(['i','a'])

for link in links:
    names = link.contents[0]
    print unicode(names)

f.writerow(names)   

© Stack Overflow or respective owner

Related posts about python

Related posts about csv