Integrate Google Form/Sheet into GatorMiner
Opened this issue · 2 comments
Context and feature
GatorMiner currently supports Markdown document for text analysis, whether it is through the local file system or AWS. Although it allows for txt files, the features are rather restricted due to the unstructured nature of this file format. With that, it would be interesting to incorporate other input such as Google Forms to the tool, where the analysis could be done for each question and each submission.
Proposed solution
More research needs to be done on Google Form or Google Sheet API. However, it might not be as complicated as it seems, since the visualization and analysis are largely based on the pandas data frame. Seemingly, if the data extracted from Google Form/Sheet can be robustly converted into pandas, the rest of the analysis would mostly be compatible.
Useful resources
https://betterprogramming.pub/automating-data-extractions-from-google-sheets-with-python-666a692d8ac2
https://pbpython.com/pandas-google-forms-part1.html
@kailaniwoodard Thanks for picking up the issue. This feature is long overdue and I would love to help in any way. Feel free to let me know if you have any questions.
Need more detail on the solution (what is the acceptance criteria?). Also, please add an estimate.