This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import json | |
from pathlib import Path | |
def normalized(name): | |
return (name.replace("-", "_")).lower() | |
def prettyHex(num): | |
return str(hex(num)).replace("0x","") |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# From SQL to Python Pandas Cheatsheet | |
# many thanks to: https://medium.com/jbennetcodes/how-to-rewrite-your-sql-queries-in-pandas-and-more-149d341fc53e | |
# Using airports data example: https://ourairports.com/data/ | |
import pandas as pd | |
# Reset Pandas Index | |
df.reset_index(drop=True, inplace=True) | |
# Simply add a columns with an easy calculation |
OlderNewer