How To Define DataFrame In Python

In this tutorial, we will learn how to define a DataFrame (Df) in Python using the popular data manipulation library pandas. DataFrames are two-dimensional, mutable, and potentially heterogenous tabular data structures with labeled axes (rows and columns), making them an ideal tool for data manipulation tasks, such as data cleaning, transformation, and analysis.

Step 1: Install Pandas

First, we need to install the pandas library if not already installed. Open your terminal or command prompt and run the following command:

1
pip install pandas

Step 2: Import Pandas

Next, let’s import the pandas library into our Python script using the following line of code:

1
import pandas as pd

Here, we’re importing pandas with an alias pd, which is a common convention when working with pandas.

Step 3: Create Data to Define a DataFrame

To define a DataFrame, we first need some data. We can create this data in various formats, such as lists, dictionaries, or external sources like CSV files. In this tutorial, we will use a dictionary to create our data.

1
2
3
4
5
data = {
    'Name': ['John', 'Michael', 'Tom', 'Anna'],
    'Age': [25, 30, 27, 22],
    'Country': ['USA', 'Canada', 'UK', 'Australia']
}

Here, we have a dictionary with three keys: ‘Name’, ‘Age’, and ‘Country’. The corresponding values are lists containing data for each column.

Step 4: Create a DataFrame

Now that we have our data, let’s define a DataFrame using pandas. We will use the pd.DataFrame() function and pass our data dictionary as an argument.

1
df = pd.DataFrame(data)

Our DataFrame is now created with the given data.

Step 5: Display the DataFrame

Finally, let’s display our DataFrame using the print() function.

1
print(df)
 
   Name  Age    Country
0  John   25        USA
1  Michael 30      Canada
2  Tom    27        UK
3  Anna   22     Australia

As you can see, the DataFrame is displayed with labeled column names and indexed rows.

Complete Code

1
2
3
4
5
6
7
8
9
10
11
import pandas as pd
 
data = {
    'Name': ['John', 'Michael', 'Tom', 'Anna'],
    'Age': [25, 30, 27, 22],
    'Country': ['USA', 'Canada', 'UK', 'Australia']
}
 
df = pd.DataFrame(data)
 
print(df)

Conclusion

In this tutorial, we learned how to define a DataFrame in Python using the pandas library. DataFrames are powerful tools for handling and analyzing structured data, and mastering them is essential for any data manipulation or analysis tasks in Python.

Keep exploring the pandas library to unlock more functionalities and make your data manipulation tasks more efficient!