Independent study on food bank data analysis
This project is developed for the credits of CSC 630 (Independent Study) under the supervision of Dr. Min Chi, Associate Professor, Department of Computer Science, North Carolina State University.
The data provided by FBCENC for the FY 2006-2017 has been analysed to recognize the pattern of food donations by donors and purchase trends from vendors.
The sql_scripts folder contains scripts that create MySQL views aggregating data from FY2006 - FY2017 into one view, creates categorized views for purchase_data, transfer_data, distribution_data, positive_adjustment_data and negative_adjustment_data.
The processing_scripts folder contains following scripts developed in Python 3.5:
Department of Computer Science, North Carolina State University, Raleigh, NC