数据可视化-制作交易收盘价
思路:从网上下载json格式的文件----→先打开json格式的文件,储存月份、日期、星期等的数据----→建立收盘价折线图和收盘价对数变换折线图----→为做时间序列分析数据,先进行封装函数----→做按月份、按周期、按星期的对应图----→最后做数据仪表盘
import json
#将数据加载到一个列表里
filename = 'btc_close_2017.json'
with open(filename) as f:
btc_data = json.load(f)
#打印每一天的信息
for btc_dict in btc_data:
date = btc_dict['date']
month = int(btc_dict['month'])
week = btc_dict['week']
weekday = btc_dict['weekday']
close = int(float(btc_dict['close']))
print("{} is month {} week {}, {}, the close price is {} RMB".format(date, month, week, weekday, close))
#创建5个列表,分别存储日期和收盘价
dates = []
months = []
weeks = []
weekdays = []
close = []
for btc_dict in btc_data:
dates.append(btc_dict['date'])
months.append(btc_dict['month'