Skip to content

Instantly share code, notes, and snippets.

@jnyjxn
jnyjxn / dynamicfunwithargs.py
Last active April 21, 2024 10:48
Extending our dynamic function use with custom arguments
def add(x, to=1):
return x + to
def divide(x, by=2):
return x/by
def square(x):
return x**2
def invalid_op(x):
@abduhbm
abduhbm / at_to_df.py
Created April 10, 2019 14:57
Retrieve a table from Airtable to Pandas DataFrame
import requests
import pandas as pd
BASE_URL = 'https://api.airtable.com/v0/'
def airtable_to_dataframe(base_name, table_name, api_key):
header = {'Authorization': 'Bearer ' + api_key}
data = []
r = requests.get(BASE_URL + base_name + '/' + table_name, headers=header)
@mdriesch
mdriesch / fifo_bond_accounting.py
Last active November 3, 2025 12:16
Python Class for LiFo, FiFo and AVCO Accounting of bonds
"""
Copyright (C) 2017 Michael von den Driesch
This file is just a simple implementation of a python class allowing for various
*booking* types (LIFO, FIFO, AVCO)
This *GIST* is free software: you can redistribute it and/or modify it
under the terms of the BSD-2-Clause (https://opensource.org/licenses/bsd-license.html).
This program is distributed in the hope that it will be useful, but WITHOUT
@sean-smith
sean-smith / ec2_ipython.md
Last active February 15, 2021 23:09
iPython using EC2 and LetsEncrypt

Setup an iPython Notebook on AWS with LetsEncrypt Certificate

The first step is to setup an EC2 Ubuntu 16.04 instance that you can ssh into. I won't go into detail here but you should be able to easily google it.

You can get free AWS credit here https://education.github.com/pack

A better guide w/ pictures is here: https://chrisalbon.com/jupyter/run_project_jupyter_on_amazon_ec2.html (Note this doesn't include LetsEncrypt, so it only has self signed certificates)

Once you've setup an instance and ssh'd in, do the following:

@nicobrx
nicobrx / to_util
Last active October 28, 2024 19:23
Google Apps Script utility functions for working with 2D arrays in Sheets/tabs, plus a few other miscellanea. The 2D functions depend on the first row of a tab being column headers and each row below the first row having the same number of columns as the first row.
/*
updated 2018-04-28
source lives here: https://gist.github.com/nicobrx/2ecd6fc9ca733dcd883afebba5cf200e
standalone script ID for use as a library: 1gZ78JObyrYiH0njoZ86fQ2NgMwavUgiXVhRDrIFetPZL256e31PSNiHq
Functions included here:
Sheets data array and object functions
objectifySheet(sheet,propertyNames,newPropertyNames) - Takes a sheet with a header row and converts it into an array of objects
arrayFromSheet(sheet,propertyNames,newPropertyNames) - creates an array from a sheet, can specify column headers
@tasdikrahman
tasdikrahman / python_tests_dir_structure.md
Last active February 10, 2025 22:15
Typical Directory structure for python tests

A Typical directory structure for running tests using unittest

Ref : stackoverflow

The best solution in my opinion is to use the unittest [command line interface][1] which will add the directory to the sys.path so you don't have to (done in the TestLoader class).

For example for a directory structure like this:

new_project

├── antigravity.py

@chris1610
chris1610 / pdf-report.py
Created February 16, 2015 22:29
PDF Report Generation - pbpython.com
"""
Generate PDF reports from data included in several Pandas DataFrames
From pbpython.com
"""
from __future__ import print_function
import pandas as pd
import numpy as np
import argparse
from jinja2 import Environment, FileSystemLoader
from weasyprint import HTML
@jiffyclub
jiffyclub / assert_frames_equal.ipynb
Last active October 27, 2020 17:02
Example of a function to compare two DataFrames independent of row/column ordering and with handling of null values.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@ColinDuquesnoy
ColinDuquesnoy / html_logger.py
Last active November 18, 2024 05:15
HTML logger for python (inspired by the Horde3D logger)
"""
HTML logger inspired by the Horde3D logger.
Usage:
- call setup and specify the filename, title, version and level
- call dbg, info, warn or err to log messages.
"""
import logging
import time
@why-not
why-not / gist:4582705
Last active October 2, 2025 03:23
Pandas recipe. I find pandas indexing counter intuitive, perhaps my intuitions were shaped by many years in the imperative world. I am collecting some recipes to do things quickly in pandas & to jog my memory.
"""making a dataframe"""
df = pd.DataFrame([[1, 2], [3, 4]], columns=list('AB'))
"""quick way to create an interesting data frame to try things out"""
df = pd.DataFrame(np.random.randn(5, 4), columns=['a', 'b', 'c', 'd'])
"""convert a dictionary into a DataFrame"""
"""make the keys into columns"""
df = pd.DataFrame(dic, index=[0])