I have a dataframe with a column which has multiple comma separated values:

| A |
| --- |
| a, b, c, d |
| a, c |
| b, d |
| b, d |
| c, d |

I want the counts of each of these comma separated values in the column as a data frame like so:

| A | Count |
| --- | --- |
| a | 2 |
| b | 3 |
| c | 3 |
| d | 4 |

Is there a straight forward way in pandas to achieve this?

I have currently parsed column A to get the list of unique items in A. And then created a dictionary again by parsing the column again and checking if item exists in the individual cell.