import os

import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

zika_df = pd.read_csv(os.path.join('..', 'input', 'cdc_zika.csv'), low_memory=False)
keep_rows = pd.notnull(zika_df['report_date'])
zika_df = zika_df[keep_rows]
print('Removed {:d} out of {:d} rows with missing report_date.'.format(len(keep_rows) - sum(keep_rows), len(keep_rows)))
zika_df.index = pd.to_datetime([d.replace('_', '-') for d in zika_df['report_date']], format='%Y-%m-%d')
zika_df.sort_index(inplace=True)
zika_df.index.rename('report_date', inplace=True)
zika_df.drop('report_date', axis=1, inplace=True)