09 2018 档案

计算概率--三角形概率
摘要：from sympy import integratefrom sympy.abc import ximport random#integrate（参数1=概率密度函数，参数2=积分起始点，参数3=积分结束点）概率密度函数： a<=x<=medic:2*(x-a)/((b-a)*(c-a)) med 阅读全文

posted @ 2018-09-28 13:45 happygril3 阅读(411) 评论(0) 推荐(0)

拟合
摘要：x = np.arange(1, 17, 1)y = np.array([4.00, 6.40, 8.00, 8.80, 9.22, 9.50, 9.70, 9.86, 10.00, 10.20, 10.32, 10.42, 10.50, 10.55, 10.58, 10.60])df=pd.Dat 阅读全文

posted @ 2018-09-28 10:50 happygril3 阅读(124) 评论(0) 推荐(0)

mysql添加注释
摘要：-- 查看字段类型-- show columns from campaign_distribute --给表添加注释 -- alter table campaign_distribute comment '计划分配表' -- 给字段添加注释 -- alter table campaign_distr 阅读全文

posted @ 2018-09-27 11:59 happygril3 阅读(91) 评论(0) 推荐(0)

dateframe取数据
摘要：import numpy as npimport pandas as pd## x1=[1,2,3,4]# x2=[4,5,6,7]# x3=[7,8,9,10]# df=pd.DataFrame(# { 'x1':x1,# 'x2':x2,# 'x3':x3# }# )# print(df)# p 阅读全文

posted @ 2018-09-26 18:56 happygril3 阅读(208) 评论(0) 推荐(0)

调用数据库-corina
摘要：pym = mysql(host='#####', port=3306, user='######', password='########', database='algorithm')#查询数据 charge_sql = 'SELECT log_date, campaign_id, campai 阅读全文

posted @ 2018-09-21 11:36 happygril3 阅读(134) 评论(0) 推荐(0)

连接数据库-corina
摘要：import pymysqlimport pandas as pdfrom pandas import DataFramefrom sqlalchemy import create_engineclass mysql(): def __init__(self,host,port,user,passw 阅读全文

posted @ 2018-09-21 11:33 happygril3 阅读(131) 评论(0) 推荐(0)

mysq 日期l查询
摘要：pym=mysql(host = '#', port = 3306, user = '#',passworld='#',database='#')#根据起始和结束时间 charge_sql = 'SELECT log_date, campaign_id, campaign_name,roi,FROM 阅读全文

posted @ 2018-09-18 18:44 happygril3 阅读(151) 评论(0) 推荐(0)

众数
摘要：x=[1 ,1 ,4, 4, 5 ,7, 7, 7, 9] res=pd.cut(x,bins=4,include_lowest=True)#[(0.991, 3.0], (0.991, 3.0], (3.0, 5.0], (3.0, 5.0], (3.0, 5.0], (5.0, 7.0], (5 阅读全文

posted @ 2018-09-17 10:55 happygril3 阅读(89) 评论(0) 推荐(0)

遗传算法
摘要：import numpy as npimport pandas as pdimport math #将二进制转化为十进制 x∈[0,10]def b2d(b): t = 0 for j in range(len(b)): t += b[j] * (math.pow(2, j)) t = t * 10 阅读全文

posted @ 2018-09-15 20:36 happygril3 阅读(326) 评论(0) 推荐(0)

调用数据库--stone
摘要：from Mysql_operate_class import mysqldef saveMysqlData(sql, dbname="algorithm"): pym = mysql(host='rm-vy1327toi305a43ab.mysql.rds.aliyuncs.com', port= 阅读全文

posted @ 2018-09-14 16:01 happygril3 阅读(172) 评论(0) 推荐(0)

连接数据库-stone
摘要：# -*- coding:utf-8 -*-import pymysqlclass mysql: def __init__(self, host, port, dbuser, dbpwd, dbname): self.host = host self.port = port self.dbuser 阅读全文

posted @ 2018-09-14 15:59 happygril3 阅读(148) 评论(0) 推荐(0)

dateframe
摘要：import pandas as pdimport numpy as npfrom pandas import DataFrameimport datetime# 定义dataframex1=[10,20,30,40,50,60]x2=['male','male','male','female',' 阅读全文

posted @ 2018-09-10 15:08 happygril3 阅读(372) 评论(1) 推荐(0)

导航