资源简介
2019年第十二届华中杯B题数学建模数据处理,博客地址为https://blog.csdn.net/ITxiaoangzai/article/details/89789496

代码片段和文件信息
import pandas as pd
# 柱形图-折线图
from pyecharts import Bar Line Overlap
import numpy as np
import matplotlib.pyplot as plt
#统计每个区间的个数
def readExcel(x):
shu_ju = []
shang_xin = []
for i in range(len(x[‘上新日销量‘])):
shang_xin.append(x[‘上新日销量‘][i])
shang_xin.sort()
jian_ge = (max(shang_xin) - min(shang_xin))/10
#第一季度
# a1 = [];a2 = [];a3 = [];a4 = [];a5 = []
# for i in range(len(x[‘上新日销量‘])):
# if x[‘上新日销量‘][i] >= shang_xin[0] and x[‘上新日销量‘][i] < shang_xin[0] + jian_ge/5:
# a1.append(x[‘上新日销量‘][i])
# elif x[‘上新日销量‘][i] >= shang_xin[0] + jian_ge/5 and x[‘上新日销量‘][i] < shang_xin[0] + jian_ge/5*4:
# a2.append(x[‘上新日销量‘][i])
# elif x[‘上新日销量‘][i] >= shang_xin[0] + jian_ge/5*4 and x[‘上新日销量‘][i] < shang_xin[0] + jian_ge*2/3*2:
# a3.append(x[‘上新日销量‘][i])
# elif x[‘上新日销量‘][i] >= shang_xin[0] + jian_ge*2/3*2 and x[‘上新日销量‘][i] < shang_xin[0] + jian_ge*2:
# a4.append(x[‘上新日销量‘][i])
# elif x[‘上新日销量‘][i] >= shang_xin[0] + jian_ge*2 and x[‘上新日销量‘][i] < shang_xin[0] + jian_ge*10:
# a5.append(x[‘上新日销量‘][i])
#
# shu_ju.append(len(a1))
# shu_ju.append(len(a2))
# shu_ju.append(len(a3))
# shu_ju.append(len(a4))
# shu_ju.append(len(a5))
#第二季度
# a1 = [];a2 = [];a3 = [];a4 = []
# a5 = [];a6 = [];a7 = []
# for i in range(len(x[‘上新日销量‘])):
# if x[‘上新日销量‘][i] >= shang_xin[0] and x[‘上新日销量‘][i] < shang_xin[0] + jian_ge / 5:
# a1.append(x[‘上新日销量‘][i])
# elif x[‘上新日销量‘][i] >= shang_xin[0] + jian_ge / 5 and x[‘上新日销量‘][i] < shang_xin[0] + jian_ge / 5 * 2:
# a2.append(x[‘上新日销量‘][i])
# elif x[‘上新日销量‘][i] >= shang_xin[0] + jian_ge / 5 * 2 and x[‘上新日销量‘][i] < shang_xin[0] + jian_ge / 5 * 3:
# a3.append(x[‘上新日销量‘][i])
# elif x[‘上新日销量‘][i] >= shang_xin[0] + jian_ge / 5 * 3 and x[‘上新日销量‘][i] < shang_xin[0] + jian_ge * 2 / 3 * 2:
# a4.append(x[‘上新日销量‘][i])
# elif x[‘上新日销量‘][i] >= shang_xin[0] + jian_ge * 2 / 3 * 2 and x[‘上新日销量‘][i] < shang_xin[0] + jian_ge * 2:
# a5.append(x[‘上新日销量‘][i])
# elif x[‘上新日销量‘][i] >= shang_xin[0] + jian_ge * 2 and x[‘上新日销量‘][i] < shang_xin[0] + jian_ge * 3:
# a6.append(x[‘上新日销量‘][i])
# elif x[‘上新日销量‘][i] >= shang_xin[0] + jian_ge*3 and x[‘上新日销量‘][i] <= shang_xin[0] + jian_ge*10:
# a7.append(x[‘上新日销量‘][i])
# shu_ju.append(len(a1))
# shu_ju.append(len(a2))
# shu_ju.append(len(a3))
# shu_ju.append(len(a4))
# shu_ju.append(len(a5))
# shu_ju.append(len(a6))
# shu_ju.append(len(a7))
#第三季度
a1 = [];a2 = [];a3 = [];a4 = []
a5 = [];a6 = []
for i in range(len(x[‘上新日销量‘])):
if x[‘上新日销量‘][i] >= shang_xin[0] and x[‘上新日销量‘][i] < shang_xin[0] + jian_ge / 5:
a1.append(x[‘上新日销量‘][i])
elif x[‘上新日销量‘][i] >= shang_xin[0] + jian
属性 大小 日期 时间 名称
----------- --------- ---------- ----- ----
目录 0 2019-05-04 16:58 my_hua_zhong_jian_mo\
目录 0 2019-05-04 16:52 my_hua_zhong_jian_mo\.idea\
文件 294 2019-05-02 08:16 my_hua_zhong_jian_mo\.idea\misc.xm
文件 299 2019-05-02 08:16 my_hua_zhong_jian_mo\.idea\modules.xm
文件 408 2019-05-02 08:16 my_hua_zhong_jian_mo\.idea\my_hua_zhong_jian_mo.iml
文件 21766 2019-05-04 16:36 my_hua_zhong_jian_mo\.idea\workspace.xm
目录 0 2019-05-04 16:52 my_hua_zhong_jian_mo\day\
文件 61 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171111.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171112.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171113.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171114.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171115.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171116.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171117.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171118.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171119.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171120.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171121.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171122.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171123.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171124.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171125.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171126.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171127.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171128.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171129.csv
文件 59 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171130.csv
文件 58 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171201.csv
文件 58 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171202.csv
文件 58 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171203.csv
文件 58 2019-05-02 09:45 my_hua_zhong_jian_mo\day\20171204.csv
............此处省略935个文件信息
相关资源
- Pythonamp;课堂amp;笔记(高淇amp;400;集第
- Python中Numpy库最新教程
- 用python编写的移动彩信的发送程序
- Python全栈学习笔记面向对象大作业:
- python实现的ftp自动上传、下载脚本
- 编程实现二维DCT变换
- 图像二值化
- 用FFT对信号进行频谱分析
- Tone-Reservation
- QGA 量子遗传算法
- Python版的A*寻路算法
- 差分形式的阻滞增长模型
- 遗传算法的M文件
- IronPython IDE
- 简单二阶互联系统的非线性动力学分
- pip-10.0.1.tar.gz
- Data Science from Scratch 2nd Edition
- shape_predictor_68_face_landmarks.dat.bz2 68个标
- 爬取豆瓣电影TOP250程序,包含非常详
- 手写数字识别-模板匹配法
- Stock_Watson_动态因子分析模型
- 果蝇优化算法优化支持向量回归程序
- 自己做的一个简单GUI扑克纸牌识别-
- multi output SVR
- AR过程的线性建模过程与各种功率谱估
- PCNN TOOLBOX
- 中文维基百科语料库百度网盘网址.
- plstoolbox.zip
- MSCNN_dehaze.rar
- 中国国家基础地理信息系统GIS数据
评论
共有 条评论