Python Archives • datagy

How to Normalize NumPy Arrays Cover Image

How to Normalize NumPy Arrays (Min-Max Scaling, Z-Score, L2)

Pandas GroupBy Multiple Columns Explained with Examples

The Pandas groupby method is a powerful tool that allows you to aggregate data using a simple syntax, while abstracting away complex calculations. One of the strongest benefits of the groupby method is the ability to group by multiple columns, and even apply multiple transformations. By the end of this tutorial, you’ll have learned the

Pandas GroupBy Multiple Columns Explained with Examples Read More »

Pandas How to Drop a Dataframe Index Column Cover Image

Pandas Drop a Dataframe Index Column: Guide with Examples

4 Comments / Pandas DataFrames, Pandas Tutorials / Nik

Learn how to use Pandas to drop a dataframe index column using the reset_index and set_index methods and how to read csv without an index.

Pandas Drop a Dataframe Index Column: Guide with Examples Read More »

Pandas Quantile: Calculate Percentiles of a Dataframe

1 Comment / Data Analysis in Pandas, Pandas Tutorials / Nik

Learn how to use the Pandas quantile method to calculate percentiles in Pandas including how to modify the interpolation of values.

Pandas Quantile: Calculate Percentiles of a Dataframe Read More »

Python strptime A Guide to Converting Strings to DateTime Cover Image

Python strptime: Converting Strings to DateTime

6 Comments / Python DateTime, Python Posts, Time Series in Pandas / Nik

Learn how to convert a Python string to date using the datetime module’s strptime function. Also learn how to do this to a Pandas dataframe!

Python strptime: Converting Strings to DateTime Read More »

Python strip: How to Trim a String in Python

2 Comments / Python Posts, Python Strings / Nik

In this tutorial, we’ll dive into the world of Python string trimming! String trimming is an essential skill that helps you clean up and refine your text data, making it more accurate and easier to work with. For example, being able to remove certain characters from a string in Python is an important pre-processing step

Python strip: How to Trim a String in Python Read More »

How to Calculate a Rolling Average (Mean) in Pandas

Leave a Comment / Data Analysis in Pandas, Pandas Tutorials / Nik

In this post, you’ll learn how to calculate a rolling mean in Pandas using the rolling() function. Rolling averages are also known as moving averages. Creating a rolling average allows you to “smooth” out small fluctuations in datasets, while gaining insight into trends. It’s often used in macroeconomics, such as unemployment, gross domestic product, and stock prices.A moving

How to Calculate a Rolling Average (Mean) in Pandas Read More »

Pandas unique(): Get Unique Values in a DataFrame

1 Comment / Grouping Data in Pandas, Pandas Tutorials / Nik

Pandas provides a lot of different ways to interact with unique values. Learn how to get unique values as a list, get unique values across columns and more!

Pandas unique(): Get Unique Values in a DataFrame Read More »

Unpivot Your Data with the Pandas Melt Function

1 Comment / Pandas DataFrames, Pandas Tutorials / Nik

You can easily unpivot and reshape data you with python by using Pandas and the Melt function! Find out how using this thorough overview!

Unpivot Your Data with the Pandas Melt Function Read More »

Creating Date Ranges with Pandas Cover Image

Pandas date_range: How to Create a Date Range in Pandas

3 Comments / Pandas Tutorials, Time Series in Pandas / Nik

In this tutorial, we’re diving deep into one of the essential and versatile tools of the Pandas library—the date_range function. Whether you’re a beginner just starting to explore the power of Pandas or already an adept user, this function is one you’ll definitely want to have in your Python toolbox. This will open up your

Pandas date_range: How to Create a Date Range in Pandas Read More »