pybikes scraper

pybikes scraping

import requests, sqlite3, pandas as pd

url='https://api.citybik.es/v2/networks/velib'
r=requests.get(url)
conn = sqlite3.connect('pybikes.db')

df = pd.DataFrame(r.json()['network']['stations'])
df = df[['id','name','free_bikes','empty_slots','timestamp']]
df.to_sql('velib', conn,if_exists='append')

print('got %d points' %len(pd.read_sql('SELECT * FROM velib', conn)))

This only gets data from the VELIB system. There is much better here.