Below is a list of scripts including their inputs, outputs, and dependencies.
Description: Scrapes https://www.usembassy.gov and collects a list of every U.S. Embassy and Consulate's Country, Full Name, and Google Map embed link.
Outputs:
- usembassy.csv
Dependencies (pip packages):
- pandas
- urllib
- beautifulsoup4
Description: Creates a cleaned U.S. Embassy and Consulate dateset including the best approximation of their physical buidling's longitude and latitude. It uses two additional datasets: the cities dataset from wikipedia and a manual cleanup_references.csv dataset manually collected.
Inputs:
- usembassy.csv
- cleanup_references.csv
- cities.csv
Outputs:
- cleanup.py
Dependencies (pip packages):
- pandas
Description: Collects a tables from (https://en.wikipedia.org/wiki/List_of_cities_by_elevation) listing major cities and their longitude and latitude.
Outputs:
- cities.py
Dependencies (pip packages):
- pandas
- wikipedia
Description: Performs the necessary transformations to combine our resulting Embassy and Consulate dataset with the Earthquake dataset to calculate a risk factor as described in the written submission.
Inputs:
- cleanup.csv
- Data Set - Earthquakes.xlsx'
Outputs:
- analysis.csv
Dependencies (pip packages):
- pandas
- geopy