/Scraping-using-query-the-API_CityBikes_April15-update-Oct2-2023

Scraping using query the API_CityBikes_April15, update Oct2, 2023

Primary LanguageJupyter Notebook

Project/Goals: The tasks are as follows:

1- Explore the structure of the API, query the API and understand the data returned. This is a link to google for the API cityBikes website http://api.citybik.es/v2/

2- Choose a city covered by the CityBikes API and retrieve all available bike stations in that city.

3- For each bike station, use the API to call the latitude, longitude and number of bikes.

4- Parse the JSON object into a Pandas dataframe.

What is citybikes? Citybikes is an API that provides bike sharing data for apps, research and projects. And supports more than 400 cities.

I chose NEW YORK city in the US country. It is ONE of the biggest cities in the world that uses citybikes serveries. In this project I scrape and investigate data that taken from CityBikes company.

Process I performed this project by two methods. First: calling using requests library Second: calling using CityBike library Both methods have different techniques to fetching data and to export json files.

Challenges Reading nested dictionary from json file, flaten, and converting to csv