TIL

Today I Learned

Introduction: TIL

eval in Python is Dangerous

Published: 2019-08-13

Tags:

#Python

Summary: eval is powerful but really dangerous

Materialize the Query Result for Performance

Published: 2019-05-12

Tags:

#Data Warehouse #Big Query

Summary: Materialize the query result for multistage queries to make your query faster and lower the costs.

Get Current User in BigQuery

Published: 2019-05-12

Tags:

#Data Warehouse #Big Query

Summary: BigQuery Current User

Generate a Column of Continuous Dates in BigQuery

Published: 2019-05-12

Tags:

#Data Warehouse #Big Query

Summary: Generate a table with a column of continuous dates

Calculate Moving Average Using SQL/BigQquery

Published: 2019-05-12

Tags:

#Data Warehouse #Big Query #SQL

References: - Getting table metadata using INFORMATION_SCHEMA

Summary: Snippet for calculating moving avg using sql/biguqery

BigQuery Meta Tables

Published: 2019-05-12

Tags:

#Data Warehouse #Big Query

References: - Getting table metadata using INFORMATION_SCHEMA

Summary: Meta tables are very useful when it comes to get bigquery table information programmatically.

Auto-reload Python Packages or Python Modules in Jupyter Notebook

Published: 2019-05-12

Tags:

#Python #Jupyter

Summary: Python package or python module autoreloading in jupyter notebook

Add New Kernels to Jupyter Notebook in Conda Environment

Published: 2019-05-12

Tags:

#Python #Jupyter

Summary: Python package or python module autoreloading in jupyter notebook

Installing requirements.txt in Conda Environments

Published: 2019-03-13

Tags:

#Python #Anaconda

References: - Use 'pip install' in the virtual environment created by conda - Managing environments — conda documentation.

Summary: Why is pip install -r requirements.txt not working in conda?

Add Data Files to Python Package

Published: 2019-03-13

Tags:

#Python

References: - Including non-Python files with setup.py

Summary: Add Data Files to Python Package using manifest.in and setup.py

Flatten 2D List in Python

Published: 2019-01-23

Tags:

#Python

References: - How to make a flat list out of list of lists

Summary: Flatten 2D list using sum

VSCode on Mac Long Press Keys Not Repeating

Published: 2018-12-31

Tags:

#VSCode #IDE #Programming

References: - jjcm. How do I press and hold a key and have it repeat in VSCode? In: Stack Overflow [Internet]. [cited 28 Mar 2022]. Available: https://stackoverflow.com/questions/39972335/how-do-i-press-and-hold-a-key-and-have-it-repeat-in-vscode

Summary: Enable your key repeat in vscode on mac in the terminal

Python Reliable Path to File

Published: 2018-12-31

Tags:

#Python

References: - How to reliably open a file in the same directory as a Python script @ StackOverflow - Miscellaneous operating system interfaces @ The Python Standard Library - os.path — Common pathname manipulations

Summary: Find the actual path to file

Python Long String

Published: 2018-12-31

Tags:

#Python

Summary: Python long string formatting

Python If on Numbers

Published: 2018-12-31

Tags:

#Python

Summary: If on int is dangerous

Python Datetime on Different OS

Published: 2018-12-31

Tags:

#Python

Summary: Python datetime on different os behaves inconsistently

Controlled Experiments

Published: 2018-12-04

Tags:

#Statistics #Science

Summary: The three levels of controlled experiments

Pandas with MultiProcessing

Published: 2018-09-09

Tags:

#Python #Pandas

Summary: Adding new data to dataframe using multiprocessing

Fitt's Law

Published: 2018-07-22

Tags:

#Visual

Summary: How fast can you move your mouse to target

Copy Scalars and Lists in Python

Published: 2018-07-03

Tags:

#Python

Summary: Python copy values of scalars but addresses of lists