How To Convert Object To Dataframe In Python

In this tutorial, you will learn how to convert an Object to a Dataframe in Python using the popular library, pandas. This is a very common task for anyone working with Data Science or Data Analysis related projects, as it allows to transform the raw data into useful information presented in a structured way.

Before getting started, make sure you have pandas installed on your system. If you don’t have it yet, install it using pip:

1
pip install pandas

Step 1: Import the pandas library

First, let’s import the pandas library using the usual alias pd:

1
import pandas as pd

Step 2: Create a sample object

To demonstrate the conversion from Object to Dataframe, let’s create a simple Dictionary called data with keys as column names and values as lists of data.

1
2
3
data = {'Brand': ['Honda', 'Toyota', 'Ford', 'Tesla'],
        'Model': ['Civic', 'Camry', 'Mustang', 'Model X'],
        'Price': [22000, 25000, 26000, 70000]}

Now that we have our sample data, we can proceed with the conversion.

Step 3: Convert the Dictionary to a Dataframe

To convert the Dictionary into a pandas Dataframe object, we’ll use the pd.DataFrame() method, passing the Dictionary object as an argument:

1
df = pd.DataFrame(data)

The pd.DataFrame() method returns a new Dataframe object containing the data provided.

Step 4: Display the Dataframe

Now that we have our Dataframe, let’s display its content using the print() function:

1
print(df)

Here’s the output:

     Brand    Model  Price
0   Honda    Civic  22000
1  Toyota    Camry  25000
2    Ford  Mustang  26000
3   Tesla  Model X  70000

We can see that the Dictionary has been successfully converted into a Dataframe, with columns created based on the keys, and rows created based on the length of the arrays provided.

Full code

1
2
3
4
5
6
7
8
9
import pandas as pd
 
data = {'Brand': ['Honda', 'Toyota', 'Ford', 'Tesla'],
        'Model': ['Civic', 'Camry', 'Mustang', 'Model X'],
        'Price': [22000, 25000, 26000, 70000]}
 
df = pd.DataFrame(data)
 
print(df)

Conclusion

In this tutorial, you have learned the process of converting an Object to Dataframe in Python using the pandas library.

This is a common task when working with data in Python, and by following these simple steps, you can convert your data into a more convenient, structured format for further analysis and visualization.