pandas dataframe remove index column code example

Example 1: how to drop the index column in pandas

df.reset_index(drop=True, inplace=True)

Example 2: delete index in df

>>> df.reset_index(drop=True)
    class  max_speed
0    bird      389.0
1    bird       24.0
2  mammal       80.5
3  mammal        NaN

Example 3: pandas drop columns by index

cols = [1,2,4,5,12]
df.drop(df.columns[cols],axis=1,inplace=True)

Example 4: remove index in pd.read

df.to_csv(filename, index=False)

Example 5: how to remove some indexes from a dataframe in python

>>> df.drop(index='cow', columns='small')
                big
lama    speed   45.0
        weight  200.0
        length  1.5
falcon  speed   320.0
        weight  1.0
        length  0.3