文件列表:

.DS_Store (14340, 2019-04-03)
.ipynb_checkpoints/ (0, 2019-04-03)
.ipynb_checkpoints/ETL_Project-checkpoint.ipynb (62401, 2019-04-03)
Proposal Images/ (0, 2019-04-03)
Proposal Images/AAC Outcomes SQL.png (131787, 2019-04-03)
Proposal Images/AAC Pandas.png (140159, 2019-04-03)
Proposal Images/Client Satisfaction SQL.png (113285, 2019-04-03)
Proposal Images/Template for visualizations.png (141655, 2019-04-03)
Proposal Images/Template for website visulations.png (507002, 2019-04-03)
Resources/ (0, 2019-04-03)
Resources/.DS_Store (6148, 2019-04-03)
Resources/.ipynb_checkpoints/ (0, 2019-04-03)
Resources/.ipynb_checkpoints/ETL_Project-checkpoint.ipynb (47772, 2019-04-03)
Resources/.~Zip Code Map__33467.twbr (0, 2019-04-03)
Resources/Austin_Animal_Center_Outcomes.csv (12073529, 2019-04-03)
Resources/Community_Survey_2015__2016___2017.csv (8239571, 2019-04-03)
Resources/ETL_Project.ipynb (47772, 2019-04-03)
Resources/Zip Code Map.twb (450344, 2019-04-03)
project2/ (0, 2019-04-03)
project2/.DS_Store (10244, 2019-04-03)
project2/__init__.py (0, 2019-04-03)
project2/__pycache__/ (0, 2019-04-03)
project2/__pycache__/__init__.cpython-36.pyc (176, 2019-04-03)
project2/__pycache__/__init__.cpython-37.pyc (180, 2019-04-03)
project2/__pycache__/app.cpython-36.pyc (1813, 2019-04-03)
project2/__pycache__/app.cpython-37.pyc (1817, 2019-04-03)
project2/app.py (2838, 2019-04-03)
project2/db/ (0, 2019-04-03)
project2/db/.DS_Store (6148, 2019-04-03)
project2/db/austinproject2.sqlite (27041792, 2019-04-03)
project2/node_modules/ (0, 2019-04-03)
project2/node_modules/.bin/ (0, 2019-04-03)
project2/node_modules/.bin/loose-envify (22, 2019-04-03)
project2/node_modules/@babel/ (0, 2019-04-03)
project2/node_modules/@babel/runtime/ (0, 2019-04-03)
project2/node_modules/@babel/runtime/LICENSE (1106, 2019-04-03)
project2/node_modules/@babel/runtime/helpers/ (0, 2019-04-03)
project2/node_modules/@babel/runtime/helpers/AsyncGenerator.js (2003, 2019-04-03)
... ...

# Project 2 Tito Odunsi, Delayna Bradshaw and Kerry Kovacik Github Repository: https://github.com/Kerrykova/Project-2 Two datasets were found from the austintexas.gov website containing data detailing the animal center outcomes (2015-2017) and city satisfaction survey (2015-2017) responses of the city of Austin. These datasets will be compared to see if any correlations exist between various Austin resident responses regarding their satisfaction of different factors of the city and the outcomes of animals in shelters. Specifically, we will be looking at the responses to questions regarding resident's views on parks, safety, and overall satisfaction as well as demographics and comparing these by zip codes. Multiple visualizations will be made using Tableau, Python and JavaScript, shedding light on comparisons between resident's city views and animal center outcomes. Animal Center Outcomes Data: * A pie chart of different type of animals. * A pie chart of the number of animals by outcome type. * A line chart showing changes of outcomes by year by animal type. Satisfaction Survey Data: * A line chart showing changing in safety and satisfaction levels in Austin by year. * An interactive plot by Austin zip codes which returns data of the different survey responses (quality of life, safety, parks and rec, etc) * Add on a layer that changes color/transparency based on a certain demographic by that zip code (we chose day safety). * Do this using Tableau. Data sources: * Austin Animal Center Outcomes * https://data.austintexas.gov/Health-and-Community-Services/Austin-Animal-Center-Outcomes/9t4d-g238 * City of Austin Satisfaction Surveys * https://data.austintexas.gov/City-Government/Community-Survey-2015-2016-2017/76qk-igxn Transformation process/steps: * Filter, drop and rename columns * Aggregate animals by year for outcome types * Filter data sets so that they both have the same date range * Clean data by dropping any duplicates or rows missing data * Sort the animal dataset so that the results are "grouped by" year Data destination: SQLite Database: etlproject_db Tables: aac_outcomes, city_satisfaction Used ZingChart, Plotly and Tableau for visualization graphs

近期下载者：

相关文件：

评论：[我要评论] [举报此文件]

收藏者：