madlan.ipynb

# coding: utf-8

# In[2]:


import numpy as np
import pandas as pd
from datetime import datetime


# In[3]:


xl = pd.ExcelFile("NYPD_Ilan.xlsx")


# In[4]:


xl.sheet_names


# In[9]:


df = xl.parse("NYPD_Complaint_Data_Historic")


# In[7]:


for i in range(0, 100):
    if type(df['CMPLNT_FR_DT'][i])==str:
        df['CMPLNT_FR_DT'][i]= datetime.strptime(df['CMPLNT_FR_DT'][i], '%m/%d/%Y')
print(type(df['CMPLNT_FR_DT'][10]))


# In[ ]:


for i in range(100, 1048575):
    if type(df['CMPLNT_FR_DT'][i])==str:
        df['CMPLNT_FR_DT'][i]= datetime.strptime(df['CMPLNT_FR_DT'][i], '%m/%d/%Y')
print(type(df['CMPLNT_FR_DT'][10]))


# In[1]:


df2 = df.head(5)
df2


# In[31]:


type(df2['CMPLNT_FR_DT'][2])