prepare_data.py

# read bitcoin pricing data
bitcoin_data = pd.read_csv('input/bitstampUSD_1-min_data_2012-01-01_to_2018-11-11.csv')

# parse date using pandas
bitcoin_data['date'] = pd.to_datetime(bitcoin_data['Timestamp'],unit='s').dt.date

# group by date and pick 'Weighted_Price'
grouped_data = bitcoin_data.groupby('date')
real_price = grouped_data['Weighted_Price'].mean()

# prepare data for plot.ly
data = [go.Scatter(x=real_price.index, y=real_price.values)]

# plot time series data
plotly.offline.iplot(data)