How to drop an index column in Pandas

How to drop an index column in Pandas

To drop an index column in Pandas, you can use the reset_index() function.

This function will convert the index of a dataframe into a column, and then you can use the drop() function to drop that column.

Here's an example of using the reset_index() and drop() functions in Pandas to drop an index column:

import pandas as pd

# create a sample dataframe
df = pd.DataFrame({"A": [1, 2, 3, 4, 5],
                   "B": [6, 7, 8, 9, 10]},
                  index=["a", "b", "c", "d", "e"])

# drop the index column
df_no_index = df.reset_index().drop(columns=["index"])

# display the result
print(df_no_index)

This will convert the index of the dataframe into a column named "index", and then drop that column using the drop() function.

The output will be:

   A   B
0  1   6
1  2   7
2  3   8
3  4   9
4  5  10