Inspiration
We were inspired to create a model that not only holds data from past records in a uniform structure, but also integrates future member data in a way that is user friendly and adaptable.
What it does
Our code takes exported csv files and formats them into a uniformly sorted google spreadsheet using gspread. It automatically gives alumni status to members that have graduated from the program, and takes future data from a google form that can be sent to members through email or QR code in physical mail. We also accompanied our program with an image to text script that takes their locally stored physical records and outputs them as a .csv file with the proper formatting and contact information.
How we built it
We used python libraries like gspread and pandas in order to collect and sort data, as well as tesseract to parse images stored locally. We then accompanied our google sheet with a form to collect future member data.
Challenges we ran into
It was difficult to find a way to merge data from several places, including physical records into one singular database.
Accomplishments that we're proud of
Creating a script to parse the physical records and format them as a .csv table, finding creative ways to merge data from several CRM sites.
What we learned
We learned basic database management with pandas and gspread, and visual processing with tesseract to parse physical media.
What's next for our project.
We would want to implement our spreadsheet system into the Boys & Girls Club website and create a mailing list for club alumni in order to increase the clubs reach.
Log in or sign up for Devpost to join the conversation.