Python count multiple values in dictionary of list

Question

I have been trying to count the values in a dictionary with respect to the key. However, I could not achieved desired result. I will demonstrate with more details below:

from collections import Counter
d = {'a': ['Adam','Adam','John'], 'b': ['John','John','Joel'], 'c': ['Adam','Adam','John}
# create a list of only the values you want to count,
# and pass to Counter()
c = Counter([values[1] for values in d.itervalues()])
print c

My output:

Counter({'Adam': 2, 'John': 1})

I want it to count everything in the list, not just first value of the list. Also, I want my result to be with respect to the key. I will show you my desired output below:

{'a': [{'Adam': 1, 'John': 2}, 'b':{'John': 2, 'Joel': 1}, 'c':{'Adam': 2, 'John': 1 }]}

Is it possible to get this desired output? Or anything close to it? I would like to welcome any suggestions or ideas that you have. Thank you.

Hi Marcus, I have tried to search online for a solution for hours. Unfortunately, I couldn't find it. Could it give me link to it? Thank you. — user3271404
– user3271404, Commented Oct 15, 2016 at 11:43

itzMEonTV · Accepted Answer · 2016-10-15 13:25:12Z

1

Try this using dict comprehension

from collections import Counter
d = {'a': ['Adam','Adam','John'], 'b': ['John','John','Joel'], 'c': ['Adam','Adam','John'}
c = {i:Counter(j) for i,j in d.items()}
print c

edited Oct 15, 2016 at 13:25

answered Oct 15, 2016 at 10:58

itzMEonTV

20.4k4 gold badges44 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

user3271404 Over a year ago

Hi, do you elaborate further? Sorry. I am still new to python. Thank you!

itzMEonTV Over a year ago

Is it you desired solution? Look at python dict comprehension and docs.python.org/2/library/collections.html#collections.Counter. Its simple

user3271404 Over a year ago

Sorry. I could find information related to dict comprehension based on the link given by you. Did u give me a wrong link?

itzMEonTV Over a year ago

link that was about Counter. About dict comprehension python.org/dev/peps/pep-0274

user3271404 Over a year ago

I have read about it. This is what I want. But I have no idea how how should i go about doing it? Pardon me. Do you have idea about it? Thank you.

|

Moses Koledoye · Accepted Answer · 2016-10-15 10:59:35Z

1

You're picking only the first elements in the each list with values[1], instead, you want to iterate through each values using a for that follows the first:

>>> from collections import Counter
>>> d = {'a': ['Adam','Adam','John'], 'b': ['John','John','Joel'], 'c': ['Adam','Adam','John']}
>>> Counter([v for values in d.itervalues() for v in values]) # iterate through each value
Counter({'John': 4, 'Adam': 4, 'Joel': 1})

answered Oct 15, 2016 at 10:59

Moses Koledoye

78.8k8 gold badges139 silver badges141 bronze badges

1 Comment

user3271404 Over a year ago

Hi your solution is great. However, is it possible to the outside to produce the result that is linked to the dictionary? For eg {'a': [{'Adam': 1, 'John': 2} Thanks!

Collectives™ on Stack Overflow

Python count multiple values in dictionary of list

2 Answers 2

7 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related