Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

allow reading in directly from google sheet #35

Open
ageller opened this issue May 17, 2022 · 3 comments
Open

allow reading in directly from google sheet #35

ageller opened this issue May 17, 2022 · 3 comments
Assignees

Comments

@ageller
Copy link
Contributor

ageller commented May 17, 2022

Currently we need to make additional csv files, but since we're working in Colab, we should be able to read in directly from the Google Sheet. I suppose we will still have to edit the sheet to make sure it conforms to the necessary format (e.g., with names from preferences) -- though maybe that will be fixed when we implement dropdowns for preferences.

The other main thing that we'll need to improve to streamline is to have the name_list.csv file read in from Kari's file. (Currently we need to generate it ourselves).

@ageller
Copy link
Contributor Author

ageller commented May 17, 2022

This works in the colab notebook on Drive. Once we have the names list from Kari, we can read that instead of having to generate the list. After that we can close this issue.

@agurvich agurvich self-assigned this May 17, 2022
@agurvich
Copy link
Contributor

will also need to update input reader to look for the new preference columns, parse commas vs.. semi-colons, etc... will need a test dataset

@agurvich
Copy link
Contributor

f80931c brings us half-way there. Now just need to point Python code to the new namelist.csv. After that, will need to submit the updated survey a couple of times to get the format right with the new column ordering.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants