pandas to_csv on dataframe with a column that has dates below 1900
Upgrading pandas from 0.15.1 to 0.17.1 resolved this issue.
I need to save to csv, but have date values in the series that are below 1900 (ie Mar 1 1899), which is preventing this from happening. I get ValueError: year=1899 is before 1900; the datetime strftime() methods require year >= 1900. It seems a little absurd for a function like this to work only for dates above 1900s, so I think there must be something I am missing. What is the right way of getting a csv when you're working with a dataframe that has a column with dates before the 1900s?