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
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