I have a dataframe as shown in the picture and what I am trying to do is to calculate the number of occurrences based on the values in 2 columns and then calculate the percentage of the occurrences. I have tried the following code but it gives me a zero value in the end and i don't know why.
the expected output should be 3/6 = 0.5
count_a2_x = (df['a1'].str.contains('b') & df['a2'].str.contains('x')).value_counts()[True] count_a2_y = (df['a1'].str.contains('b') & df['a2'].str.contains('y')).value_counts()[True] acc = float(count_a2_x/ (count_a2_x + count_a2_y))
1.5 KB Views: 313