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!
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
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments