In [ ]:
import pandas as pd
import matplotlib.pyplot as plt
%pylab inline
In [ ]:
headers = ["date", "visitors"]
data = pd.read_csv("visitors.csv", skiprows=4, names = headers)
data.head()
In [ ]:
headers = ["date", "visitors_new"]
data_new = pd.read_csv("visitors-new.csv", skiprows=4, names = headers)
data_new.head()
In [ ]:
data_combined = pd.merge(data, data_new)
data_combined.head()
In [ ]:
# Sort by date
# COnvert date to index
# Plot
data_combined.sort(["date"], inplace=True)
data_combined.set_index("date", inplace=True)
data_combined.head()
In [ ]:
data_combined.plot()
plt.show()
In [ ]: