In [5]:
import pandas as pd
import numpy as np
In [2]:
df = pd.read_csv('/Users/jonahwilliams/Documents/SFPD.csv')
In [3]:
df.head()
Out[3]:
In [9]:
df['Category'] = df['Category'].map(lambda x: x.replace(',',' '))
df['Resolution'] = df['Resolution'].map(lambda x: x.replace(',',' '))
df['Descript'] = df['Descript'].map(lambda x: x.replace(',',' '))
In [14]:
df['UTC'] = pd.to_datetime(df['Date'] + ' ' + df['Time'])
In [16]:
df = df.drop(['Date', 'Time'], axis=1)
In [17]:
df.head()
Out[17]:
In [ ]: