- 博客(11)
- 收藏
- 关注
原创 Numpy实现GroupBy
# -*- coding: utf-8 -*- import numpy as np def 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
2273
原创 postgre批量替换列的关键字
create function repp(nowchar text, afterchar text) returns SETOF text language plpgsql as $$ 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
1524
原创 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
1503
原创 用requests在命令行中实现bing搜索
import requests import re from prompt_toolkit import print_formatted_text,HTML from prompt_toolkit.styles import Style # 设置文字颜色 style = Style.from_dict({ 'aaa': '#FFFFFF', 'bbb': '#44ff00 italic', 'ttt': '#0000FF' }) # 正则提取摘要和链接 title_patter.
2021-11-04 23:54:16
809
1
原创 使用Powershell图片转PDF
#set-ExecutionPolicy RemoteSigned function 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
660
原创 简单的Kmeans实现
import numpy as np import random import pandas as pd import 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
213
原创 xlwings批量修改Excel表格的同一位置单元格
import os import xlwings as xw from tqdm import tqdm path = '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
833
原创 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: done LinkError: post-link script failed for package defaults::scikit-learn-1
2021-11-03 23:10:01
2151
4
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人
RSS订阅