python爬虫某东商品销售数据分析

# 分析不同码数的鞋子的销量

import openpyxl
import matplotlib.pyplot as pit

wk = openpyxl.load_workbook('销售数据.xlsx')
sheet =wk.active
rows = sheet.max_row
cols = sheet.max_column
# print(rows, cols)
list = []
for i in range(1, rows+1):
size = sheet.cell(i, 3).value
list.append(size)

# for item in list:
#     print(item)
# 数据统计，统计不同码数的鞋子的销量。使用字典。使用销售数量作value
dict_size = {}
for item in list:
dict_size[item] = 0

# for item in dict_size:
#     print(item, dict_size[item])

for item in list:
for size in dict_size:
if item == size:
dict_size[size] += 1
break
# for item in dict_size:
#     print(item, dict_size[item])

list_total = []
for item in dict_size:
list_total.append([item, dict_size[item], dict_size[item]/100*1.0])
# for item in list_total:
#     print(item)

# 数据可视化
labels = [item[0] + "码" for item in list_total]
fraces = [item[2] for item in list_total]
pit.rcParams['font.family'] = ['SimHei']
pit.pie(x=fraces, labels=labels, autopct='%1.1f%%')
# pit.show()
pit.savefig('销量占比饼图.jpg')

备注：仅使用了100条数据。

图片效果如下：