How to print complete row from excel Sheet using python pandas from user input?

Question

I asked the same question but it is closed and I am not clear with that answer so I am asking again.

I have an excel file similar to this:

Above is the attached picture to see what the excel sheet looks like.

I am learning to write a program if the user input "Martin" it should displays the entire row.

Still learning the basics. Can someone help me how to display the entire row using user input?

below is the code which is not giving output or error.

import pandas as pd
import os

student = pd.read_excel("student.xlsx",sheet_name="Sheet1")

i = input("enter store number: ")

found = []

for letter in i:
    if letter in student:
        if letter not in found:
            found.append(letter)
for student in found:
    print(student)

@BigBen i replaced print (student) with your condition, same issue no output or error — Prashanth, Feb 09 '22 at 17:18
Get rid of everything after `i = input("enter store number: ")` and then add `print(student[student['Name']==i])`. — BigBen, Feb 09 '22 at 17:20
enter store number: Martin Empty DataFrame Columns: [Name, City, Marks, Rank] Index: [] — Prashanth, Feb 09 '22 at 17:35
Maybe it'd help if you created a [good reproducible pandas example](https://stackoverflow.com/questions/20109391/how-to-make-good-reproducible-pandas-examples) with sample data. — BigBen, Feb 09 '22 at 17:37
Please provide enough code so others can better understand or reproduce the problem. — Community, Feb 20 '22 at 03:45

Varadharajan Raghavendran · Answer 1 · 2022-02-09T17:30:48.183

0

Obviously you are trying to a select the rows where your column value = input. This is the best way to do that :)

import pandas as pd
import os

student = pd.read_excel("student.xlsx",sheet_name="Sheet1")

i = input("enter store number: ")
print(student[student['Name'] == i])

edited Feb 09 '22 at 17:30

answered Feb 09 '22 at 17:17

Varadharajan Raghavendran

163
1
12

Empty DataFrame Columns: [Name, City, Marks, Rank] Index: [] – Prashanth Feb 09 '22 at 17:23
above is the output i am getting – Prashanth Feb 09 '22 at 17:24
If you are not using a input that matches your values in the name column you might get an empty df in the results – Varadharajan Raghavendran Feb 09 '22 at 17:31
enter store number: Martin Empty DataFrame Columns: [Name, City, Marks, Rank] Index: [] – Prashanth Feb 09 '22 at 17:38
i am using the value within the column but not getting expected output – Prashanth Feb 09 '22 at 17:39
Okay try using i.strip() instead of just i in the last line. – Varadharajan Raghavendran Feb 09 '22 at 17:51
after adding i.strip() in print(student[student['Name'] == i.strip()]) no change – Prashanth Feb 10 '22 at 03:37
print(student) and see if there is any data in it – Varadharajan Raghavendran Feb 10 '22 at 03:39
if i print, print(student) it is giving complete excel sheet data. – Prashanth Feb 10 '22 at 04:29
print(student[student['Name'].str.strip() == i.strip()]) you can try this but if this doesn't work then there is some encoding issue in your excel sheet – Varadharajan Raghavendran Feb 10 '22 at 04:32

How to print complete row from excel Sheet using python pandas from user input?

1 Answers1