Skip to content

Instantly share code, notes, and snippets.

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

Stefan Thoss stefanthoss

🏠
Working from home
13 followers · 15 following
View GitHub Profile
@stefanthoss
stefanthoss / git_backup_script.sh
Created March 21, 2016 21:45
Shell script to automatically commit all new/modified/deleted files in a Git repository. Can be used as a backup tool with cron.
#!/bin/bash
cd /path/to/git/repo/
git add -A
git commit -m "Backup on `date`"
git push origin
@stefanthoss
stefanthoss / mysql-pandas-import.py
Last active December 26, 2023 19:48
Import data from a MySQL database table into a Pandas DataFrame using the pymysql package.
import pandas as pd
import pymysql
from sqlalchemy import create_engine
engine = create_engine("mysql+pymysql://USER:PASSWORD@HOST:PORT/DBNAME")
df = pd.read_sql_query("SELECT * FROM table", engine)
df.head()
@stefanthoss
stefanthoss / cik_dict.py
Last active December 2, 2019 16:01 — forked from dougvk/cik_dict.py
(stock ticker -> CIK) dictionary using SEC EDGAR using stdout
import re
import requests
DEFAULT_TICKERS = ["BBRY", "VOD", "T", "S"]
URL = "http://www.sec.gov/cgi-bin/browse-edgar?CIK={}&Find=Search&owner=exclude&action=getcompany"
CIK_RE = re.compile(r".*CIK=(\d{10}).*")
cik_dict = {}
for ticker in DEFAULT_TICKERS:
results = CIK_RE.findall(requests.get(URL.format(ticker)).content.decode("ascii"))