Steps to Convert Index to Column in Pandas DataFrame

When creating DataFrames you may run into situations where you need to convert the index into a true column.

In the example below you’ll notice that while we have a “song_id” it is actually a 2 column DataFrame.

final_count_df.reset_index(inplace=True)
final_count = final_count_df.rename(columns = {'index':'song_id'})

Resetting then renaming the index will provide us with a true column. In the example below, we’re low looking at a true 3-column DataFrame.