Split the Column Values in to Multiple Columns and counting

[dondapati]

HI to Experts,

i have the data set where the column contains the multiple values those values separated with with "," .Now i want to split the those column values in to multiple columns and count the occurrence of each value.

Input:

aa      bb
foo     [a,b,b,c,a]
goo    [a,c,b,d]
doo    [e,b,a,d,e]

Required Output:

aa       a b c d e

foo      2 2 1 0 0
goo     1 1 1 1 0
doo     1 1 0 1 2

Thank you.

[ElwinPang · Accepted solution]

Hi, just some quick draft. Hope it help you. 

[grazitti_sapna]

Hi @dondapati,

Here is another approach  to your problem.

Thanks.