Skip to content

Instantly share code, notes, and snippets.

View Foxtrod89's full-sized avatar
🏠
Working from home

Alex Zubkov Foxtrod89

🏠
Working from home
View GitHub Profile
@camsaul
camsaul / make_db_ssh_tunnel.sh
Created September 24, 2014 20:16
Make a SSH Tunnel to a Postgres DB hosted in Vagrant VM
#! /bin/bash
ssh -L 5555:localhost:5432 vagrant@localhost -p 2222 -i ~/.vagrant.d/insecure_private_key -fNg # local port 5555 <-> Vagrant port 5432
@bsweger
bsweger / useful_pandas_snippets.md
Last active June 14, 2025 19:01
Useful Pandas Snippets

Useful Pandas Snippets

A personal diary of DataFrame munging over the years.

Data Types and Conversion

Convert Series datatype to numeric (will error if column has non-numeric values)
(h/t @makmanalp)

@seuros
seuros / sample.ovpn
Created March 20, 2014 19:25
Sample OpenVPN client config
client
dev tun
proto tcp
remote 192.168.1.1 1194
resolv-retry infinite
nobind
persist-key
persist-tun
ca [inline]
cert [inline]
@wandernauta
wandernauta / sp
Last active June 3, 2025 10:02
sp is a command-line client for Spotify's dbus interface. Play, pause, skip and search tracks from the comfort of your command line.
#!/usr/bin/env bash
#
# This is sp, the command-line Spotify controller. It talks to a running
# instance of the Spotify Linux client over dbus, providing an interface not
# unlike mpc.
#
# Put differently, it allows you to control Spotify without leaving the comfort
# of your command line, and without a custom client or Premium subscription.
#
@tristanwietsma
tristanwietsma / mercsettles.py
Created April 30, 2013 02:15
CME settlement price fetcher Ugly, but effective, script for getting CME settlement prices off their FTP side. Could use a clean up...
import sys, string, urllib
GROUPS = dict([('ags','ftp://ftp.cmegroup.com/pub/settle/stlags'),
('rates','ftp://ftp.cmegroup.com/pub/settle/stlint'),
('fx','ftp://ftp.cmegroup.com/pub/settle/stlcur'),
('nymex','ftp://ftp.cmegroup.com/pub/settle/stlnymex'),
('comex','ftp://ftp.cmegroup.com/settle/stlcomex'),
('clearport','ftp://ftp.cmegroup.com/settle/stlcpc')])
# month codes
@pklaus
pklaus / ddns.py
Last active November 10, 2024 02:57
A script to update the A and AAAA RRs of HOSTNAME on a DNS server according to your current external IP address using nsupdate / TSIG. This script is tested to run on Mac OS X (10.8-10.9) but you should be able to get it up and running in almost no time on any Unix or Linux system that ships nsupdate. I use this script to update my own DDNS serv…
#!/usr/bin/env python
# -*- coding: utf-8 -*-
"""
Written on 2013-02-04 by Philipp Klaus <philipp.l.klaus →AT→ web.de>.
Check <https://gist.github.com/4707775> for newer versions.
Uses dnspython: install with `pip install dnspython3`
"""