This project is a data analysis of the Bay Wheels system data for the year 2020. I entered the data into a table, bay_wheels_2020, on a local MySQL database. The data was queried with MySQL commands. I was able to easily export the data into JSON with the MySQL Workbench application.
- Reformat data. Do a "Replace All" for "member," or "casual," values and remove the comma from all of them
- {"name":"system_information","url":"https://gbfs.baywheels.com/gbfs/en/system_information.json"}
- "name":"station_information","url":"https://gbfs.baywheels.com/gbfs/en/station_information.json"}
- {"name":"station_status","url":"https://gbfs.baywheels.com/gbfs/en/station_status.json"}
- {"name":"free_bike_status","url":"https://gbfs.baywheels.com/gbfs/en/free_bike_status.json"}
- {"name":"system_hours","url":"https://gbfs.baywheels.com/gbfs/en/system_hours.json"}
- {"name":"system_calendar","url":"https://gbfs.baywheels.com/gbfs/en/system_calendar.json"}
- {"name":"system_regions","url":"https://gbfs.baywheels.com/gbfs/en/system_regions.json"}
- {"name":"system_alerts","url":"https://gbfs.baywheels.com/gbfs/en/system_alerts.json"}]