/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

12 votes139 views2 answers
Python read from stdin
Python
10 votes142 views3 answers
Python httpserver
Python
1 vote180 views2 answers
Python pywhatkit
Python
13 votes150 views4 answers
Pandas dataframe select rows not in list
Python
1 vote124 views1 answer
Django template decimal places
Python Django
7 votes148 views1 answer
Learn python the hard way pdf
Python
0 vote143 views1 answer
Replace nan in pandas column with mode and printing it
Python
0 vote124 views1 answer
Django template date format yyyy-mm-dd
Python Django
2 votes154 views1 answer
Download youtube videos using api python
Python
0 vote142 views1 answer
How to capture video in google colab with python
Python

Share