Pandas

Pandas

Pandas is a powerful Python library for data manipulation and analysis, providing data structures like DataFrames that simplify handling and analyzing structured data for various applications, from data cleaning to complex data analysis. Here, you will find hands-on tutorials, example projects and best practices for using Pandas.

23 posts
Pandas - Change Column Types of a DataFrame

Pandas - Change Column Types of a DataFrame

Introduction Data manipulation tasks often involve converting column data types to ensure consistency and accuracy in analysis. In this tutorial, we will show you how to change column types of a Pandas DataFrame. In order to do this, we will use the astype() method, the map() method and the to_...

Pandas - Add an ID Column to a DataFrame

Pandas - Add an ID Column to a DataFrame

Introduction One common task when working with large datasets is the need to generate unique identifiers for each record. In this tutorial, we will explore how to easily add an ID column to a Pandas DataFrame. In order to do this, we use the index attribute of a Pandas DataFrame....

Pandas - Write DataFrame to Excel File

Pandas - Write DataFrame to Excel File

Introduction In this tutorial, we want to write a Pandas DataFrame to an Excel file. In order to do this, we use the to_excel() method of Pandas. Import Libraries First, we import the following python modules: import pandas as pd Create Pandas DataFrame Next, we create a Pandas DataFrame...

Pandas - Read Excel File into DataFrame

Pandas - Read Excel File into DataFrame

Introduction In this tutorial, we want to read an Excel file into a Pandas DataFrame. In order to do this, we use the read_excel() function of Pandas. Import Libraries First, we import the following python modules: import pandas as pd Excel File We consider the sheet "Frameworks"...

Pandas - Write DataFrame to CSV File

Pandas - Write DataFrame to CSV File

Introduction In this tutorial, we want to write a Pandas DataFrame to a CSV file. In order to do this, we use the to_csv() method of Pandas. Import Libraries First, we import the following python modules: import pandas as pd Create Pandas DataFrame Next, we create a Pandas DataFrame...

Pandas - Read CSV File into DataFrame

Pandas - Read CSV File into DataFrame

Introduction In this tutorial, we want to read a CSV file into a Pandas DataFrame. In order to do this, we use the read_csv() function of Pandas. Import Libraries First, we import the following python modules: import pandas as pd CSV File We consider the CSV file "frameworks....

Pandas - Ordinal Encoding

Pandas - Ordinal Encoding

Introduction In this tutorial, we want to encode ordinal categorical variables of a Pandas DataFrame. In order to do this, we use the replace() method of Pandas. Import Libraries First, we import the following python modules: import pandas as pd Create Pandas DataFrame Next, we create a Pandas DataFrame with...

Pandas - One-Hot Encoding

Pandas - One-Hot Encoding

Introduction In this tutorial, we want to one-hot encode a categorical variable of a Pandas DataFrame. In order to do this, we use the get_dummies() function of Pandas. Import Libraries First, we import the following python modules: import pandas as pd Create Pandas DataFrame Next, we create a Pandas...

You’ve successfully subscribed to Deep Learning Nerds | The ultimate Learning Platform for AI and Data Science
Welcome back! You’ve successfully signed in.
Great! You’ve successfully signed up.
Success! Your email is updated.
Your link has expired
Success! Check your email for magic link to sign-in.