Out sick

Chenny Du duchenpaul

Out sick

手持两把锟斤拷，口中疾呼烫烫烫。脚踏千朵屯屯屯，笑看万物锘锘锘。

duchenpaul / en.json

Last active October 13, 2025 08:41

Resume - EN

	{
	"meta": {
	"theme": "kendall"
	},
	"basics": {
	"name": "Chen Du (杜琛)",
	"label": "Cloud Dev",
	"image": "https://gravatar.com/userimage/252197455/05d270125e2ee728cc21842d872b8274.jpeg?size=512",
	"email": "[email protected]",
	"phone": "18963609586",

duchenpaul / cn.json

Last active October 13, 2025 08:41

Resume - CN

	{
	"meta": {
	"theme": "kendall"
	},
	"basics": {
	"name": "Chen Du (杜琛)",
	"label": "Cloud Ops Engineer",
	"image": "https://gravatar.com/userimage/252197455/05d270125e2ee728cc21842d872b8274.jpeg?size=512",
	"email": "[email protected]",
	"phone": "18963609586",

duchenpaul / df_to_fwf.py

Created September 25, 2020 02:20

Convert dataframe to fwf

	import pandas as pd
	import pickle
	import numpy as np
	from tabulate import tabulate


	left_align_gen = lambda length, value: eval(r"'{:<<<length>>}'.format('''<<value>>'''[0:<<length>>])".replace('<<length>>', str(length)).replace('<<value>>', str(value)))
	right_align_gen = lambda length, value: eval(r"'{:><<length>>}'.format('''<<value>>'''[0:<<length>>])".replace('<<length>>', str(length)).replace('<<value>>', str(value)))

	# df = pd.read_pickle("dummy.pkl")

duchenpaul / chunks.py

Last active July 4, 2020 08:23

Split list into pieces evenly

	def chunks(l, n):
	n = max(1, n)
	result = [l[i:i+n] for i in range(0, len(l), n)]
	if len(result) * n > len(l):
	last = result.pop(-1)
	result[-1] += last
	return result

	lenf = 205
	div = 4

duchenpaul / date_validation.py

Created March 6, 2020 12:26

validate date in a file

	from datetime import datetime

	with open('test.txt') as f:
	date_list = f.read().split('\n')

	date_list = [ x.replace('"', '').strip() for x in date_list if x]

	for x in date_list:
	try:
	datetime.strptime(x, '%m/%d/%Y')

duchenpaul / table_transfer.py

Created February 22, 2020 14:17

Transfer data between databases using pandas dataframe

	from tqdm import tqdm

	import pandas as pd
	from sqlalchemy import create_engine, MetaData

	SOURCE_TABLE_NAME_LIST = ['individual_tagging_sd', ]


	def chunker(seq, size):
	return (seq[pos:pos + size] for pos in range(0, len(seq), size))

duchenpaul / shrink_img.sh

Last active November 1, 2019 15:29

Shrink the size of raspberry pi image.

	#!/bin/bash

	if [ $# -lt 1 ]; then
	echo -e "Shrink the size of raspberry pi image.\nUsage: bash $0 xxx.img "
	ls -l *.img
	exit
	fi

	IMG=$1

duchenpaul / file_split.py

Created April 2, 2019 07:29

Split csv into X line, with or without header

	import os


	def split(filehandler, delimiter=',', row_limit=1000,
	output_name_template='output_%s.csv', output_path='.', keep_headers=True):
	import csv
	reader = csv.reader(filehandler, delimiter=delimiter)
	current_piece = 1
	current_out_path = os.path.join(
	output_path,

duchenpaul / nwqs_data_extract.py

Created February 11, 2019 04:26

Extract data from nwqs

	import json
	import sqlparse
	import xmltodict

	from pprint import pprint

	def xml2dict(xmlString):
	'''Return json object'''
	jsonString = json.dumps(xmltodict.parse(xmlString), indent=4)
	xml_in_dict = json.loads(jsonString)

duchenpaul / robot_click.py

Created January 6, 2019 14:08

A very simple program which clicks back forward