Newdf
# Convert data types
df.Date = df.Date.astype('datetime64')
df.StandardDate = df.StandardDate.astype('datetime64')
df.DateSK = df.DateSK.astype('int')
df.Day = df.Day.astype('int')
df.DOWInMonth = df.DOWInMonth.astype('int')
df.DayOfYear = df.DayOfYear.astype('int')
df.WeekOfYear = df.WeekOfYear.astype('int')
df.WeekOfMonth = df.WeekOfMonth.astype('int')
df.Month = df.Month.astype('int')
df.Quarter = df.Quarter.astype('int')
df.Year = df.Year.astype('int')
print 'Data Types'
print df.dtypes
#From Excel to DataFrame
from pandas import DataFrame, ExcelFile
import pandas as pd
import json
# Path to excel file
# Your path will be different, please modify the path below.
location = r'//covenas/decisionsupport/meinzer/projects/network/Contract Deliverables for Emanio Reports.xls'
