Get value of cell using pandas - Python

Question

I have excell file and I used table = pd.read_excel('file.xlsx') in python. I really can not figure it out how to get concrete content o cell - it must be so simple!

I want to write something like table['orange]['addr'] and I want to get 0x8080004 or table['banana']['value'] and get 12

BENY · Accepted Answer · 2022-02-15 17:44:46Z

2

You can do set_index

table = table.set_index('name')

Then you can do your slice with loc

table.loc['orange','addr']
'0x8080004'

answered Feb 15, 2022 at 17:44

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Collectives™ on Stack Overflow

Get value of cell using pandas - Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related