How to Create a Dataframe in Python Without Index

To create a dataframe in Python without an index, you can use the reset_index() function along with the drop() function.

The following example shows how to create a dataframe without an index in Python.

Using reset_index() & drop() Function

We can use the reset_index() and drop() functions to remove the index from a dataframe.

Suppose we have the following data:

# Import pandas library
import pandas as pd

# Declare data
data = {
    'Date': ['01-03-2023', '01-03-2023', '01-03-2023', '01-03-2023', '02-03-2023', '02-03-2023'],
    'Product_Code': ['A-101', 'A-102', 'A-103', 'B-101', 'B-102', 'B-104'],
    'Product_Name': ['Laptop', 'Mobile', 'Printer', 'Keyboard', 'Scanner', 'Mouse'],
    'Price': [4500, 550, 250, 50, 350, 50],
    'Status': [1, 1, 1, 0, 1, 1]
}

# Create dataframe
df = pd.DataFrame(data)

# Drop index
new_df = df.reset_index().drop(columns=['index'])

# Show dataframe
print(new_df)

Output: 👇️

         Date Product_Code Product_Name  Price  Status
0  01-03-2023        A-101       Laptop   4500       1
1  01-03-2023        A-102       Mobile    550       1
2  01-03-2023        A-103      Printer    250       1
3  01-03-2023        B-101     Keyboard     50       0
4  02-03-2023        B-102      Scanner    350       1
5  02-03-2023        B-104        Mouse     50       1

In this example, we use the reset_index() and drop() functions to remove the original index from the dataframe df.

The output shows the dataframe without the index.

Conclusion

We can use the reset_index() and drop() functions to create a dataframe without an index in Python.