list from excel

[devilonline]

I
I'm trying to search from a excel file. I've make a convert to a dictionary but still didnt work

I want for example search id 1 and print name Charles
can you help me

table from excel file

import pandas as pd df = pd.read_excel("book.xlsx") dict_a = df.to_dict() search_name = int(input("Provide ID: ")) key_of_value = list(dict_a)[list(dict_a["id"]).index(search_name)] print(key_of_value) 

[snippsat]

When you frist have gotten data into Pandas,then you use Pandas methods to solve this.
No need to take data out and try to solve this in standard Python.
Example.

import pandas as pd df = pd.DataFrame(columns = ['Id', 'Name','Age']) Id = [1, 2, 3] names = ["Charles", 'Mary', 'Stuart'] ages = [33, 18, 22] df.Id = Id df.Name = names df.Age = ages

>>> df Id Name Age 0 1 Charles 33 1 2 Mary 18 2 3 Stuart 22 >>> >>> df.loc[df['Id'] == 1, 'Name'] 0 Charles Name: Name, dtype: object

Or can use df.query

>>> d = df.query('Id==1')['Name'] >>> d 0 Charles Name: Name, dtype: object >>> d.values array(['Charles'], dtype=object) >>> d.to_dict() {0: 'Charles'} >>> d.to_list()[0] 'Charles'

[devilonline]

but i want that it reads the information from the excel file and the query of example '1' and prints charles
is there a way to do it? thanks

[snippsat]

You don't convert to df.to_dict() this takes it out of Pandas(has a lot of power💥) and it standard dictionary.
By the look of your Excels file this should work.

import pandas as pd df = pd.read_excel("book.xlsx") df_val = df.query('id==1')['Name'] print(df_val) print(d.values[0]) 

[devilonline]

thanks