wwyqianqian’s gists

wwyqianqian / gist:017e2c490dc4ab8ef8f93d18e7d77a6b

Last active February 21, 2025 03:13

	Sub CreateStatisticWorksheet()
	Dim wsStatistic As Worksheet
	Dim wsExist As Worksheet
	Dim wb As Workbook
	Dim wbSource As Workbook
	Dim wsSource As Worksheet
	Dim wsWorksheet1 As Worksheet
	Dim rngBorder As Range
	Dim sourceFilePath As String
	Dim countA As Long, countB As Long, countC As Long

wwyqianqian / gist:c3c986ed0f909a38e670a5f1ee218a36

Created February 18, 2025 10:01

	import pandas as pd
	import re
	import matplotlib.pyplot as plt
	import numpy as np
	from datetime import datetime
	import matplotlib.dates as mdates

	# Read Excel file
	file_path = "Functional Mailbox_20250212.xlsx"
	df = pd.read_excel(file_path, sheet_name='Functional Email')

wwyqianqian / gist:4e69a130fd05ea7c2ed45d2b03241a82

Last active February 21, 2025 03:15

HKMA daily report

wwyqianqian / elf.h

Created March 12, 2021 04:43 — forked from mlafeldt/elf.h

elf.h for OSX

	/* This is the original elf.h file from the GNU C Library; I only removed
	the inclusion of feature.h, which is not needed.

	On OSX, simply copy the file to /usr/local/include/.

	Mathias Lafeldt <mathias.lafeldt@gmail.com> */

	/* This file defines standard ELF types, structures, and macros.
	Copyright (C) 1995-2003,2004,2005,2006,2007,2008,2009,2010,2011
	Free Software Foundation, Inc.

wwyqianqian / gist:c454d93eb24cbfe6ab5a4de429aeb539

Created May 20, 2020 01:32 — forked from tillson/gist:620e8ef87bc057f25b0a27c423433fda

Decode Base64 strings in a git repo's commit history

	from pydriller import RepositoryMining
	import re
	import base64

	foundSet = set()
	for commit in RepositoryMining('./').traverse_commits():
	for mod in commit.modifications:
	if mod.source_code_before != None:
	regex = re.findall(r"<text encoding=\"base64\">[^>]+</text>", mod.source_code_before)
	for result in regex:

wwyqianqian / namebase.py

Created February 22, 2020 09:39 — forked from jat001/namebase.py

Sell HNS automatically

	#!/usr/bin/env python3
	# -- coding: utf-8 --

	import sys
	from decimal import Decimal
	from datetime import datetime

	try:
	import requests
	import simplejson as json

wwyqianqian / spoc-downloader

Created June 2, 2019 06:53

云课堂批量下载+重命名文件

	http://spoc.ccnu.edu.cn:80/getFileStream/68e079ca5e2211e892a5000c2974f54a 2-9-11Ferrers图像、指数型母函数.pdf
	http://spoc.ccnu.edu.cn:80/getFileStream/67773cc15e2211e892a5000c2974f54a 2-14非线性递推关系举例.pdf
	http://spoc.ccnu.edu.cn:80/getFileStream/5dab8f8e5e2211e892a5000c2974f54a 2-7线性常系数非齐次递推、整数拆分 Stirling数_Mar21_2016.pdf
	http://spoc.ccnu.edu.cn:80/getFileStream/532418a25e2211e892a5000c2974f54a 2-5线性常系数非齐次递推、Stirling数.pdf
	http://spoc.ccnu.edu.cn:80/getFileStream/417d961c5e2211e892a5000c2974f54a 2-4线性常系数齐次递推.pdf
	http://spoc.ccnu.edu.cn:80/getFileStream/419ebfb045d211e892a5000c2974f54a 2-1递推关系举例、Fibonacci数列.pdf
	http://spoc.ccnu.edu.cn:80/getFileStream/41790bd045d211e892a5000c2974f54a 2-2Fibonacci数列若干等式母函数性质.pdf
	http://spoc.ccnu.edu.cn:80/getFileStream/7e78983b3c6911e892a5000c2974f54a 1-3组合解释、举例.pdf
	http://spoc.ccnu.edu.cn:80/getFileStream/5196635128fd11e8ac9f000c2974f54a 1-2排列组合生成、可重组合.pdf
	http://spoc.ccnu.edu.cn:80/getFileStream/5123ed4c28fd11e8ac9f000c2974f54a 1-1排列组合.pdf

wwyqianqian / huffman-coding-STL.cpp

Last active May 6, 2019 09:20

C++ STL huffman coding

	#include <bits/stdc++.h>
	using namespace std;


	struct MinHeapNode {
	char data;
	unsigned freq;
	MinHeapNode left, right;

	MinHeapNode(char data, unsigned freq) {

wwyqianqian / NLTK's list of english stopwords

Created December 19, 2018 12:19 — forked from sebleier/NLTK's list of english stopwords

千千w wwyqianqian