/Python/Pandas count number of rows with value

Pandas count number of rows with value

Get number of rows pandas

number_of_rows = len(df)

6

Pandas count rows in column

>>> df.count(axis='columns')
0    3
1    2
2    3
3    3
4    3
dtype: int64

2

Source: pandas.pydata.org

Pandas count rows with value

len(df[df['score'] == 1.0])

1

Source: morphocode.com

Pandas count number of rows with value

In [37]:
df = pd.DataFrame({'a':list('abssbab')})
df.groupby('a').count()

Out[37]:

   a
a   
a  2
b  3
s  2

[3 rows x 1 columns]

0

Source: stackoverflow.com

Similar codes

-1 vote209 views1 answer
Class views django slug
Python Django
-1 vote191 views2 answers
Design patterns in python
Python
0 vote178 views1 answer
Python logger format time
Python
1 vote169 views1 answer
How do you create a countdown using turtle python
Python
101 votes170 views6 answers
Remove last character from string python
Python
0 vote189 views1 answer
Server error 500 heroku django
Python Django
0 vote165 views1 answer
Python - Cara Memisahkan String Berdasarkan Beberapa Delimiter
Python
0 vote164 views1 answer
Gridsearch cv
Python
0 vote316 views1 answer
Python pid control
Python
0 vote150 views1 answer
NameError: name 'accuracy_score' is not defined
Python

Share