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: Programming
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 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) …
Python script for geocoding a text file
Assume that you have a file with some locations as text with one location per line. For example, here are some school names in Copenhagen, …
Easy parallel HTTP requests with Python and asyncio
Python 3.x, and in particular Python 3.5, natively supports asynchronous programming. While asynchronous code can be harder to read than synchronous code, there are many …
How to compute the pagerank of almost anything
Whenever two things have a directional relationship to each other, then you can compute the pagerank of those things. For example, you can observe a …
Quick introduction to RabbitMQ and Celery
I like to code in Python. I also like the concept of asynchronous workers to build loosely coupled applications. Luckily, RabbitMQ and Celery can help …
How to export CSV file to database with Python
Pandas and SQLAlchemy offer powerful conversions between CSV files and tables in databases. Here is a small example: import pandas as pd from sqlalchemy import …
How to use non-default profile in boto3
Given an AWS credentials file that looks like this: [default] aws_access_key_id = DEFAULT aws_secret_access_key = SECRET1 [dev] aws_access_key_id = DEV aws_secret_access_key = SECRET2 …