How to show selected columns without Index in Python without using Print statement

Question

I have been trying to find the display the top 10 companies from the list of 2000 based on a particular column. but the issue is when I input the variable to display the data set, it shows the index and I wanted to know is this can be done without using Print statement.

My current code is

forbes_global = pd.read_csv("Forbes_Global_2000_2019.csv")
profit_assest_company=forbes_global[['Company','Profits as % of Assets']]
profit_assest_company.sort_values(by=['Profits as % of Assets'],ascending=False).head(10)

The current output which I am getting is:

The desired output which I want is:

Can anyone help me with this?

Where are you displaying the data? A jupyter notebook or somewhere else? — Eric Truett
– Eric Truett, Commented Apr 18, 2021 at 1:32
@EricTruett I am trying to display in Jupyter notebook itself. — Mr Pool
– Mr Pool, Commented Apr 18, 2021 at 14:17
@ChihebNexus I don't want to do it with print statement, I did find out how to do with print but i wanted to do it without print statement. — Mr Pool
– Mr Pool, Commented Apr 18, 2021 at 14:17

Eric Truett · Accepted Answer · 2021-04-18 15:17:54Z

1

You can use pandas styling to hide the index in a jupyter notebook

(
  profit_assest_company
  .sort_values(by=['Profits as % of Assets'], ascending=False)
  .head(10)
).style.hide_index()

answered Apr 18, 2021 at 15:17

Eric Truett

3,0201 gold badge19 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to show selected columns without Index in Python without using Print statement

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related