Skip to content

Instantly share code, notes, and snippets.

View ASpathfinder's full-sized avatar

ASpathfinder

View GitHub Profile
Baidu Comate:ai 提示,个人赶脚比某灵码好用
CodeGlance Pro:小地图
Developer tools:开发者工具
Dracula Theme:西斜轨主题
Extra ToolWindow ColorfulIcons:工具栏图标
Fast Request - API Buddy
Gerry Themes Pro:rating 最高的主题
MyBatisCodeHelperPro
Nyan Progress Bar:彩虹进度条
Rainbow Brackets:彩虹括号

安装 acme.sh

邮箱不能是 example.com 这种随意的名字

$ git clone https://gitee.com/neilpang/acme.sh.git
$ cd acme.sh
$ ./acme.sh --install -m my@example.com
@ASpathfinder
ASpathfinder / refresh_toc.py
Last active December 23, 2022 17:58
refresh ms office word TOC using pywin32
import win32com.client
def update_toc(file_name):
script_dir = os.path.dirname(os.path.abspath(inspect.getfile(inspect.currentframe())))
file_path = os.path.join(script_dir, file_name)
word = win32com.client.DispatchEx("Word.Application")
doc = word.Documents.Open(file_path)
doc.TablesOfContents(1).Update()
doc.Close(SaveChanges=True)
word.Quit()
@ASpathfinder
ASpathfinder / repeat_as_header.py
Created December 22, 2022 08:09
docx repeat as header row at the top of each page
from docx import Document
from docx.oxml.shared import OxmlElement,qn
def set_repeat_table_header(row):
""" set repeat table row on every new page
"""
tr = row._tr
trPr = tr.get_or_add_trPr()
tblHeader = OxmlElement('w:tblHeader')
tblHeader.set(qn('w:val'), "true")
@ASpathfinder
ASpathfinder / rename.py
Created December 8, 2022 06:51
pandas rename dataframe column
import pandas as pd
import os
if __name__ == '__main__':
def rename(row, check_dict):
current_name = row['name']
file_name = os.path.basename(current_name)
name, ext_name = os.path.splitext(file_name)
if file_name not in check_dict:
check_dict[file_name] = 1
@ASpathfinder
ASpathfinder / camel_to_snake.py
Created May 18, 2022 10:21
camel case to snake case in one line
re.sub(r'([a-z])([A-Z])', r'\1_\2', '.'.join(['ValueError', 'MyError'])).lower()
from flask import json
from werkzeug.exceptions import HTTPException
class InsufficientStorage(werkzeug.exceptions.HTTPException):
code = 507
description = 'Not enough storage space.'
@app.errorhandler(HTTPException)
def handle_exception(e):
"""Return JSON instead of HTML for HTTP errors."""
@ASpathfinder
ASpathfinder / multiprocess_plot.py
Created September 18, 2021 15:00
matplotlib 多进程绘图
import matplotlib
matplotlib.use('agg')
import matplotlib.pyplot as plt
import threading
import datetime
import os
import time
import queue
from multiprocessing import Process, Queue
@ASpathfinder
ASpathfinder / gist:62b20367a9e7382576abf0b3c6103434
Created May 17, 2021 03:55
序列按给定num值分成num组
def grouping(l, num):
split_num = num
if split_num != 0:
split_group = int(len(l) / split_num)
yu = len(l) % split_num
query_ips_group = []
group_border = list(range(0, len(l) + yu, split_group))
group_border.append(len(l))
group_border_index = range(0, len(group_border))
for i in range(0, len(group_border_index)-1):