Skip to main content

Python package for lab student survey

Project description

Lab Student Survey

CI Status Documentation Status Test coverage percentage

Poetry black pre-commit

PyPI Version 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.

国内

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

海外

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!

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

lab_student_survey-0.4.27.tar.gz (15.8 kB view details)

Uploaded Source

Built Distribution

lab_student_survey-0.4.27-py3-none-any.whl (13.8 kB view details)

Uploaded Python 3

File details

Details for the file lab_student_survey-0.4.27.tar.gz.

File metadata

  • Download URL: lab_student_survey-0.4.27.tar.gz
  • Upload date:
  • Size: 15.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/5.1.1 CPython/3.12.7

File hashes

Hashes for lab_student_survey-0.4.27.tar.gz
Algorithm Hash digest
SHA256 087c341e4704bf1fd8126cbe795307789dd0864458cbabdffec2f4e623e47e93
MD5 dcd95bfa0b49cd393a83464a1ad9601c
BLAKE2b-256 805b3d70f2af8ebf5f62de873f4466f4a17cee78fc559eab202028262a99d61e

See more details on using hashes here.

File details

Details for the file lab_student_survey-0.4.27-py3-none-any.whl.

File metadata

File hashes

Hashes for lab_student_survey-0.4.27-py3-none-any.whl
Algorithm Hash digest
SHA256 37a1b0580d7e91102ce06825c2d3b244355181454e2e49b73da72cc9acb0fc74
MD5 93d0aecc81d72e53dadc777a48dd9ece
BLAKE2b-256 8b9a8cdb17594915bb686d5b101e15087b4e1a9d27731691179a86b45bbaa137

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page