if it compiles it ships

jxu

if it compiles it ships

We do these things not because they are easy, but because we thought they were going to be easy.

jxu / pandas_cheatsheet.py

Last active November 26, 2024 19:57

Pandas Cheatsheet (Avoid indexes)

	import pandas as pd

	### Data import ###

	# https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.to_csv.html
	df = pd.read_csv("file.csv")


	### Data types ###

jxu / SQL_cheatsheet.sql

Last active May 2, 2024 23:20

Specifically for T-SQL, probably for other SQLs

	-- Syntax order
	-- https://learn.microsoft.com/en-us/sql/t-sql/queries/select-transact-sql

	WITH cte AS (cte_query)
	SELECT cols
	FROM table
	WHERE cond
	GROUP BY col
	HAVING cond
	WINDOW window_expr

jxu / git-cheatsheet.sh

Last active December 4, 2024 18:56

Useful git commands

	# push to new github repo
	git remote add origin git@github.com:jxu/repo.git # use set-url if already set
	git push -u origin master

	# check out a remote branch
	git fetch
	git branch -v -a # list all branches
	git switch branchname

	# change remote a branch is tracking

jxu / .vimrc

Created February 4, 2024 05:13

vimrc (again)

	" Custom vim config with my comments
	" (mostly from the ultimate Vim config amix/vimrc)

	" => General
	set nocompatible " Disable compatibility mode
	set history=1000 " Save more commands
	set autoread " Read file when changed externally
	set autowrite " Autosave before commands like :make
	set noswapfile " No more .swp!

jxu / element_symbols.txt

Last active May 18, 2024 02:43

jxu / android-transfer.py

Last active November 11, 2023 00:18

android-transfer repo old 2017-11-26

	#!/bin/env python3
	# Trying to automate android backups but fed up with bash :(

	# TODO: Nicer mode selection?

	import os
	import subprocess
	import sys

	SD_DIR = "sdcard1"

jxu / git_author_rewrite.sh

Last active January 14, 2026 04:31

	# https://help.github.com/articles/changing-author-info/

	git filter-branch --env-filter '
	OLD_EMAIL="wxv@users.noreply.github.com"
	CORRECT_NAME="jxu"
	CORRECT_EMAIL="7989982+jxu@users.noreply.github.com"
	if [ "$GIT_COMMITTER_EMAIL" = "$OLD_EMAIL" ]
	then
	export GIT_COMMITTER_NAME="$CORRECT_NAME"
	export GIT_COMMITTER_EMAIL="$CORRECT_EMAIL"

jxu / download_panopto.sh

Last active August 17, 2022 05:27

Download panopto videos from podcast file (from https://github.com/jstrieb/panopto-download/issues/3)

	# requires xq with --raw output support (https://github.com/boyska/xq fork)
	xq -r '//item/enclosure/@url' Podcast.ashx \| wget -i -

jxu / control.lua

Last active January 8, 2023 23:53 — forked from Bilka2/control.lua

Create a timelapse from a factorio replay save file

	-- Just add this to the end of the control.lua file in the save file and then replay the file

	script.on_nth_tick(1800, function(event)
	game.take_screenshot{
	surface = game.surfaces[1],
	position = {0,0},
	resolution = {3840,2160},
	zoom = 0.2,
	path = "timelapse/" .. string.format("%06d", event.tick/event.nth_tick) .. ".jpg",
	quality = 95,

jxu / ublacklist.txt

Created July 8, 2020 19:53

C/C++ google search blocklist of low quality sites, for use with uBlacklist