i have a dataframe with the data as follows
id Name Age
0 1 XXX 30
and i have to remove the 0(the row index value) from the dataframe.
I have tried the folowing
df.reset_index(inplace=True) # Resets the index, makes factor a column
df.drop("Factor",axis=1,inplace=True)
but it is not removing the 0.
i want output like:
id Name Age
1 XXX 30
Try this one:
df.set_index('id', inplace=True)
You can use the pandas function set_index
df.set_index('id', inplace=True, drop=True)
In Pandas index is not a separate column that you can remove. It's an indicator like the indicator in array and dictionary.
For example if you have:
letters = ["a", "b", "c", "d", "e"]
letters[2]
2 is an indicator that cannot be removed from array.
But depending your use of dataframe you can tell pandas not to show index in the export.
