jxu

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

grep -Pi '^(?=.*u)[bluntam]{4,}$' /usr/share/dict/words

jxu

-- 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

# 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 

# Throw away all changes, staged and unstaged

jxu

" 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

Ac
Accra
Achebe
Achernar
Acheson
Acosta
Acts
Acuff
Ag
Agassi

jxu

#!/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

alias yt-audio='yt-dlp -x --audio-format mp3'

jxu

rsync -av --progress --inplace --omit-dir-times --no-perms --delete-after --exclude='.git/' music-player/ '/run/user/1000/gvfs/mtp:host=Google_Pixel_4a_0A101JEC213910/Internal shared storage/Music/'

jxu

import sqlite3
import json
import os

DATA_DIR = "data"

def main():
    conn = sqlite3.connect("danbooru2018.db")
    c = conn.cursor()