import xlrd
import json
import re
#打开EXCEL文件
excel = xlrd.open_workbook('C:\data.xlsx')
#获取第二个sheet
sheet = excel.sheets()[3]
arr_r=[0,0,0,0,0,0]
arr_all = [[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0]]
j=0
k=0
#red1 = []
#redshow1 = 0
#blueshow1 = 0
red0=sheet.row_values(0)
#str = red0[0]
#arr = str.split(' ')
#red0[i].split(' ')[j]
#print(int(arr[0])==12)
for i in range (0,30):
red0 = sheet.row_values(i)
str = red0[0]
arr = str.split(' ');
for j in range(0,6):
k = int(arr[j]);
arr_all[i][j] = k
print(arr_all[i][j])
//使用sklearn包中的分析算法对 arr_all[i][j] 包含红球信息 数据进行处理
#for i in range(0,6):
# j = int(arr[i]);
# arr_all[0][i] = j
# print(arr_all[0][i])
#arr_r[i]=
#for i in range(0,33):
# if(red0[i]==(i+1)):
# redshow1=redshow1+1
#print(redshow1)
#print(red0[33])
#for j in range(33,49):
# if(red0[j]==(j-33+1)):
# #blueshow1=blueshow1+1
# print(red0[j])
预测算法核心:F(X球数据)
1.根据最近三十条数据,得出最近中奖的数据 矩阵A
2.根据最近三十条数据,得出每个数字出现次数间隔之和(每一列中,不等于当前列值的数字之和),用于统计冷门的状态 矩阵B
3.根据最近三十条数据,得出每个数字出现次数之和(每一列中,等于当前列值的数字之和),用于统计热门的状态 矩阵C
4.根据矩阵A 进行线性回归,得出目标的取值范围。
5.将最热门,最冷门的数据加入到最后的取值范围。
6.MD5算法随机取值
X球数据 : 红球数据、蓝球数据
import json
import re
#打开EXCEL文件
excel = xlrd.open_workbook('C:\data.xlsx')
#获取第二个sheet
sheet = excel.sheets()[3]
arr_r=[0,0,0,0,0,0]
arr_all = [[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0],[0,0,0,0,0,0]]
j=0
k=0
#red1 = []
#redshow1 = 0
#blueshow1 = 0
red0=sheet.row_values(0)
#str = red0[0]
#arr = str.split(' ')
#red0[i].split(' ')[j]
#print(int(arr[0])==12)
for i in range (0,30):
red0 = sheet.row_values(i)
str = red0[0]
arr = str.split(' ');
for j in range(0,6):
k = int(arr[j]);
arr_all[i][j] = k
print(arr_all[i][j])
//使用sklearn包中的分析算法对 arr_all[i][j] 包含红球信息 数据进行处理
#for i in range(0,6):
# j = int(arr[i]);
# arr_all[0][i] = j
# print(arr_all[0][i])
#arr_r[i]=
#for i in range(0,33):
# if(red0[i]==(i+1)):
# redshow1=redshow1+1
#print(redshow1)
#print(red0[33])
#for j in range(33,49):
# if(red0[j]==(j-33+1)):
# #blueshow1=blueshow1+1
# print(red0[j])
#print(blueshow1)
在CMD命令行中,输入 python "文件路径+文件名";
预测算法核心:F(X球数据)
1.根据最近三十条数据,得出最近中奖的数据 矩阵A
2.根据最近三十条数据,得出每个数字出现次数间隔之和(每一列中,不等于当前列值的数字之和),用于统计冷门的状态 矩阵B
3.根据最近三十条数据,得出每个数字出现次数之和(每一列中,等于当前列值的数字之和),用于统计热门的状态 矩阵C
4.根据矩阵A 进行线性回归,得出目标的取值范围。
5.将最热门,最冷门的数据加入到最后的取值范围。
6.MD5算法随机取值
X球数据 : 红球数据、蓝球数据