How to stop returning the index and column name when using loc [duplicate]

Question

I have a tkinter program that connects to a CSV file. I am trying to insert certain values from the CSV file into text boxes in tkinter. I am selecting the values using loc slicing.

The problem I am running into is that my slicing returns the column name and index in addition to the value I want. Because of this, I cannot insert the correct value into my tkinter text box. Can someone help me remove the column name and index from my results?

Code:

ID = Entry6.get()
follow_up_DF = pd.read_csv('file.csv')
name = follow_up_DF.loc[follow_up_DF["Email ID"] == int(ID),["Name"]]
subject=Text(home, height=1)
subject.insert(1.0,(name))
subject.place(x=0, y=400)

Try doing name = follow_up_DF.loc[follow_up_DF["Email ID"] == int(ID),["Name"]].value to simply get the value of the target location. — NotAName
– NotAName, Commented Dec 19, 2022 at 3:14
Serialization / IO / conversion. .values - Attributes. to_list() - Conversion. — wwii
– wwii, Commented Dec 19, 2022 at 3:32
I added "values" to the end of the code and am now getting the correct value returned, however, it is surrounded by brackets. The value returned looks like this [['XXXX']]. Is there any way to only return the string of text? — sw4ps
– sw4ps, Commented Dec 19, 2022 at 3:34

Sean Palmer · Accepted Answer · 2022-12-19 04:46:39Z

1

Try making name equal to this:

name = follow_up_DF.loc[follow_up_DF["Email ID"] == int(ID),["Name"]].value[0][0]

.value should return just the item from the row, not its index and column name.

edited Dec 19, 2022 at 4:46

answered Dec 19, 2022 at 3:42

Sean Palmer

1631 silver badge9 bronze badges

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

6 Comments

sw4ps Over a year ago

When I used this I got the following error: AttributeError: 'DataFrame' object has no attribute 'item'

Sean Palmer Over a year ago

try subscripting .values like this --> follow_up_DF.loc[follow_up_DF["Email ID"] == int(ID),["Name"]].values[0]

sw4ps Over a year ago

Thank you - This works in getting rid of one set of brackets, but not the second set or the quotes. Right now I am getting a result like this ['XXXX']

Sean Palmer Over a year ago

do it again then, ie follow_up_DF.loc[follow_up_DF["Email ID"] == int(ID),["Name"]].values[0][0]

sw4ps Over a year ago

That works perfectly! Thank you for your patience, Python beginner here just getting started :)

|

Collectives™ on Stack Overflow

How to stop returning the index and column name when using loc [duplicate]

1 Answer 1

6 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Linked

Related