["python","pandas","dataframe","datetime","type-conversion"]
Convert Pandas Column to DateTime

I have one field in a pandas DataFrame that was imported as string format. It should be a datetime variable. How do I convert it to a datetime column, and then filter based on date? Example: raw_data = pd.DataFrame({'Mycol': ['05SEP2014:00:00:00.000']})
Use the to_datetime function, specifying a format to match your data. df['Mycol'] = pd.to_datetime(df['Mycol'], format='%d%b%Y:%H:%M:%S.%f')