2 years ago
#362925
AkariYukari
How to handle dates with 30 days per month in pandas?
I am currently working with a dataset in which every month has 30 days (including February). This causes problems converting with pd.datetime(). Does pandas have some built in function or setting that allows to work with 30 days per month? I looked for it, but didn't find anything. Maybe I simply missed a keyword that I should have specifically searched for.
An example: My dataset contains entries like this:
1950-02-30 19:00:00 11.799651 57.780991 0.114197
1950-02-30 20:00:00 11.799651 57.780991 0.113489
1950-02-30 21:00:00 11.799651 57.780991 0.138634
1950-02-30 22:00:00 11.799651 57.780991 0.167683
1950-02-30 23:00:00 11.799651 57.780991 0.197449
Due to the 30th February not existing in a normal calendar (obviously) I can not convert the dates with pd.datetime(). The normal datetime format normally comes in handy to determine things like the daily maximum.
python
pandas
date
date-formatting
0 Answers
Your Answer