I have a data frame that shows answers of a multiple-choice question of 5 students:
id Question 1
And I want to count how many times does a choice been selected. For example, the final answer should be
So is there a quick way to get the solution using python?
Besides, I am using the data from the data frame for visualization in Tableau. Tableau counts like this:
a;b;c appear once
a;c appear once
b appear once
a;d appear once
b;c;d appear once
So is there a way to get the above result directly using Tableau? Or I have to do something in python then using tableau.