Crawling station data on Divvy Bikes website

access

https://account.divvybikes.com/bikesharefe-gql

covert raw json data to an Excel worksheet

Install python packages

pip install pandas,openpyxl

modified the path and run divvy_json2excel.py to create a xlsx file containing information of each stations

python divvy_json2excel.py

merge the metadata from the Excel worksheet

python merge_excel.py