- 博客(11)
- 收藏
- 关注
RSS订阅原创 Numpy实现GroupBy
# -*- coding: utf-8 -*-import numpy as npdef groupby(arr, num, *function): tmp = arr[:,np.argsort(arr[num,:])] ll = [] for i in range(len(arr)): ll.append(np.split(tmp[i,:], np.unique(tmp[num,:], return_index=True)[1])[1:]) new = np.stack(ll, a.
2022-05-22 19:34:26
1930
原创 postgre批量替换列的关键字
create function repp(nowchar text, afterchar text) returns SETOF text language plpgsqlas$$DECLARE r TEXT;DECLARE res TEXT :='';BEGIN foreach r in ARRAY (SELECT ARRAY(SELECT column_name FROM information_schema.COLUMNS WHERE table_catalog='work' A.
2022-01-25 23:20:04
1307
原创 PowerShell 实现Word批量替换关键词
$file_path = "E:\test" #文件位置$save_path = "E:\else\" #替换后的文件位置$files = Get-Childitem $file_path -Include *.docx,*.doc -Recurse # 获取文件夹下面的所有的Word文档类型文件$need_to_replace = @("生育","费用") .
2021-11-16 17:08:28
1031
原创 用requests在命令行中实现bing搜索
import requestsimport refrom prompt_toolkit import print_formatted_text,HTMLfrom prompt_toolkit.styles import Style# 设置文字颜色style = Style.from_dict({ 'aaa': '#FFFFFF', 'bbb': '#44ff00 italic', 'ttt': '#0000FF'})# 正则提取摘要和链接title_patter.
2021-11-04 23:54:16
459
1
原创 使用Powershell图片转PDF
#set-ExecutionPolicy RemoteSignedfunction PicToPDF ($Path){#$pic_path = "C:\Users\Lenovo\Pictures\Saved Pictures\badio.jpg"[system.reflection.assembly]::loadwithpartialname("System.Drawing") | Out-Null$pic = New-Object System.Drawing.Bitmap($Path)$.
2021-11-04 23:48:11
426
原创 简单的Kmeans实现
import numpy as npimport randomimport pandas as pdimport matplotlib.pyplot as plt#K = 4 需要的质心数量# 初始化数据def init_data(): df = pd.read_csv('/mnt/d/EDA/Cluster/cluster_data.csv') nd = np.array(df) # 归一化 data = (nd - np.min(nd,axis=0)) /.
2021-11-04 23:45:14
119
原创 xlwings批量修改Excel表格的同一位置单元格
import osimport xlwings as xwfrom tqdm import tqdmpath = 'E:\\tempory_download\\'path_list = os.listdir(r'E:\tempory_download')whole_path_list = []for i in path_list: if 'xls' in i: whole_path_list.append(path+i) elif 'xlsx' in i: whole_path.
2021-11-04 22:45:12
675
原创 conda安装scikit-learn报错
在win7下安装scikit-learn会报错ERROR conda.core.link:_execute(701): An error occurred while installing package 'defaults::scikit-learn-1.0.1-py37hf11a4ad_0'.Rolling back transaction: doneLinkError: post-link script failed for package defaults::scikit-learn-1
2021-11-03 23:10:01
1954
4
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人