Format the CSV file of "National Holiday" of the Cabinet Office with pandas
That was hit on Twitter. I wondered what kind of terrible thing it was, and opened it with python pandas. This is the real thing
I can't say anything because I don't know how to use this CSV file, but is this so terrible? I was hoping that the rows and columns would be out of alignment, and the date format would be different. Even if the date format is different, pandas has a function to unify the time series, so it can be solved relatively easily.
Let's shape it anyway.
What was shaped -Delete the column where the missing value exists -Delete duplicate names -Change the date from string type to datetime type These are the three points.
Is this a little easier to see?
By the way, let's display whether there is a gap every year on that holiday.
As a bonus, there is also a version in one row
This kind of data formatting is easy with Pandas.
Recommended Posts