BACETech Projects



Gmail CSV Batch Download and Concat

python

Client: Biology Department, Duke University

At the Biology Department at Duke University, the instructors for the BIOL 102 course, Introduction to Molecular Biology, required a quick and dirty solution to create a simple yeast genomic database for the students to use in lab. After interviewing several of the teaching assistants, it was determined that the fastest solution would be a distributed email based approach rather than developing a full fledge database on the Duke network and interfacing with Duke’s NetID login protocol. Students would submit their information to the database by emailing a Gmail address for the class.

A teaching assistant would run a script written in Python that would download the most up to date CSV file for each student from the class’s gmail address via the POP3 protocol and join them all together into an output excel spreadsheet. The spreadsheet was posted on blackboard and shared with the class for general access. Future
License: Closed at the moment.





© 2011 All Rights Reserved. BACETech Consulting.