/Python/Panda count how many values are less than n in a column

Panda count how many values are less than n in a column

df[df.col_name < 2.0 ].count()

Source: stackoverflow.com

Pandas df count values less than 0

In [96]:

df = pd.DataFrame({'a':randn(10), 'b':randn(10), 'c':randn(10)})
df
Out[96]:
          a         b         c
0 -0.849903  0.944912  1.285790
1 -1.038706  1.445381  0.251002
2  0.683135 -0.539052 -0.622439
3 -1.224699 -0.358541  1.361618
4 -0.087021  0.041524  0.151286
5 -0.114031 -0.201018 -0.030050
6  0.001891  1.601687 -0.040442
7  0.024954 -1.839793  0.917328
8 -1.480281  0.079342 -0.405370
9  0.167295 -1.723555 -0.033937

[10 rows x 3 columns]
In [97]:

df[df > 1.0].count()

Out[97]:
a    0
b    2
c    2
dtype: int64

Source: stackoverflow.com

Similar codes

0 vote195 views2 answers
Is not and != difference in python
Python
38 votes205 views6 answers
Datetime python
Python
0 vote180 views1 answer
What is tensor in deep learning
Python
0 vote226 views1 answer
Show all urls django extensions
Python Django
0 vote198 views1 answer
Sns histplot nan values
Python
0 vote209 views1 answer
Python - matching people based on city
Python
0 vote195 views2 answers
Change index of dataframe with list
Python
0 vote184 views1 answer
Rounding values in pandas dataframe
Python
0 vote284 views1 answer
Annot identify image file '/home/ellis/CB/Django-Ecommerce/media_root/default.jpg'
Python Django
0 vote187 views1 answer
How to use drop for file in python
Python