How can I divide the query results into several objects by using one column with Python?

edit

You can use Python's groupby() function to group the query results by a specific column. Here's an example:

Assuming you have a list of dictionaries, where each dictionary represents a row from the query results:

query_results = [
    {'id': 1, 'name': 'John', 'age': 25},
    {'id': 2, 'name': 'Jane', 'age': 30},
    {'id': 3, 'name': 'Bob', 'age': 25},
    {'id': 4, 'name': 'Sue', 'age': 30}
]

If you want to group the results by age, you can use the following code:

from itertools import groupby

query_results.sort(key=lambda x: x['age'])

grouped_results = {}
for key, group in groupby(query_results, lambda x: x['age']):
    grouped_results[key] = list(group)

print(grouped_results)

This will produce the following output:

{
    25: [
        {'id': 1, 'name': 'John', 'age': 25},
        {'id': 3, 'name': 'Bob', 'age': 25}
    ],
    30: [
        {'id': 2, 'name': 'Jane', 'age': 30},
        {'id': 4, 'name': 'Sue', 'age': 30}
    ]
}

In this example, the query results are first sorted by age using lambda function. The groupby() function from itertools is then used to group the results by age, creating a dictionary where each key is the age and the value is a list of objects with that age.