Dataset tasks - Githubissues

anebz / boulder

Occupancy tracker for bouldering gyms

http://boulder.anebz.eu

7 stars 3 forks source link

Dataset tasks #1

Closed anebz closed 3 years ago

anebz commented 3 years ago

[x] Delete rows at night (current_time before 7:00, and after 23:00)
[x] Delete rows where minute is not in 00, 15, 30 or 45
[x] Convert ost and west from the old format to muenchen-ost, muenchen-west to new format
[x] Turn occupancy, weather_temp to int types
[x] Delete % in the occupancy column in some rows
[x] Convert date format to: YYYY/MM/DD HH:MM (hint: datetime package in python)
[x] The oldest entries have no weather information: ADVANCED Use the PyOWM API (see README) and obtain the weather for the past dates

anebz commented 3 years ago

Hey @AnglinaBhambra , I checked the code for the first three tasks, nice! I didn't know about the .replace(['ost','west'], ['muenchen-ost','muenchen-west']) function 👏

AnglinaBhambra commented 3 years ago

Thanks for your comment 😄 @anebz OWM History API is not available for free subscribers - any suggestions for how I can get the data?

anebz commented 3 years ago

Aah pity. I found this tutorial and this package in a quick google search, if you want to go for it and experiment feel free, otherwise it's not thaat important we can just put average weather data for that time of year and that hour

AnglinaBhambra commented 3 years ago

using Open Weather Map API to retrieve data (seems easier as it gives me hourly weather temp & status). then will include the average weather data for the times in between (not sure about filling in status, hopefully there isn't too much variance there)

anebz commented 3 years ago

Ah cool, you can try that. If there is no status, we can just put Clouds