Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in BI by (17.6k points)

I have a data frame that shows answers of a multiple-choice question of 5 students:

id     Question 1

0          a;b;c

1          a;c

2          b

3          a;d

4          b;c;d

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.



1 Answer

0 votes
by (47.2k points)
selected by
Best answer

Try the following code to count the occurrence of each choice in a pandas dataframe column:

data = pd.DataFrame({'id':[0, 1,2,3,4], 'Question1':['a;b;c','a;c','b','a;d','b;c;d']})

count = data.Question1.str.split(';', expand=True).stack().value_counts()


a    3

b    3

c    3

d    2

dtype: int64

Browse Categories