Python Tips/Tricks/Bookmarks

Force Python to use/import specific version of a package. Source - https://stackoverflow.com/questions/6445167/force-python-to-use-an-older-version-of-module-than-what-i-have-installed-now [Read More]

SQL Tips/Tricks

Get Cumulative Sum for each day. Source - https://stackoverflow.com/questions/31734599/sum-of-all-rows-prior-to-and-including-date-on-current-row-in-mysql Make sure t1 has single row for each date and or date/customer group combination. [Read More]

Python EDA Utilities

Automatic Exploratory Data Analysis (EDA) using pandas-profiling package. Warnings Tab is especially useful to spot data quality issues and remove unusable and strongly correlated features. ```python #!pip install pandas_profiling from pandas_profiling import ProfileReport [Read More]