text_plain_output_1.png
import matplotlib.pyplot as plt

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

train = pd.read_csv('../input/train.csv')
test = pd.read_csv('../input/test_id.csv')

train['UPDATE_TIME'] = train['UPDATE_TIME'].astype('datetime64[ns]')
test['UPDATE_TIME'] = test['UPDATE_TIME'].astype('datetime64[ns]')

zone_1 = pd.DataFrame()
zone_2 = pd.DataFrame()
zone_3 = pd.DataFrame()
for i in range(train.shape[0]):
    if train.at[i, 'ZONE_CODE'] == 'ZONE01':
        zone_1 = zone_1.append(train.iloc[i])
    elif train.at[i, 'ZONE_CODE'] == 'ZONE02':
        zone_2 = zone_2.append(train.iloc[i])
    else:
        zone_3 = zone_3.append(train.iloc[i])
for i in range(zone_1.shape[0]):
    zone_1.at[i, 'HOUR_ID'] = i
for i in range(zone_2.shape[0]):
    zone_2.at[i, 'HOUR_ID'] = i
for i in range(zone_3.shape[0]):
    zone_3.at[i, 'HOUR_ID'] = i
import matplotlib.pyplot as plt
fig, ax = plt.subplots()
line_1 = ax.plot(zone_1['HOUR_ID'], zone_1['MAX_USER'], label='zone 1')
line_2 = ax.plot(zone_2['HOUR_ID'], zone_2['MAX_USER'], label='zone 2')
line_3 = ax.plot(zone_3['HOUR_ID'], zone_3['MAX_USER'], label='zone 3')
ax.legend()
plt.show()