Skip to content

Instantly share code, notes, and snippets.

View wgzhao's full-sized avatar

Steven Zhao wgzhao

219 followers · 368 following
  • China
View GitHub Profile
@wgzhao
wgzhao / word_to_card.py
Created October 26, 2025 13:58
把单词列表转为单写默写卡
"""
单词默写表格生成小工具
读取包含了单词以及中文释义两列的 Excel 文件（也可以是 csv 文件）
然后按照 A4 纸大小排列可这翻折的单词默写表格形式
每页 48 个单词，每个单词都需要默写中文释义以及中文对应的单词
"""
import pandas as pd
import openpyxl
from openpyxl.styles import Alignment, Border, Side
from openpyxl.worksheet.page import PageMargins
@wgzhao
wgzhao / q1.markdown
Created June 20, 2024 01:25
高中数学

已知 $BC^2 + AC^2 = 5AB^2$, 求 $\frac{\tan C}{\tan A} + \frac{\tan C}{\tan B}$

解，因为 $BC^2 + AC^2 = 5AB^2$ 可得 $a^2 + b^2 = 5c^2$，由此可联想到余弦定理，因此

$$ \begin{flalign} \frac{\tan C}{\tan A} + \frac{\tan C}{\tan B} \

@wgzhao
wgzhao / k8s-event-seq-complicate.md
Last active March 20, 2023 11:32
diagram collections 
sequenceDiagram
    participant User
    participant ApiServer
    participant Etcd
    participant ControllerManager
    participant ReplicaSetController
    participant Scheduler
    participant Kubelet
    participant Docker
@wgzhao
wgzhao / mkdocs-release.yaml
Created October 29, 2021 05:55
MkDocs action setup
name: mkdoc-release
on:
push:
tags:
- '*'
jobs:
deploy:
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v2
@wgzhao
wgzhao / gpedit-enabler.bat
Created August 14, 2021 08:26
@echo off
pushd "%~dp0"
dir /b %SystemRoot%\servicing\Packages\Microsoft-Windows-GroupPolicy-ClientExtensions-Package~3*.mum >List.txt
dir /b %SystemRoot%\servicing\Packages\Microsoft-Windows-GroupPolicy-ClientTools-Package~3*.mum >>List.txt
@wgzhao
wgzhao / config_git_use_proxy.md
Created May 18, 2021 01:16
Configure Git to use a proxy

Configure Git to use a proxy

In Brief

You may need to configure a proxy server if you're having trouble cloning or fetching from a remote repository or getting an error like unable to access '...' Couldn't resolve host '...'.

Consider something like:

@wgzhao
wgzhao / hosts
Created January 27, 2021 01:31
222.211.64.122 se.itunes.apple.com
222.211.64.122 su.itunes.apple.com
222.211.64.122 upp.itunes.apple.com
222.211.64.122 play.itunes.apple.com
222.211.64.122 client-api.itunes.apple.com
# API-2-ChinaCache [ChinaNet] (Avg RTT: 15.339ms)
125.65.247.14 itunes.apple.com
125.65.247.14 init.itunes.apple.com
# API-HK-Akamai-1 [HongKong0] (Avg RTT: 52.706ms)
184.87.97.50 search.itunes.apple.com
@wgzhao
wgzhao / shadowrocket.conf
Last active April 30, 2025 18:04
shadowrocket configuration file
# Shadowrocket: 2020-12-13 10:10:56
[General]
bypass-system = true
skip-proxy = 192.168.0.0/16, 10.0.0.0/8, 172.16.0.0/12, localhost, *.local, e.crashlytics.com, captive.apple.com
bypass-tun = 10.0.0.0/8,100.64.0.0/10,127.0.0.0/8,169.254.0.0/16,172.16.0.0/12,192.0.0.0/24,192.0.2.0/24,192.88.99.0/24,192.168.0.0/16,198.18.0.0/15,198.51.100.0/24,203.0.113.0/24,224.0.0.0/4,255.255.255.255/32
#dns-server = 119.29.29.29,114.114.114.114,223.5.5.5,8.8.8.8
ipv6 = false
[Rule]
DOMAIN-SUFFIX,rfi.fr,PROXY
@wgzhao
wgzhao / extract_from_jks.sh
Created December 12, 2018 00:28
Extract private and public key from Java KeyStore file (JKS)
JKS=mykeystore
JKS_PASS=changeit
JKS_ALIAS=tomcat
OUTPASS=$(cat /dev/urandom |env LC_CTYPE=C tr -dc 'a-zA-Z0-9' | fold -w 8 |head -n1)
PK12_KEY=mykeystore.pk12
PEM=server.pem
KEY=server.key
keytool -importkeystore -srckeystore $JKS -destkeystore $PK12_KEY -srcstoretype JKS -deststoretype PKCS12 -srcstorepass $JKS_PASS -deststorepass $OUTPASS -srcalias $JKS_ALIAS -destalias $JKS_ALIAS -srckeypass $JKS_PASS -destkeypass $OUTPASS -noprompt
@wgzhao
wgzhao / xinfadi_sku_scrap.py
Created August 16, 2018 03:20
从北京新发地(xinfadi.com.cn) 获取每个类目中有典型代表的商品（SKU）的2018年历史价格，然后验证是否出于上涨趋势
from bs4 import BeautifulSoup as bs
import pandas as pd
import numpy as np
import requests
from urllib.parse import quote
"""
从北京新发地(xinfadi.com.cn) 获取每个类目中有典型代表的商品（SKU）的2018年历史价格，然后验证是否出于上涨趋势
"""
# 索引与品类的映射关系