This month, we'll have a talk from Aaron Wiegel about using Django forms as a data management and ETL tool. There's also an open slot for a lightning talk. Contact us if you are interested!
As even a relatively small R&D-oriented organization grows, the need to aggregate data from multiple experiments becomes key to generating new insights to advance that growth. However, the data from these experiments is often scattered across multiple spreadsheets with different formats, and the tracking of metadata necessary for aggregation can be very poor. Creating a simple web application using Django forms enables this process by both allowing users to track experimental conditions and other associated metadata and to validate measurements taken within those spreadsheets. Furthermore, such an application can generate standardized spreadsheets to unify data collection efforts. Using even a relatively simple set of forms can provide a basis for a minimal viable product to start the process of aggregation and bridge the gap between siloed experimental spreadsheets and a more useful and user-friendly data warehouse solution.
SPEAKER BIO: Aaron Wiegel
Aaron Wiegel, PhD is a data engineer at Pivot Bio, a biotech start up that provides genetically engineered bacteria to fix nitrogen for corn as a replacement for synthetic fertilizer. He previously did research in experimental physical and atmospheric chemistry before changing careers to data science 5 years ago.
CODE OF CONDUCT
Interactions online have less nuance than in-person interactions. Please be Open, Considerate and Respectful. Also, please refrain from discussing topics unrelated to the Python community or the technical content of the meeting.
We will conduct the meeting via Zoom webinar. Please register in advance. To do so, first RSVP "Yes" to this event. You should then see the link to sign up via the Zoom webinar. We will also send the Zoom signup link to the [masked] mailing list (sign-up here: https://mail.python.org/mailman/listinfo/baypiggies).