擅长:python、mysql、java
<p>您可以使用<code>pd.crosstab</code>来创建一个频率表,即为每个<code>org</code>计算<code>is_overdue</code>的数目。在</p>
<pre><code>import pandas as pd
d = {
'id': [1, 2, 3, 4, 5],
'is_overdue': [True, False, True, True, False],
'org': ['A81001', 'A81002', 'A81001', 'A81002', 'A81003']
}
df = pd.DataFrame(data=d)
result = pd.crosstab(index=df['org'], columns=df['is_overdue'], margins=True)
result = result.rename(columns={True:'is_overdue', False:'not overdue'})
result['proportion'] = result['is_overdue']/result['All']*100
print(result)
</code></pre>
<p>收益率</p>
^{pr2}$