Given a pandas Series that represents frequencies of a value, how can I turn those frequencies into percentages?

by

This function is implemented in pandas, actually even in value_counts(). No need to calculate 🙂

just type:

df.sex.value_counts(normalize=True)

which gives exactly the desired output.

Please note that value_counts() excludes NA values, so numbers might not add up to 1.
See here: http://pandas-docs.github.io/pandas-docs-travis/generated/pandas.Series.value_counts.html
(A column of a DataFrame is a Series)

More Related Contents:

  1. Split / Explode a column of dictionaries into separate columns with pandas
  2. Converting between datetime, Timestamp and datetime64
  3. Annotate bars with values on Pandas bar plots
  4. plot different color for different categorical levels using matplotlib
  5. Counting consecutive positive values in Python/pandas array
  6. Pandas GroupBy and select rows with the minimum value in a specific column
  7. Pandas Groupby and Sum Only One Column
  8. Pandas Dataframe: Replacing NaN with row average
  9. How to read a .xlsx file using the pandas Library in iPython?
  10. Pandas – Number of Months Between Two Dates
  11. Pandas Replace NaN with blank/empty string
  12. Modify the legend of pandas bar plot
  13. How do I convert a list in a Pandas DF into a string?
  14. How to append rows in a pandas dataframe in a for loop?
  15. Interpolation on DataFrame in pandas
  16. ValueError: Length of values does not match length of index | Pandas DataFrame.unique()
  17. Pandas Groupby / List to Multiple Rows
  18. How to reorder indexed rows based on a list in Pandas data frame
  19. Trying to merge 2 dataframes but get ValueError
  20. Pivot table subtotals in Pandas
  21. Pandas Latitude-Longitude to distance between successive rows [duplicate]
  22. pd.Timestamp versus np.datetime64: are they interchangeable for selected uses?
  23. Convert percent string to float in pandas read_csv
  24. Python pandas integer YYYYMMDD to datetime
  25. MemoryError when I merge two Pandas data frames
  26. How to resample a dataframe with different functions applied to each column?
  27. Expand pandas DataFrame column into multiple rows
  28. Using regex matched groups in pandas dataframe replace function
  29. How to get number of groups in a groupby object in pandas?
  30. Sorting a pandas series

Leave a Comment