logo
down
shadow

Group list of dictionaries python


Group list of dictionaries python

Content Index :

Group list of dictionaries python
Tag : python , By : ziqew
Date : November 25 2020, 03:01 PM

may help you . I think yo dou not fully understand the idea of a defaultdict. A defaultdict will produce a new object if none exists at lookup.
So you can simply use:
from collections import defaultdict

res = defaultdict(list)

for i in data:
    res[i['type']].append(i)
>>> pprint(res)
defaultdict(<class 'list'>,
            {'Regular': [{'quantity': 2, 'type': 'Regular'},
                         {'quantity': 2, 'type': 'Regular'},
                         {'quantity': 2, 'type': 'Regular'},
                         {'quantity': 2, 'type': 'Regular'}],
             'Vip': [{'quantity': 2, 'type': 'Vip'},
                     {'quantity': 23, 'type': 'Vip'}]})

Comments
No Comments Right Now !

Boards Message :
You Must Login Or Sign Up to Add Your Comments .

Share : facebook icon twitter icon

Group By & Aggregate List of Dictionaries in Python


Tag : python , By : Rob
Date : March 29 2020, 07:55 AM
To fix the issue you can do Yes, use pandas. It's great. You can use the groupby functionality and aggregate by sums, then convert the output to a list of dicts if that is exactly what you want.
import pandas as pd

data = [{"startDate": 123, "endDate": 456, "campaignName": 'abc',
         "campaignCfid": 789, "budgetImpressions": 10},
        {"startDate": 123, "endDate": 456, "campaignName": 'abc',
         "campaignCfid": 789, "budgetImpressions": 50},
        {"startDate": 456, "endDate": 789, "campaignName": 'def',
         "campaignCfid": 123, "budgetImpressions": 80}]

df = pd.DataFrame(data)

grouped = df.groupby(['startDate', 'endDate', 'campaignCfid',
                      'campaignName']).agg(sum)

print grouped.reset_index().to_dict('records')
[{'startDate': 123L, 'campaignCfid': 789L, 'endDate': 456L, 'budgetImpressions': 60L, 'campaignName': 'abc'}, {'startDate': 456L, 'campaignCfid': 123L, 'endDate': 789L, 'budgetImpressions': 80L, 'campaignName': 'def'}]

How to sort and group an list of dictionaries in right way in Python


Tag : python , By : Shawazi
Date : March 29 2020, 07:55 AM
like below fixes the issue I solve it using Django's regroup.
The options list is as follows:
options = [
  {'group_priority': 2, 'group': u'Comfort', 'name': u'Air conditioning'}, 
  {'group_priority': 2, 'group': u'Comfort', 'name': u'Air suspension'},  
  {'group_priority': 3, 'group': u'Entertainment', 'name': u'Bluetooth'}, 
  {'group_priority': 3, 'group': u'Entertainment', 'name': u'MP3'}, 
  {'group_priority': 3, 'group': u'Entertainment', 'name': u'Navigation system'}, 
  {'group_priority': 4, 'group': u'Extra', 'name': u'Alloy wheels'}, 
  {'group_priority': 4, 'group': u'Extra', 'name': u'Trailer hitch'},  
  {'group_priority': 4, 'group': u'Security', 'name': u'Xenon headlights'}]
{% regroup car.options_grouped by group as groups %}
{% for group in groups %}
  <div>{{ group.grouper }}</div>
  {% for option in group.list %}
    <div> {{ option.name }}</div>
  {% endfor %}
{% endfor %}

sql to python: how to group a list of dictionaries


Tag : python , By : Stone
Date : March 29 2020, 07:55 AM
Does that help I have a big list of Ids of items that I put in a list of dictionaries: , You can use pandas for that:
import pandas

data = [
    { 'product1': 2, 'item1':4,'product2':333,'item2':222},
    { 'product1': 1, 'item1':123,'product2':333,'item2':222},
    { 'product1': 3, 'item1':433,'product2':333,'item2':222},
    { 'product1': 3, 'item1':433,'product2':333,'item2':224},
]
df = pandas.DataFrame(data)
grouped = df.groupby(['product1', 'item1']).count()
sorted = grouped.sort_values('item2', ascending=False)

Group python list of dictionaries by values


Tag : python , By : Xander
Date : March 29 2020, 07:55 AM
To fix this issue As an alternative to the answer above, here is how you do it without an additional import:
d = {}

for item in dicts:
    d.setdefault(item['price'], []).append(item)

list(d.values())
[[{'name': 'item1', 'price': 10}, {'name': 'item3', 'price': 10}],
 [{'name': 'item2', 'price': 5}, {'name': 'item6', 'price': 5}],
 [{'name': 'item4', 'price': 12}, {'name': 'item5', 'price': 12}]]

Group a List of Python Dictionaries


Tag : python , By : Lee KW
Date : March 29 2020, 07:55 AM
Related Posts Related QUESTIONS :
  • Pandas concat historical data using date minus some number of days
  • CV2: Import Error in Python OpenCV
  • Is it possible to do this loop in a one-liner?
  • invalid literal for int() with base 10: - django
  • Why does my code print a value that I have not assigned as yet?
  • the collatz func in automate boring stuff with python
  • How to find all possible combinations of parameters and funtions
  • about backpropagation deep neural network in tensorflow
  • Sort strings in pandas
  • How do access my flask app hosted in docker?
  • Replace the sentence include some text with Python regex
  • Counting the most common element in a 2D List in Python
  • logout a user from the system using a function in python
  • mp4 metadata not found but exists
  • Django: QuerySet with ExpressionWrapper
  • Pandas string search in list of dicts
  • Decryption from RSA encrypted string from sqlite is not the same
  • need of maximum value in int
  • a list of several tuples, how to extract the same of the first two elements in the small tuple in the large tuple
  • Display image of 2D Sinewaves in 3D
  • how to prevent a for loop from overwriting a dictionary?
  • How To Fix: RuntimeError: size mismatch in pyTorch
  • Concatenating two Pandas DataFrames while maintaining index order
  • Why does this not run into an infinite loop?
  • Python Multithreading no current event loop
  • Element Tree - Seaching for specific element value without looping
  • Ignore Nulls in pandas map dictionary
  • How do I get scrap data from web pages using beautifulsoup in python
  • Variable used, golobal or local?
  • I have a regex statement to pull all numbers out of a text file, but it only finds 77 out of the 81 numbers in the file
  • How do I create a dataframe of jobs and companies that includes hyperlinks?
  • Detect if user has clicked the 'maximized' button
  • Does flask_login automatically set the "next" argument?
  • Indents in python 3
  • How to create a pool of threads
  • Pandas giving IndexError on one dataframe but not on another similar dataframe
  • Django Rest Framework - Testing client.login doesn't login user, ret anonymous user
  • Running dag without dag file in airflow
  • Filling across a specified dimension of a numpy array
  • Python populating dataframe in pandas from text files
  • How to interpolate a single ("non-piecewise") cubic spline from a set of data points?
  • Divide 2 integers (leetcode 29) - recursion issue
  • Can someone explain why do I get this output in Python?
  • How do I scrape pdf and html from search results without obvious url
  • Is there a way to automatically make a "collage" of plots with matplotlib?
  • How to combine multiple rows in pandas with shared column values
  • How do I get LOAD_CLASSDEREF instruction after dis.dis?
  • Django - How to add items to Bootstrap dropdown?
  • Linear Regression - Does the below implementation of ridge regression finding coefficient term using gradient method is
  • How to drop all rows in pandas dataframe with negative values?
  • Most Efficient Way to Find Closest Date Between 2 Dataframes
  • Execution error when Passing arguments to a python script using os.system. The script takes sys.argv arguments
  • Looping through a function
  • Create a plot for each unique ID
  • a thread python with 'while' got another thread never start
  • Solution from SciPy solve_ivp contains oscillations for a system of first-order ODEs
  • trigger python events driven by selenium controlled browser
  • Passing line-edits to a contextmanager to set validators
  • Python: globals().items() iterations try to change a dict
  • Is it possible to specify starting values for each parameter (instead of bounds) for scipy's differential evolution?
  • shadow
    Privacy Policy - Terms - Contact Us © scrbit.com