search

itsjpb / 470-avalanche-prediction

repository for ad470 team 3 spring 2020
MIT License
3 stars 0 forks source link

Standardize dates #50

Open alyoshenka opened 1 year ago

alyoshenka commented 1 year ago

It would be nice if all the dates in all our dataframes were formatted the same. Maybe we can write a script that does this for us? We touched on it last quarter. This would make it a lot easier to match the same dates in different dataframes (I think).

It seems the data from all weather sources is formatted the same (needs checking, this was just my view from a quick glance), but the dates on the danger ratings are different. This is in part because these use just days, while the weather data includes time as well.

jaohara commented 1 year ago

I'd add to this that we don't want commas or quotes in the date fields - I pulled a random .csv to test displaying them in the note vault, and with the dates containing commas it split the dates into two fields

itsjpb commented 1 year ago

@jaohara standard datetime (with the time as 00:00:0000) or standard date (YYYY-MM-DD) should work, yea?

right now i am working to convert everything to YYYY-MM-DD (it's the lowest common denominator), but datetime or another will work fine from there.