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
13,879 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 12, 2019 in Python by Esha
6,572 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
8,138 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
595 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 12, 2019 in Python by Gani
262 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 by MD 430 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 by Gitika 1,132 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
6,370 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,560 points
3,131 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
2,167 views
0 votes
1 answer