Why is pandas.to_datetime slow for non standard time format such as ‘2014/12/31’

This is because pandas falls back to dateutil.parser.parse for parsing the strings when it has a non-default format or when no format string is supplied (this is much more flexible, but also slower). As you have shown above, you can improve the performance by supplying a format string to to_datetime. Or another option is to … Read more