Posts by Category

SQL

Querying the Latest Record

less than 1 minute read

Published:

In this gist, I show how to get the latest record or a user based on a datetime column.

counterexample

A Digression on the Cantor Set

2 minute read

Published:

The Cantor set is a special type of set in mathematics. In this blog post, I will use it as an illustration of how my mind works, when I learning a new topic.

cumulative sum

Cumulative Sum with Pandas

less than 1 minute read

Published:

In this gist, I calculate the cumulative sum of the column no, based on the columns nameand day.

datetime

Datetime Resample

less than 1 minute read

Published:

In this gist, I calculate aggregate the datetime column according to different periods (e.g. day, week, and month)

digression

A Digression on the Cantor Set

2 minute read

Published:

The Cantor set is a special type of set in mathematics. In this blog post, I will use it as an illustration of how my mind works, when I learning a new topic.

gist

Pandas Value Counts

less than 1 minute read

Published:

The value_counts() function in the popular python data science library Pandas is a quick way to count the unique values in a single column otherwise known as a series of data.

Querying the Latest Record

less than 1 minute read

Published:

In this gist, I show how to get the latest record or a user based on a datetime column.

Jupyter Notebook Header

less than 1 minute read

Published:

This gist contains my default settings for a Jupyter notebook as a header.

Datetime Resample

less than 1 minute read

Published:

In this gist, I calculate aggregate the datetime column according to different periods (e.g. day, week, and month)

Cumulative Sum with Pandas

less than 1 minute read

Published:

In this gist, I calculate the cumulative sum of the column no, based on the columns nameand day.

Jupyter Notebook Header

less than 1 minute read

Published:

This gist contains my default settings for a Jupyter notebook as a header.

join

Querying the Latest Record

less than 1 minute read

Published:

In this gist, I show how to get the latest record or a user based on a datetime column.

mathematics

A Digression on the Cantor Set

2 minute read

Published:

The Cantor set is a special type of set in mathematics. In this blog post, I will use it as an illustration of how my mind works, when I learning a new topic.

matploblib

notebook

Jupyter Notebook Header

less than 1 minute read

Published:

This gist contains my default settings for a Jupyter notebook as a header.

optimization

pandas

Pandas Value Counts

less than 1 minute read

Published:

The value_counts() function in the popular python data science library Pandas is a quick way to count the unique values in a single column otherwise known as a series of data.

Datetime Resample

less than 1 minute read

Published:

In this gist, I calculate aggregate the datetime column according to different periods (e.g. day, week, and month)

Cumulative Sum with Pandas

less than 1 minute read

Published:

In this gist, I calculate the cumulative sum of the column no, based on the columns nameand day.

python

Pandas Value Counts

less than 1 minute read

Published:

The value_counts() function in the popular python data science library Pandas is a quick way to count the unique values in a single column otherwise known as a series of data.

Jupyter Notebook Header

less than 1 minute read

Published:

This gist contains my default settings for a Jupyter notebook as a header.

Datetime Resample

less than 1 minute read

Published:

In this gist, I calculate aggregate the datetime column according to different periods (e.g. day, week, and month)

Cumulative Sum with Pandas

less than 1 minute read

Published:

In this gist, I calculate the cumulative sum of the column no, based on the columns nameand day.

resample

Datetime Resample

less than 1 minute read

Published:

In this gist, I calculate aggregate the datetime column according to different periods (e.g. day, week, and month)