Oct-25-2021, 07:55 PM
For that would use groupby, not crosstab.
import pandas as pd df = pd.DataFrame([[1,'A'],[2,'A'],[3,'B'],[4,'B']], columns=['Numbers','Letters']) idx = df.index nrows = len(idx) df1 = df.groupby(by='Letters').size()/nrows df1
Output:Letters
A 0.5
B 0.5
dtype: float64