Panda Python - Calculating what percentage of values are true and false out of total in boolean column
Panda Python - Calculating what percentage of values are true and false out of total in boolean column
Hello I have a boolean value with True and False.
When I run a value_counts()
like this
value_counts()
df['column'].value_counts()
I receive the following:
True 10718
False 1105
Name: column, dtype: int64
Is there a way to calculate what % of the total is true and what % is false?
Something like this:
True 91%
False 09%
Name: column, dtype: int64
Thank you
2 Answers
2
You can do with
df['yourcolumns'].value_counts(normalize=True).mul(100).astype(str)+'%'
I was notified that it is as simple as
df['column'].value_counts(normalize=True)
Thanks for contributing an answer to Stack Overflow!
But avoid …
To learn more, see our tips on writing great answers.
Required, but never shown
Required, but never shown
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
Oh thank you, that last part with the '%' really fixes it too!
– blacksatius
Sep 7 '18 at 21:56