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

Update the data about high schools (pl: liceum) #16

Open
5 tasks
annkamsk opened this issue Sep 20, 2020 · 0 comments
Open
5 tasks

Update the data about high schools (pl: liceum) #16

annkamsk opened this issue Sep 20, 2020 · 0 comments
Labels

Comments

@annkamsk
Copy link
Member

I suggest this as a first step in resolving #15. My strong recommendation is to first take care of liceums as this is the data we mostly already have in our database and this is the focus of this issue.

The spreadsheet "oddziały na stan 7 września" holds the data in a different format that ours, so first we need to read the data and translate it to our model. This is going to be similar to: load_data_school script. After that we can identify all of the columns that we don't have in our database and propose how to update our model (by creating a list of potential new fields in this discussion).

The final step would be to add the new data to our database, keeping in mind that we probably already have some information (like school's address for example) and we definitely don't want duplicates.

As a list:

  • Create a script (maybe in csvs/scripts?) that reads the data about high schools from the spreadsheet
  • (In the script) Create objects from our models (School, HighSchoolClass, Statistics etc) with data from the spreadsheet
  • Identify the data that cannot be put into our models yet and propose new fields for our models in this issue for discussion
  • Add the new fields (if we decide it's necessary)
  • Add the new data to database (checking if it doesn't already exist there!)
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

2 participants