Ask for user input from a file and get output from the file?

See more:

Python

Hi guys I'm new to pandas in python and I am writing a program where I have data from a csv file. I want to write a program that asks for two items from the file shown where the user inputs, then finds that item in the file and outputs the other information about that item. For example, if my csv file has this data

    ID  Gender  Score1  Score2  T1  T2      Grade
0	101	Male	18.25	15.5	94	61.0	PA
1	102	Female	17.75	30.0	79	62.0	PA
2	103	Male	0.00	0.0	    78	15.0	NN
3	104	Male	20.00	25.0	69	65.0	PA
4	105	Male	18.75	30.0	96	51.0	PA

and the input asks for the Id = 101 and T2, I want the output to be male and 61. This is what I have so far.


Can i have some help please?

What I have tried:

import pandas as pd

T2 = str(input('Waiting for input: '))  
studentID = int(float(input('Waiting for input: ')))  

df = pd.read_csv("sample_grades.csv")

print(f"student gender is {student_gender} and assessment score is {assessment_score:.2f}")