Error started: pandas.to_datetime

Question

I am trying to convert a pandas data column to datetime. It worked fine until I uninstall and install python again. I am using Python 2.7.10, Anaconda 2.4.0 (64-bit). pandas version '0.17.1'. Here is my code:

import os, sys
from datetime import date, timedelta
import pandas as pd
import numpy as np
fdf = pd.read_csv(f,delimiter='\t')
fdf['ORDER_DATETIME']=pd.to_datetime(fdf['ORDER_DATETIME'],"%Y/%m/%d %H:%M")

The following error message appears:

File "... \ AppData \ Local \ Continuum \ Anaconda2 \ lib \ site-packages \ spyderlib \ widgets \ externalshell \ sitecustomize.py", line 71, in execfile exec (compilation (scripttext, filename, 'exec'), glob , loc)

File "... / filename.py", line 245, in fdf ['ORDER_DATETIME'] = pd.to_datetime (fdf ['ORDER_DATETIME'], "% Y /% m /% d% H:% M")

File "C ... \ AppData \ Local \ Continuum \ Anaconda2 \ lib \ site-packages \ pandas \ util \ decorators.py", line 89, in the shell return func (* args, ** kwargs)

File "... \ AppData \ Local \ Continuum \ Anaconda2 \ lib \ site-packages \ pandas \ tseries \ tools.py", line 276, in to_datetime unit = unit, infer_datetime_format = infer_datetime_format)

File "... \ AppData \ Local \ Continuum \ Anaconda2 \ lib \ site-packages \ pandas \ tseries \ tools.py", line 390, in _to_datetime values ​​= _convert_listlike (arg._values, False, format)

File "... \ AppData \ Local \ Continuum \ Anaconda2 \ lib \ site-packages \ pandas \ tseries \ tools.py", line 372, in _convert_listlike require_iso8601 = require_iso8601)

File "pandas \ tslib.pyx", line 1847, in pandas.tslib.array_to_datetime (pandas \ tslib.c: 37155)

"pandas\tslib.pyx", 1864, pandas.tslib.array_to_datetime (pandas\tslib.c: 33604)

AssertionError

Answer 1

:

fdf['ORDER_DATETIME']=pd.to_datetime(fdf.loc[:,'ORDER_DATETIME'],format="%Y/%m/%d %H:%M")

"format =" .