How to count specific values of a pandas dataframe column attribute

Question

In my pandas dataframe I have a column named "crashhour" which have two values that is offtime and picktime. How to take only the values of offtime. Below is the code of Column value count.

a=df.crashhour.value_counts()

And this is the output-

offtime     19639
picktime    14068
Name: crashhour, dtype: int64

I want to store only the offtime values in a variable like 19639 should be the output. How to do that?

jezrael · Accepted Answer · 2020-09-25 09:21:39Z

1

Use Series.loc:

var = a.loc['offtime']

answered Sep 25, 2020 at 9:21

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to count specific values of a pandas dataframe column attribute

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related