How to find significancy of grouped Data
I found the answer by playing more with my data.
The answer is to build a new dataframe with 6 columns




A
B
C
1
2
3




1
-
-
1
-
-


1
-
-
-
1
-


1
-
-
-
-
1


-
1
-
1
-
-


-
1
-
-
1
-


-
1
-
-
-
1


-
-
1
1
-
-


-
-
1
1
-
-


-
-
1
1
-
-




That way I can use the corr function of pandas and see how significant my "C" actually really is.
I have a result of my pre-grouping of grouping columns like this




Letters
Numbers




A
1


A
2


A
3


B
1


B
2


B
3


C
1


C
1


C
1




Now what I wanna do is, to define that C is a Significant factor for 1s as its 100% there but with A or B its only 33%. I wanna show that C significantly differs from A and B.
I think there should be a solution with pandas and data frames, but I'm not really sure how to find that value. Which of the pandas Methods can I use to find that value?
Expected Output:
C significantly differs from A and B in its result spectrum. This is proven by this factor of significancy (this factor is what i search)
Thanks for the help in advance :).