Lab Student Survey

Supported Python versions 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.

Usage

Create student-lab-survey (or any name) project in Google Cloud Platform.
Enable Google Drive API in Google Cloud Platform.
Create a Service Account in Google Cloud Platform.
Download the 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).
Create student-lab-survey (or any name) folder in Google Drive.
Add the Service Account email to the student-lab-survey folder with Editor permissions.
Create a Google Form for the lab student survey. The second question should be the name of the supervisor.
Create a Google Sheet in the student-lab-survey folder from the Google Form.
Create 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.

Environment Variables

Set the Google Sheet ID as LAB_STUDENT_SURVEY_FILE_ID environment variable (via GitHub Secrets).
Set the 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.
(Set the Service Account credentials as GDRIVE_SERVICE_ACCOUNT environment variable (via GitHub Secrets).)

Running commands

lss

Github Actions

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 }}

Installation

Install this via pip or pipx (or your favourite package manager):

pipx install lab-student-survey

Alternatives

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.

国内

理系研究室のクチコミサイト｜OpenLab: 募集停止中, 投稿するとAmazonギフト券（100円）がもらえる, ほとんど情報なし(100程度?)
LabBase 研究室サーチ: 入力方法不明, 上よりも情報なし
研究室ナビ: リンク切れ Forms

研究室　口コミ -満載 -学べます - Search / X

海外

PI Review: 231 reviews (2021/09/21)
GradPI: 329 reviews (2023/09/21), Must have a .edu or .ac.uk domain email address to even view the site.
RMGA: 3 reviews? (2021/09/21)
ratemypi.com, qcist.com: リンク切れ
한국에너지공과대학교 에너지공학부 구근호 - 김박사넷: かなり多い(1000以上?)

pi rate website phd site:www.reddit.com - Google Search

Contributors ✨

Thanks goes to these wonderful people (emoji key):

This project follows the all-contributors specification. Contributions of any kind welcome!

Metadata

Release files for lab-student-survey 0.4.27

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for lab-student-survey 0.4.27
File	Size	Uploaded
lab_student_survey-0.4.27.tar.gz	15.8 kB	Nov 15, 2024	Details

Built distribution (wheel)

Table of built distributions (wheels) for lab-student-survey 0.4.27
File	Interpreter	ABI	Platform	Reset
lab_student_survey-0.4.27-py3-none-any.whl 13.8 kB Nov 15, 2024	Python 3	none	any	Details

Total release size: 29.5 kB

Release files / lab_student_survey-0.4.27.tar.gz

Download URL	lab_student_survey-0.4.27.tar.gz
Size	15.8 kB
Tags	Source
SHA-256 checksum How to use checksums	`087c341e4704bf1fd8126cbe795307789dd0864458cbabdffec2f4e623e47e93`
BLAKE2b-256 checksum How to use checksums	`805b3d70f2af8ebf5f62de873f4466f4a17cee78fc559eab202028262a99d61e`
Upload date	Nov 15, 2024
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/5.1.1 CPython/3.12.7`

Release files / lab_student_survey-0.4.27-py3-none-any.whl

Download URL	lab_student_survey-0.4.27-py3-none-any.whl
Size	13.8 kB
Tags	Python 3
SHA-256 checksum How to use checksums	`37a1b0580d7e91102ce06825c2d3b244355181454e2e49b73da72cc9acb0fc74`
BLAKE2b-256 checksum How to use checksums	`8b9a8cdb17594915bb686d5b101e15087b4e1a9d27731691179a86b45bbaa137`
Upload date	Nov 15, 2024
Uploaded using Trusted Publishing? What is trusted publishing?	No
Uploaded via	`twine/5.1.1 CPython/3.12.7`