![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
zhangxiangnan0906
这个作者很懒,什么都没留下…
展开
-
python通过excel连接mysql进行查询
文章目录前言代码总结前言我们需要根据excel表的一些关键数据,拼接sql语句进行查询代码import pandas as pdimport pymysqlexcel = pd.read_excel(r"xxxxxxxxx", engine="openpyxl")biao = excel["表"]ziduan = excel["字段"]shuoming = excel["说明"]conn = pymysql.connect( host='xxx', user='xx',原创 2021-05-10 20:00:07 · 223 阅读 · 0 评论 -
sql语句计算缺失率
文章目录背景语句结果背景计算某个数据库中某个表的某个属性的缺失率。语句SELECT COUNT(*) FROM `表名` WHERE `属性` IS NULL INTO @meiyou;SELECT COUNT(*) FROM `表名` INTO @total;SELECT @meiyou/@total AS 缺失值;结果...原创 2021-05-09 15:35:13 · 2059 阅读 · 0 评论