# -*- coding: utf-8 -*-
"""
Created on Sat May 22 23:52:57 2021

@author: PC
"""

import pandas as pd
import os

os.chdir(r'C:\Users\PC\Pytho')

df= pd.read_csv('NISPUF17.csv')
df= df[['SEX', 'HAD_CPOX', 'P_NUMVRC']]
df= df[df['P_NUMVRC'] > 0]  #Vacinated atleast once

#(male, had_cpox) / (male, not_had_cpox)
#(female, had_cpox) / (female, not_had_cpox)
result = { 'male':  len(df[ (df['SEX']==1) &  (df['HAD_CPOX']==1)])/len(df[ (df['SEX']==1) &  (df['HAD_CPOX']==2)]),
          'female': len( df[ (df['SEX']==2)  & (df['HAD_CPOX']==1) ])/ len( df[ (df['SEX']==2)  & (df['HAD_CPOX']==2) ])
    }

print(result)