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

Student Categories and User Dataframe joined on UW Net ID #206

Open
nick-falco opened this issue Nov 9, 2021 · 1 comment
Open

Student Categories and User Dataframe joined on UW Net ID #206

nick-falco opened this issue Nov 9, 2021 · 1 comment
Assignees
Labels

Comments

@nick-falco
Copy link
Contributor

When creating the RAD datafile the Student Categories metadata file dataframe is joined to the canvas-analtyics User model dataframe. This join uses the UW net id which is prone to change. This could lead to records potentially getting dropped.

See https://github.com/uw-it-aca/canvas-analytics/blob/main/data_aggregator/dao.py#L1159

We need to determine a way to join these dataframes that is not prone to data loss. Alternatively we could keep the Student Categories file more up to date.

@nick-falco nick-falco added the bug label Nov 9, 2021
@nick-falco nick-falco self-assigned this Nov 9, 2021
@nick-falco
Copy link
Contributor Author

UPDATE: The student categories file is now updated weekly. See PR #210

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

No branches or pull requests

1 participant