Pandas Print rows if value greater than some value

0 votes
Hi. I have a dataframe that contains the name of a student in one column and that student's score in another column. I want to print the details of the students whose score is greater than 80. What logic should I use for this?
May 9, 2019 in Python by Richa
83,577 views

1 answer to this question.

0 votes

You can use condition checking for this. Just use the column name and check the condition as follows:

df[df.Score > 80]
answered May 9, 2019 by Reshma
What if my column name has a space in it?
Hey, @Adam,

On what perspective you asking your doubt? Kindly elaborate your query. In the above case, the condition was applied to the elements inside the column neither on the particular column name.

 Are you asking regarding how can you sort the column name if there are two words like name and surname?

Please let me know what exactly you are looking for.

Related Questions In Python

0 votes
1 answer

Python pandas: print all values greater than zero in the dataframe

You can use the following code: df[df > ...READ MORE

answered May 13, 2019 in Python by Esha
19,935 views
0 votes
1 answer

How to find if a value exists in Pandas dataframe?

Try this:​ for name in df['Name']: ...READ MORE

answered Apr 8, 2019 in Python by Tina
12,654 views
0 votes
1 answer

Pandas print the first few rows of dataframe

Pandas allows you to slice the dataframe ...READ MORE

answered May 9, 2019 in Python by Shri
6,073 views
0 votes
1 answer

How to print rows at different locations of pandas dataframe?

Like you are using row slicing, you ...READ MORE

answered May 13, 2019 in Python by Gani
2,163 views
0 votes
1 answer

How to rename columns in pandas (Python)?

You can use the rename function in ...READ MORE

answered Apr 30, 2018 in Data Analytics by DeepCoder786
• 1,720 points

edited Jun 8, 2020 by MD 2,088 views
0 votes
1 answer

What is the Difference in Size and Count in pandas (python)?

The major difference is "size" includes NaN values, ...READ MORE

answered Apr 30, 2018 in Data Analytics by DeepCoder786
• 1,720 points

edited Jun 8, 2020 by Gitika 2,922 views
0 votes
2 answers

Replacing a row in pandas data.frame

key error. I love python READ MORE

answered Feb 18, 2019 in Data Analytics by anonymous
13,792 views
0 votes
1 answer

Converting a pandas data-frame to a dictionary

Emp_dict=Employee.to_dict('records') You can directly use the 'to_dict()' function ...READ MORE

answered May 23, 2018 in Data Analytics by Bharani
• 4,660 points
4,600 views
0 votes
1 answer

How to find the sum of rows in Pandas dataframe?

You can use a combination groupby function with the sum() method. ...READ MORE

answered May 9, 2019 in Python by Jisha
4,634 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP