给定一个代表一个值的频率的熊猫系列，我如何将这些频率转换成百分比？

我在用 kaggle.com 的泰坦尼克号数据集(泰坦尼克号上每个人的数据)做实验，得出了这样一个性别分类:

df = pd.DataFrame({'sex': ['male'] * 577 + ['female'] * 314})
gender = df.sex.value_counts()
gender


male   577
female 314

我想知道泰坦尼克号上男女船员的比例。

我的方法略有欠理想:

from __future__ import division
pcts = gender / gender.sum()
pcts


male      0.647587
female    0.352413

有没有更好的(更惯用的)方法？

86442 次浏览

小开

I think I would probably do this in one go (without importing division):

1. * df.sex.value_counts() / len(df.sex)

or perhaps, remembering you want a percentage:

100. * df.sex.value_counts() / len(df.sex)

Much of a muchness really, your way looks fine too.

小开

最佳答案

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)

小开

If you want to merge counts with percentage, can use:

c = df.sex.value_counts(dropna=False)
p = df.sex.value_counts(dropna=False, normalize=True)
pd.concat([c,p], axis=1, keys=['counts', '%'])

小开

In case you wish to show percentage one of the things that you might do is use value_counts(normalize=True) as answered by @fanfabbb.

With that said, for many purposes, you might want to show it in the percentage out of a hundred.

That can be achieved like so:

gender = df.sex.value_counts(normalize=True).mul(100).round(1).astype(str) + '%'

In this case, we multiply the results by hundred, round it to one decimal point and add the percentage sign.