Pandas get frequency of item occurrences in a column as percentage

python pandas dataframe percentage
SANM2009 picture SANM2009 · May 28, 2018 · Viewed 62k times · Source

I want to get a percentage of a particular value in a df column. Say I have a df with (col1, col2 , col3, gender) gender column has values of M or F. I want to get the percentage of M and F values in the df.

I have tried this, which gives me the number M and F instances, but I want these as a percentage of the total number of values in the df.

df.groupby('gender').size()

Can someone help?

Answer

cs95 picture cs95 · May 28, 2018

Use value_counts with normalize=True:

df['gender'].value_counts(normalize=True) * 100

Related questions

Calculating and creating percentage column from two columns

I have a df (Apple_farm) and need to calculate a percentage based off values found in two of the columns (Good_apples and Total_apples) and then add the resulting values to a new column within Apple_farm called …

Read More
How to select rows from a DataFrame based on column values

How can I select rows from a DataFrame based on values in some column in Pandas? In SQL, I would use: SELECT * FROM table WHERE colume_name = some_value I tried to look at Pandas' documentation, but I did not …

Read More
Renaming columns in pandas

I have a DataFrame using pandas and column labels that I need to edit to replace the original column labels. I'd like to change the column names in a DataFrame A where the original column names are: ['$a', '$…

Read More