How to Convert a Pandas DataFrame Index into a Column?

Converting Dataframe Index into a Column

In Python's Pandas library, transforming the index of a dataframe into a column can be a useful data manipulation task. Here's how you can achieve this conversion:

Using the df['index1'] = df.index Method:

This approach directly assigns the dataframe's index to a new column named 'index1' using the = operator:

df['index1'] = df.index

After this operation, the dataframe will include an additional column 'index1' containing the original index values.

Using the .reset_index Method:

Alternatively, you can use the .reset_index method to convert the index into a column and simultaneously reset the original index:

df = df.reset_index()

The index or specific level parameters can be used to customize the number or specific levels to be reset:

df = df.reset_index(level=[0, 1])

This will reset the first and second-level indexes, converting them into columns.

Example:

Consider the dataframe below:

        gi       ptt_loc
0  384444683      593
1  384444684      594
2  384444686      596

Using the first method:

df['index1'] = df.index

Will result in:

    index1    gi       ptt_loc
0  0     384444683      593
1  1     384444684      594
2  2     384444686      596

Using the second method:

df = df.reset_index()

Will result in:

   index  gi       ptt_loc
0      0  384444683      593
1      1  384444684      594
2      2  384444686      596

Both methods effectively convert the index into a column. However, the .reset_index method also resets the original index.

The above is the detailed content of How to Convert a Pandas DataFrame Index into a Column?. For more information, please follow other related articles on the PHP Chinese website!