weixin_41789633的博客

import pandas as pdimport matplotlib.pyplot as pltimport numpy as np#加载数据def inspect_data(file_root): dataframe=pd.read_csv(file_root) print("数据基本信息：") print(dataframe.info()) pri...

from sklearn import datasetsfrom sklearn import svmiris=datasets.load_iris()digits=datasets.load_digits()#选择SVM模型svm_classifier=svm.SVC(gamma=0.0001,C=100)#手动划分训练集，测试集n_test=100#测试数量train_x=d...

import pandas as pd#加载数据def read_data(file_root): dataframe=pd.read_csv(file_root) print("数据的基本信息：") print(dataframe.info()) print("数据的行是%i,列是%i"%(dataframe.shape[0],dataframe.shape...

import pandas as pdimport numpy as npimport matplotlib.pyplot as plt#1.加载并查看数据基本信息def read_dataset(file_root): dataframe=pd.read_csv(file_root) print("数据的基本信息：") print(dataframe.info(...

#BP人工神经网络实现#1.读取数据#2.导入keras.models Sequential /keras.layers.core Dense,Activation#3.Squential 建立模型#4.Dense 建立层#5.Activation激活函数#6.compile模型编译#7.fit训练（学习）#8.验证（测试，分类预测）import numpy as npim...

import pandas as pdimport numpy as npimport matplotlib.pylab as pylfile_root="路径文件"dataframe=pd.read_csv(file_root)x=dataframe.ix[:,:].as_matrix()from sklearn.cluster import KMeansk_mean=KMean...

import pandas as pdfile_root="G:/python/源码/源码/lesson.csv"dataframe=pd.read_csv(file_root,encoding="gbk")#print(dataframe)x=dataframe.ix[:,1:5].as_matrix()y=dataframe.ix[:,5].as_matrix()for i in...

import pandas as pdroot="G:/python/源码/源码/luqu.csv"dataframe=pd.read_csv(root)#print(dataframe)x=dataframe.ix[:,1:4]y=dataframe.ix[:,0]from sklearn.linear_model import LogisticRegressionmodel2=...

import numpy as npdef bayes(train_data,labels,test_data): train_data_num=len(train_data)#测试数据或类别长度 not_r_label=set(labels)#不重复的类别 label_rate={} for item in not_r_label: label...

-- 9、 查询“95031”班的学生人数。select count(1) from student where class = 95031;-- 10、查询Score表中的最高分的学生学号和课程号。select sno, cno from score where degree = (select max(degree) from score );-- 11、查询‘3-105’号课程的平均分。se...

import pymysqlconnection=Nonecursor=Nonetry: connection=pymysql.connect('localhost','root','root','test1') cursor = connection.cursor() sql = 'insert into dept values (%s,%s,%s)' tr...

-- 子查询-- 子查询语句可以在select， from where 中-- 查询工资高于平均工资的雇员名字和工资。select ename, sal from emp where sal > (select avg(sal) as avg_sal from emp);-- 查询和scott同一部门且工资比他低的雇员名字和工资select t1.ename, t2.sal from emp...

-- 表链接-- 内链接use test1;-- 第一中表示方式(没有外键约束的两张表一般使用第一种)：select ename, dname from emp, dept where emp.deptno = dept.deptno;-- 第二种表示方式（有外键约束）select ename,dname from emp inner join dept on emp.deptno = dept....

-- 事务create table t_account(id int(8) primary key,money double)-- rollback 是回滚即删除事务begin;update t_account set money=money-100 where id=1;update t_account set money=money+100 where id=2;COMMIT;-- 表的关系-...

-- 创建emp表ename字段的索引create index i_emp_index on emp(ename);-- 删掉索引drop index i_emp_index;-- 创建一个视图create view v_emp as select empno,ename,job from emp;select * from v_emp limit 1;insert into v_emp valu...

-- emp表的emptno字段增加外键dept表的deptnoalter table emp add constraint foreign key (deptno) references dept (deptno);create table t_dept(id int(8) primary key,name varchar(200) not null,emp_max_count int(2) c...

-- 统计每个部门的平均工资,存在group by分组，select字句不能写group by没有的字段，除非这些用在聚合函数中select deptno,avg(sal) from emp group by deptno;-- 统计每个部门的人数，最高工资，最低工资，平均工资select count(0) as 人数, max(sal) as 最高工资, min(sal) as 最低工资,avg...

use test1;-- 统计一共有多少个员工select count(*) from emp;select count(1) from emp;select count(empno) from emp;-- 工资最高的select max(sal) from emp;-- 平均工资select avg(sal) from emp;-- 字符串链接的函数select CONCAT(ename,'的...

-- 查询emp的所有数据select * from emp;-- 指定字段进行查询select empno, job, ename from emp;-- 查询所有员工的年薪select ename,sal*12 as 年薪 from emp;-- 别名使用 as,as 可以省略select ename,sal*12 年薪 from emp;-- 去重select distinct deptno...

-- 创建表create table t_student(id int(8) PRIMARY KEY,grade int(8) not null,address varchar(200) not null UNIQUE);-- 删除表drop table t_student;-- 在表中添加一个新字段alter table t_person add grade int(8) DEFAULT 0;-...