The Revature Cesnsus Application is an application which takes United States Census data and compares population changes over time.
This Census Application was created with Revature as a demonstration of Big Data techniques and simulation of working with Big Data. Using a sample dataset of approximately 60 million rows, taken from publicly available US Census data, the application queries the data to determine information on a variety of subjects regarding total population and racial distribution. Information from these queries is then visualized using Tableau.
Please refer to the STARTUP.md guide.
The data for each census year has been cleaned, queried to relevant information, and outputted as .csv files. These files are included as part of this repository as output00.csv, output10.csv, and output20.csv. Steps taken to replicate our cleaning process may be found in the Wiki.
- Command Line Interface for easy access to different queries available.
- Database Manager for connecting to Apache Spark
- User Login
- Interactive menus with submenus.
- No cloud database currently set up
- Login is session-based
- Erienne McCray (Scrum Master)
- Ethan Kempf (Data Team Lead)
- Justin Yeary (Database Team Lead)
- Tyller Mendoza (Visualization Team Lead)
- George Cobb (Query Team Lead)
- Abnel Negron (App Team Lead)
- Michael Celusniak
- Christiana Dickson
- Nicholas Famoye
- Raymond Fu
- Kiara Gardea
- Normand Jean
- Sherrell Jones
- Julio Ortiz
- Trathen Mecimore
- Lowson Merilien
- Tek Rimal
- Juan Sandoval
- Morgan Simmons
- Tony Wilkins
- Tayon Williams
For more information, please contact Erienne McCray at erienne793@revature.net.