BiciMAD Stations near embassies and consulates

Ironhack Data Analytics Module 1 Project

In this data pipeline you will find the nearnest BiciMAD station from any embassy or consulate in Madrid.

Data Pipeline:

The source of the databases were:

• BiciMAD: download the database from an Azure SQL Database
• Embassies and consulates: API REST from Portal de datos abiertos del Ayuntamiento de Madrid

Usage:

Due to the argparse function, in the terminal, you can run and open the pipeline choosing two options to obtain the output table.

    python main.py -op "optional parameter"

• “minimum": if you choose this one, the pipeline will ask you for an input and you will get a .csv with the address of the closest BiciMAD station.

• "all": with this option, you will obtain a .csv with the nearest BiciMAD station to any embassy or consulate in Madrid.

Don´t worry if you write wrong any place of interest, with FuzzyWuzzy the pipeline will recognize the correct name you aim to introduce.

Project Main Stack

• Azure SQL Database

• SQL Alchemy (alternatively you can use Azure Data Studio)

• Requests

• Pandas

• Module geo_calculations.py

• Argparse