Python package for lab student survey. A single command fetches the spreadsheet generated from Google Forms and uploads the analysis results to Google Drive. Automatically calculates mean, standard deviation, correlation coefficient, p-value, Cronbach's alpha, and performs cluster analysis.
MIT License
Python package for lab student survey. A single command fetches the spreadsheet generated from Google Forms and uploads the analysis results to Google Drive.
student-lab-survey
(or any name) project in Google Cloud Platform.Google Drive API
in Google Cloud Platform.Service Account
in Google Cloud Platform.Service Account
credentials as JSON in Google Cloud Platform and save it as service-secrets.json
in the working directory or set it as GDRIVE_SERVICE_ACCOUNT
environment variable (via GitHub Secrets).student-lab-survey
(or any name) folder in Google Drive.Service Account
email to the student-lab-survey
folder with Editor
permissions.Google Form
for the lab student survey. The second question should be the name of the supervisor.Google Sheet
in the student-lab-survey
folder from the Google Form
.metadata.csv
and metadata_group_name.csv
in the working directory or student-lab-survey
folder in Google Drive to specify the question groups. The former will be automatically generated in the working directory if it does not exist. The latter is optional.Google Sheet
ID as LAB_STUDENT_SURVEY_FILE_ID
environment variable (via GitHub Secrets).student-lab-survey
folder ID as LAB_STUDENT_SURVEY_FOLDER_ID
environment variable (via GitHub Secrets). (Optional.) If not set, the parent folder ID of the Google Sheet
will be used.Service Account
credentials as GDRIVE_SERVICE_ACCOUNT
environment variable (via GitHub Secrets).)lss
name: Run lab-student-survey
on:
schedule:
# every day at 00:00 UTC
- cron: "0 0 * * *"
workflow_dispatch:
jobs:
run:
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v3
- name: Install wkhtmltopdf
run: sudo apt-get install -y wkhtmltopdf
- name: Install and run lab-student-survey
run: pipx run lab-student-survey
env:
LAB_STUDENT_SURVEY_FILE_URL: ${{ secrets.LAB_STUDENT_SURVEY_FILE_URL }}
LAB_STUDENT_SURVEY_FOLDER_URL: ${{ secrets.LAB_STUDENT_SURVEY_FOLDER_URL }}
GDRIVE_SERVICE_SECRETS: ${{ secrets.GDRIVE_SERVICE_SECRETS }}
Install this via pip or pipx (or your favourite package manager):
pipx install lab-student-survey
As far as I could find, there is no repository on GitHub for this particular topic. Instead, you may want to check out the following alternative websites. However, as there are too few people in a lab, with the effect of diminishing anonymity, most of these websites do not seem to attract many reviews.
研究室 口コミ -満載 -学べます - Search / X
pi rate website phd site:www.reddit.com - Google Search
Thanks goes to these wonderful people (emoji key):
This project follows the all-contributors specification. Contributions of any kind welcome!