How to fill missing dates in Pandas
by Create a pandas dataframe with a date column: import pandas as pd import datetime TODAY = datetime.date.today() ONE_WEEK = datetime.timedelta(days=7) ONE_DAY = datetime.timedelta(days=1) …
Category: Analytics
Cosine similarity in Python
Cosine similarity is the normalised dot product between two vectors. I guess it is called “cosine” similarity because the dot product is the product of …
How to explore two-dimensional data with a heatmap
https://seaborn.pydata.org/generated/seaborn.heatmap.html
How to display a Choropleth map in Jupyter Notebook
Here is the code: %matplotlib inline import geopandas as gpd import matplotlib as mpl # make rcParams available (optional) mpl.rcParams[’figure.dpi’]= 144 # increase dpi (optional) …
(Integer) Linear Programming in Python
Step one: brew install glpk pip install pulpbrew install glpk pip install pulp Step two: from pulp import * prob = LpProblem("test1", LpMinimize) …
How to select top-k items from each group in SQL
Here is an analytical query that you (and I) will often need to do if you work in e-commerce, marketing or similar domain. It answers …