import numpy as np import pandas as pd
CS=pd.read_excel("F:/2019 GB Python/ChiS.xlsx")
CS.head()
from scipy.stats import chisquare,chi2_contingency
CR= pd.crosstab(CS['Client'], CS['Result'])
CR
chi2_contingency(CR)
(5.9040322183091485, 0.015106263154280606, 1, array([[ 19.94666667, 31.05333333], [ 68.05333333, 105.94666667]]))