擅长:python、mysql、java
<pre><code>import pandas as pd
import numpy as np
def chickenpox_by_sex():
df = pd.read_csv('assets/NISPUF17.csv', index_col=0)
cpo_sex = df[df['P_NUMVRC'].gt(0) & df['HAD_CPOX'].lt(3)].loc[:,['HAD_CPOX','SEX']]
print(cpo_sex)
one_male = (cpo_sex[(cpo_sex['HAD_CPOX']== 1) & (cpo_sex['SEX']== 1)]).size
one_female = (cpo_sex[(cpo_sex['HAD_CPOX']== 1) & (cpo_sex['SEX']== 2)]).size
more_male = (cpo_sex[(cpo_sex['HAD_CPOX'] == 2) & (cpo_sex['SEX']== 1)]).size
more_female = (cpo_sex[(cpo_sex['HAD_CPOX'] == 2) & (cpo_sex['SEX']== 2)]).size
chickenpox_by_sex = {'male': one_male/more_male,
'female': one_female/more_female}
print(chickenpox_by_sex)
return chickenpox_by_sex
</code></pre>