How do I group this list of dicts by the same month?

by

First, I would sort the data1:

>>> lst = [{'date':'2008-04-23','value':'1'},
... {'date':'2008-04-01','value':'8'},
... {'date':'2008-04-05','value':'3'},
... {'date':'2009-04-19','value':'5'},
... {'date':'2009-04-21','value':'8'},
... {'date':'2010-09-09','value':'3'},
... {'date':'2010-09-10','value':'4'},
... ]
>>> lst.sort(key=lambda x:x['date'][:7])
>>> lst
[{'date': '2008-04-23', 'value': '1'}, {'date': '2008-04-01', 'value': '8'}, {'date': '2008-04-05', 'value': '3'}, {'date': '2009-04-19', 'value': '5'}, {'date': '2009-04-21', 'value': '8'}, {'date': '2010-09-09', 'value': '3'}, {'date': '2010-09-10', 'value': '4'}]

Then, I would use itertools.groupby to do the grouping:

>>> from itertools import groupby
>>> for k,v in groupby(lst,key=lambda x:x['date'][:7]):
...    print k, list(v)
... 
2008-04 [{'date': '2008-04-23', 'value': '1'}, {'date': '2008-04-01', 'value': '8'}, {'date': '2008-04-05', 'value': '3'}]
2009-04 [{'date': '2009-04-19', 'value': '5'}, {'date': '2009-04-21', 'value': '8'}]
2010-09 [{'date': '2010-09-09', 'value': '3'}, {'date': '2010-09-10', 'value': '4'}]
>>>

Now, to get the output you wanted:

>>> for k,v in groupby(lst,key=lambda x:x['date'][:7]):
...     print {'date':k+'-01','value':sum(int(d['value']) for d in v)}
... 
{'date': '2008-04-01', 'value': 12}
{'date': '2009-04-01', 'value': 13}
{'date': '2010-09-01', 'value': 7}

1Your data actually already appears to be sorted in this regard, so you might be able to skip this step.

More Related Contents:

  1. Why am I getting the following error message: Unsupported operand type(s) for +: ‘int’ and ‘str’. See below the python rules body
  2. How to plot in multiple subplots
  3. How to return a dict as a JSON response from a Flask view?
  4. Checking whether a variable is an integer or not [duplicate]
  5. surface plots in matplotlib
  6. How to install python modules without root access?
  7. access ElementTree node parent node
  8. Faster way to read Excel files to pandas dataframe
  9. How to refer to relative paths of resources when working with a code repository
  10. Seeing escape characters when pressing the arrow keys in python shell
  11. Fastest way to grow a numpy numeric array
  12. Is there a ceiling equivalent of // operator in Python?
  13. heapq with custom compare predicate
  14. GeoDjango on Windows: “Could not find the GDAL library” / “OSError: [WinError 126] The specified module could not be found”
  15. What does print()’s `flush` do?
  16. Pandas filter dataframe rows with a specific year
  17. How to fix ‘numpy.ndarray’ object has no attribute ‘get_figure’ when plotting subplots
  18. How to zoomed a portion of image and insert in the same plot in matplotlib
  19. Is there a way to delete created variables, functions, etc from the memory of the interpreter?
  20. Can’t import dll module in Python
  21. Python Flask, how to set content type
  22. Is there a way to compile a python application into static binary?
  23. Adding backslashes without escaping [duplicate]
  24. Why python executable opens new window instance when function by multiprocessing module is called on windows
  25. How to determine who emitted the signal?
  26. How to get most informative features for scikit-learn classifier for different class?
  27. How can I stop Python’s csv.DictWriter.writerows from adding empty lines between rows in Windows?
  28. Problem in combining bar plot and line plot
  29. Plot all pandas dataframe columns separately
  30. Python pandas equivalent for replace

Leave a Comment