In this lesson, we are going to take a look at the Pandas Melt function. This is a way to transform a dataframe to convert columns to rows. Later in this lesson, we will take a look at some of the benefits of using melt with a groupby and plotting. This lesson is based on […]
Box Cox Transformation Time Series
By utilizing a Box-Cox transformation on your time series data, you can help stabilize the variance, which is an important step in making data stationary. Once you apply the transformation you should also consider differencing which will be covered in this lesson. Pre Box-Cox Transform Post Box-Cox Transform One limitation to using the Box-Cox transformation […]
Pandas Query
By using query, you can simply filter down a dataframe in a more readable format. In this lesson we will go over how to use this with numbers, strings, variables, and more. If you want to watch a YouTube video, the one this lesson is based on is down below. Let’s start by importing in […]
Pandas Shift
The pandas.shift() function is a powerful and versatile tool in data analysis with Python. It allows you to shift the values of a DataFrame or Series up or down along an axis, making it especially useful for comparing a row or column to its previous or future counterpart. This functionality is commonly applied in time […]
Python Pandas Explode
Using explode within Python Pnadas allows you to transform each element of a list to a new row within a dataframe. Python Pandas Explode YouTube Video If you want a video demonstration of how the code works, checkout the video below on our YouTube channel. When working with Python Pandas the first step is to […]