Skip to content

This project is a flask app that serves up bevy of data to a client (in this case Auto insurance rates and weather data).

Notifications You must be signed in to change notification settings

vc-adams/ETL_Project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

60 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ETF_Project

PROJECT PROPOSAL

ETL PROJECT: Group 1

Team Members: Rob Pascarella, Vincent Adams, Emeka Obianyor

Project Summary:

Pairing up insurance rates with weather data that can be searchable via user input.
The idea of this project is to create a flask app to serve up to a client a bevy of data (in this case Auto insurance rates and weather data) for any zip code, city, or state that the client may request.
We have broken this project execution down into several phases:

Extract:

We need to extract all the data we intend to serve up to the client. In this case, Auto insurance rates – we intend to scrape insurance rates from various zip codes across the country. We will then pull weather data for same zip codes using API calls.
Data sources:
Auto Insurance data:
https://www.autoinsurance.org/quoting-auto-insurance-rates-by-zip-code/
Weather data:
http://api.openweathermap.org/api

Transform:

We will clean and merge the data from each resource. The creation and utilization of a flask app will allow the user to extract auto insurance data as well as weather data for comparison and/or analysis.

Load:

We then intend to load said data into a postgres database, join the data tables by location, and produce the information via a search, all from our flask server.

The flask app allows callable the data when a client requests information via each route.

About

This project is a flask app that serves up bevy of data to a client (in this case Auto insurance rates and weather data).

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 3

  •  
  •  
  •