How to count top 10 most common values in a dict in python

by

Initialize the Counter once, let the keys be artists, and augment a key (artist) each time through the loop:

c = Counter()
for d in entries:
    arts = d['artist']
    c[arts] += 1
print(c.most_common(10))

When arts is a string, then c = Counter(arts) counts the characters in arts:

In [522]: collections.Counter('Led Zepplin')
Out[522]: Counter({'e': 2, 'p': 2, ' ': 1, 'd': 1, 'i': 1, 'L': 1, 'l': 1, 'n': 1, 'Z': 1})

In contrast:

In [523]: c = collections.Counter()

In [524]: c['Led Zepplin'] += 1

In [525]: c['The Rolling Stones'] += 1

In [526]: c.most_common()
Out[526]: [('Led Zepplin', 1), ('The Rolling Stones', 1)]

Alternatively, as Jon Clements points out, build a list of all the artists, and then count the list:

c = Counter(d['artist'] for d in entries)
print(c.most_common(10))

Note that the above uses a generator expression to avoid building a (possibly) large temporary list, and at the same time has a much more succinct, readable syntax.

More Related Contents:

  1. Writing a Python list of lists to a csv file
  2. Reading a huge .csv file
  3. Skip the headers when editing a csv file using Python
  4. Read and Write CSV files including unicode with Python 2.7
  5. Python parse CSV ignoring comma with double-quotes
  6. Surprising results with Python timeit: Counter() vs defaultdict() vs dict()
  7. portable way to write csv file in python 2 or python 3
  8. Use Multiple Character Delimiter in Python Pandas read_csv
  9. How can I use io.StringIO() with the csv module?
  10. Python Pandas – Read csv file containing multiple tables
  11. Get data from Twitter using Tweepy and store in csv file
  12. How to match a string to pattern “Foo-Bar”, where Bar can be any element of a list? [closed]
  13. What’s wrong with my Python 2 program?
  14. datetime dtypes in pandas read_csv
  15. Dead simple example of using Multiprocessing Queue, Pool and Locking
  16. csv.Error: iterator should return strings, not bytes
  17. Getting only element from a single-element list in Python?
  18. What is the difference between len() and sys.getsizeof() methods in python?
  19. Python regex for unicode capitalized words
  20. How to avoid pandas creating an index in a saved csv
  21. How to add header row to a pandas DataFrame
  22. UnicodeDecodeError: ‘utf-8’ codec can’t decode byte 0x8b in position 1: invalid start byte, while reading csv file in pandas
  23. Easier way to enable verbose logging
  24. Multiple delimiters in single CSV file
  25. How do I make the screen ignore the background color of some image?
  26. How do you remove the column name row when exporting a pandas DataFrame?
  27. Run process with realtime output to a Tkinter GUI
  28. What does the slice() function do in Python?
  29. Any way to get one process to have a write lock and others to just read on parallel?
  30. Google Search Web Scraping with Python

Leave a Comment