czc_hehedahaha-CSDN博客

原创 CUDA 11.7 版本下安装Tensorflow-gpu

首先看了网上的大佬说要将protobuf更换成较低的版本。安装Tensorflow-gpu。

2024-01-15 15:56:53 1070 1

原创 py3.8安装fprophet过程

创建一个python3.8的conda虚拟环境安装pystan和fbprophet。

2023-11-08 11:11:03 1675 2

使用case when 进行行转列SELECT userid,SUM(CASE `subject` WHEN '语文' THEN score ELSE 0 END) as '语文',SUM(CASE `subject` WHEN '数学' THEN score ELSE 0 END) as '数学',SUM(CASE `subject` WHEN '英语' THEN score ELSE 0 END) as '英语',SUM(CASE `subject` WHEN '政治' THEN scor.

2022-02-23 15:32:10 475

原创获取文件夹文件名及pandas定位

import pandas as pdimport numpy as npimport os.pathpath=(r'文件夹路径')file_list = os.listdir(path)#获取该文件夹内所有文件或者文件夹名称及后缀for i in file_list:#可以用for循环提取各文件夹或者文件sorted(list(data))#sorted 排序#list(data) 获取pandas 列标题#获取pandas数据行数column_index = data.

2021-12-20 14:02:55 1638

原创 mysql 查询增加自增列

set @id:=0;select (@id:=@id:+1) as id,‘列名’ from '表名'第二种写法select (@id:=@id:+1) as id,‘列名’ from '表名',(select @id:=0) as '别名'参考：https://blog.csdn.net/jiongxian1/article/details/105444144?spm=1001.2101.3001.6650.1&utm_medium=distribute.pc_relevant.

2021-12-06 16:55:45 2549

原创共现lalal

import pandas as pdimport numpy as nplidata＝ pd. read＿excel（＇离任汇总.xlsx＇）ruedata＝pd. read＿excel（＇阅卷汇总.xlsx＇）print(lidata. head())print(ruedata.head())ruedata［＇所在律师事务所＇］＝ruedata［＇所在律师事务所＇］．fillna（＇无＇） print（ruedata［ruedata［＇所在律师事务所＇］＝＝＇无＇］）js＝ruedata.

2021-06-17 09:39:14 85

原创给MySQL批量添加注释

添加注释时，先运行，之后再用这个顺序v注释，不要乱顺序SELECT COLUMN NAME,column comment from information schema. COLUMNS WHERE TABLE NAME ='ods yb csj abo7' and table schema= 'ods jw qxsj;import pandas as pd import numpy as npfrom pymysql import connect#链接数据库conn = conne.

2021-06-16 11:55:31 1848

原创采集数据库行数多数据库

import pandas as pdimport numpy as npfrom pymysql import connect[5]: conn = connect (host=' 10. 10. 169. 57', user-' chenzhanchao', password=' chenzhanchao', charset=' utf8)In [6]: list1 =["ZSH D32D10JJJCZ-SDSH-XZCF","ZSHD42 D16JJJCZ_SHBJSJ""ZS

2021-06-16 11:32:56 133

原创汇总同一文件夹下多个excel

# -*- coding:utf-8 -*-import openpyxlimport xlrdimport os.pathimport timeworkbook1 = openpyxl.load_workbook('C:/Users/Administrator/Desktop/汇总.xlsx')#提前建一个汇总的表name_list = workbook1.sheetnames #获取提前建一个汇总的表的sheet表名sheet1 = workbook1[name_list[0]]#取第一.

2021-06-16 11:10:21 916

原创 excel解合并单元格

import openpyxlfrom openpyxl.styles import PatternFillworkbook = openpyxl.load_workbook(r'c\Users\水务局注释.xlsx')#加载已经存在的表name_list = workbook.sheetnamesworksheet= workbook[name_list[1]]fill = PatternFill("solid",fgColor="FF0000")#设置填充样式m_list= worksh.

2021-06-16 11:05:51 145

czc_hehedahaha的博客