scrape2.py

Enter file contents hereimport csv
import requests
from bs4 import BeautifulSoup

url = 'http://log.concept2.com/rankings/2016/rower/5000?age=50-59&weight=H&gender=M&status=verified'

response = requests.get(url)
html = response.content

soup=BeautifulSoup(html)
table=soup.find('tbody')

list_of_rows=[]
for row in table.findAll('tr'):
    list_of_cells=[]
    for cell in row.findAll('td'):
        text=cell.text.replace(' ','')
        list_of_cells.append(text)
    list_of_rows.append(list_of_cells)

outfile = open("./5000erg50Heavy.csv","w")
writer = csv.writer(outfile)
writer.writerow(["Position","Name","Age","Location","Country","Club","Time","Type","Verified"])
writer.writerows(list_of_rows)