Python: How to hide index when executing

Question

It's probably something very stupid but I can't find a solution to not print the indexes when executing the code.My code goes:

Reading the excel file and choosing a specific component

df= pd.read_excel('Components.xlsx')
component_name = 'Name'

Forcing the index to be a certain column

df = df.set_index(['TECHNICAL DATA'])

Selecting data in a cell with df.loc

component_lifetime=df.loc[['Life time of Full unit'],component_name]
print(componet_lifetime)

What I get is:

TECHNICAL DATA

Life time of Full unit 20

Is it possible to hide all the index data and only print 20? Thank you ^^

Adding .values (component_lifetime=df.loc[['Life time of Full unit'],component_name].values) should do the job — Tarifazo
– Tarifazo, Commented Dec 18, 2018 at 16:36

jpp · Accepted Answer · 2018-12-18 18:18:52Z

1

Use pd.DataFrame.at for scalar access by label:

res = df.at['Life time of Full unit', 'Name']

A short guide to indexing:

Use iat / at for scalar access / setting by integer position or label respectively.
Use iloc / loc for non-scalar access / setting by integer position or label respectively.

You can also extract the NumPy array via values, but this is rarely necessary.

answered Dec 18, 2018 at 18:18

jpp

166k37 gold badges301 silver badges363 bronze badges

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

1 Answer 1