Skip to content

Group analysis of a data set of pizza places. A SQL Database was created, and data was pulled in through a static API and Javascript. Esri maps were used to map city demographics. SQL Alchemy and Flask app also utilized.

Notifications You must be signed in to change notification settings

mcgeec91/Project-2

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

70 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Project-2 Data Visualizations

Usage

  • In order to run this website with its full capabilities, there are a few simple steps that need to be done in the specified order.

Step 1: Clone repository

  • Git Clone the repository onto your local disk/computer.

Step 2: SQL Database

  • Using localhost:3306 in MySQL, run this line "CREATE DATABASE pizza_db;" in a query.
  • Using any of the CSV's located in the "Pizza_Data" folder, Import the CSV Data into your "pizza_db" database in MySQL using the table import wizard and naming the table "pizza".
  • Once table is created, The database will be able to be accessed when you call for it.

Step 3: Changing config.py

  • The password is left out of config.py file for the repository so you will need to add your password for "localhost:3306". If you didn't put your database in your localhost:3306, you will need to change your config.py so that your computer can access the Database.

Step 4: Running app.py

  • To launch the website, you will need to run the command "python app.py" while you are in the correct directory of the repository. This error will show up if you are in the wrong directory: "can't open file 'app.py': [Errno 2] No such file or directory".

  • I have folium on my environment which can only be utilized after running the command line "source activate 'myenv'". You may need to install the current version of folium in order to get the site to run. Running command "pip install folium" while in your environment should be all that you need to do in order to be able to run this website on "http://127.0.0.1:5000/".

About

Group analysis of a data set of pizza places. A SQL Database was created, and data was pulled in through a static API and Javascript. Esri maps were used to map city demographics. SQL Alchemy and Flask app also utilized.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 3

  •  
  •  
  •  

Languages