How do I remove/omit the count column from the dataframe in Pandas?

Question

This is probably very simple, but I've searched for hours and I can't find how to remove/omit column 1 (count column) in pandas?

Currently looks like:

    ID     Test1    Test2   Test3
1   236    data1    data2   data3   
2   323    data4    data5   data3
3   442    data6    data2   data4
4   543    data8    data2   data3
5   676    data1    data8   data4

Needs to look like:

ID     Test1    Test2   Test3
236    data1    data2   data3   
323    data4    data5   data3
442    data6    data2   data4
543    data8    data2   data3
676    data1    data8   data4

Code Snippet:

df = df[['ID','Test1','Test2','Test3']]
df.sort_values(['ID'], ascending=[True], inplace=True)
return render_template('index.html', data=df.to_html(index_names=False))

Thanks!

Answer 1

If you want to use a specific column as your index then you just use set_index:

In [24]:
df.set_index('ID', inplace=True)
df

Out[24]:
     Test1  Test2  Test3
ID                      
236  data1  data2  data3
323  data4  data5  data3
442  data6  data2  data4
543  data8  data2  data3
676  data1  data8  data4