问题

correctlist = []
originallist = [{location:1, mgr:'Joe', region:'Frank'}, {location:2, mgr:'Sam', region:'Jess'}, {location:3, mgr:'Joe', region:'Frank'}, {location:4, mgr:'Sue', region:'Frank'}, {location:5, mgr:'Susan', region:'Jess'}]

# Should end up as [{location:1, mgr:'Joe', region:'Frank'}, {location:3, mgr:'Joe', region:'Frank'}, {location:4, mgr:'Sue', region:'Frank'}, {location:2, mgr:'Sam', region:'Jess'}, {location:5, mgr:'Susan', region:'Jess'}]

sortedlist = sorted(originallist, key=lambda k: (k['location']))

while sortedlist:
    for location in sortedlist:
        currregion = location['region']
        currmgr = location['mgr']
        for loc in sortedlist:
            if loc['region'] == currregion and loc['mgr'] == currmgr:
                correctlist.append(loc)
                sortedlist.remove(loc)
        for loc in sortedlist:
            if loc['region'] == currregion:
                currmgr = loc['mgr']
        for loc in sortedlist:
            if loc['mgr'] == currmgr and loc['region'] == currregion:
                correctlist.append(loc)
                sortedlist.remove(loc)

英文:

I have a list that's essentially [{location:1, mgr:'Joe', region:'Frank'}, {location:2, mgr:'Sam', region:'Jess'}, {location:3, mgr:'Joe', region:'Frank'}, {location:4, mgr:'Sue', region:'Frank'}, {location:5, mgr:'Susan', region:'Jess'}]. I need to get it into an order where the mgrs and regions are sorted by who has the lowest location number first but then grouped together. The mgrs and regions are names with no specific order except that their entries have to be together and the numbers correspond to specific locations, so they will never repeat,etc.

So the example should end up as:

"[{location:1, mgr:'Joe', region:'Frank'},{location:3, mgr:'Joe', region:'Frank'}, {location:4, mgr:'Sue', region:'Frank'}, {location:2, mgr:'Sam', region:'Jess'}, {location:5, mgr:'Susan', region:'Jess'}]"

Format doesn't really matter as I just need the locations in a correctly ordered list at the end. I haven't been able to find any similar examples and am struggling to figure out a way to approach this that isn't really convoluted (or even works).

I've tried a ton of different versions of this but my general thought was to iterate through and move entries to another list in the correct order. I've gotten close but there have still been entries not in the correct order. I also tried to sort with additional keys but kept running into issues with it sorting alphabetically or solely by the locations.

    correctlist = []
    originallist = [{location:1,mgr:&#39;Joe&#39;,region:&#39;Frank&#39;},{location:2,mgr:&#39;Sam&#39;,region:&#39;Jess&#39;},{location:3,mgr:&#39;Joe&#39;,region:&#39;Frank&#39;},{location:4, mgr:&#39;Sue&#39;, region:&#39;Frank&#39;},{location:5, mgr:&#39;Susan&#39;, region:&#39;Jess&#39;}]

#Should end up as [{location:1,mgr:&#39;Joe&#39;,region:&#39;Frank&#39;},{location:3,mgr:&#39;Joe&#39;,region:&#39;Frank&#39;},{location:4, mgr:&#39;Sue&#39;, region:&#39;Frank&#39;},{location:2,mgr:&#39;Sam&#39;,region:&#39;Jess&#39;},{location:5, mgr:&#39;Susan&#39;, region:&#39;Jess&#39;}]

    sortedlist = sorted(originallist, key=lambda k: (k[&#39;location&#39;]))

    while sortedlist:
        for location in sortedlist:
            currregion = location[&#39;region&#39;]
            currmgr = location[&#39;mgr&#39;]
            for locationin sortedlist:
                if location[&#39;region&#39;] == currregion and location[&#39;mgr&#39;] == currmgr:
                    correctlist.append(number)
                    sortedlist.remove(number)
            for location in sortedlist:
                if location[&#39;region&#39;] == curregion:
                    currmgr = location[&#39;mgr&#39;]
            for locationin sortedlist:
                if location[&#39;mgr&#39;] == currmgr and location[&#39;region&#39;] == curregion:
                    correctlist.append(location)
                    sortedlist.remove(location)

答案1

得分: 0

以下是您要的代码翻译：

# 最佳和简单的方法来在Python中将元素分组在一起通常是使用一个字典的列表。

# 当我们将所有东西都很好地分组在区域的子列表和经理的子子列表中时，我们可以对每个子子列表进行排序，然后对每个子列表进行排序。

# 如果每个经理的子子列表都按位置排序，那么最低位置将在其第一个元素中，因此我们可以通过查看每个经理的子子列表的第一个元素的位置来对经理的子子列表进行排序。

# 然后，我们可以将经理的子子列表链接在一起，表示区域的排序子列表。

# 然后，每个区域子列表都进行排序，因此其最低位置将在其第一个元素中，因此我们可以通过查看每个区域子列表的第一个元素的位置来对区域子列表的列表进行排序。

# 然后，我们可以将所有子列表链接在一起，形成一个排序后的列表。

from itertools import chain

originallist = [{'location': 1, 'mgr': 'Joe', 'region': 'France'},
               {'location': 2, 'mgr': 'Sam', 'region': 'Japan'},
               {'location': 3, 'mgr': 'Joe', 'region': 'France'},
               {'location': 4, 'mgr': 'Sue', 'region': 'France'},
               {'location': 5, 'mgr': 'Susan', 'region': 'Japan'}]

# 我将'Franck'替换为'France'，'Jessica'替换为'Japan'，以避免区域和经理之间的混淆。

def grouped_by_region(originallist):
    regions = {}
    for lmr in originallist:
        regions.setdefault(lmr['region'], []).append(lmr)
    return regions

def grouped_by_mgr(region):
    by_mgr = {}
    for lmr in region:
        by_mgr.setdefault(lmr['mgr'], []).append(lmr)
    return by_mgr

def sorted_by_region_mgr_location(originallist):
    regions = grouped_by_region(originallist)
    for region_name, region in regions.items():
        by_mgr = grouped_by_mgr(region)
        for group in by_mgr.values():
            group.sort(key=lambda lmr: lmr['location'])  # 在每个经理组内排序
        sorted_groups = sorted(by_mgr.values(), key=lambda group: group[0]['location'])  # 在每个区域内排序经理
        regions[region_name] = list(chain.from_iterable(sorted_groups))
    return list(chain.from_iterable(sorted(regions.values(), key=lambda region: region[0]['location']))

print(sorted_by_region_mgr_location(originallist))

结果：

[{'location': 1, 'mgr': 'Joe', 'region': 'France'},
 {'location': 3, 'mgr': 'Joe', 'region': 'France'},
 {'location': 4, 'mgr': 'Sue', 'region': 'France'},
 {'location': 2, 'mgr': 'Sam', 'region': 'Japan'},
 {'location': 5, 'mgr': 'Susan', 'region': 'Japan'}]

英文:

The best and simple way to group elements together in python is usually to use a dict of lists.

When we have grouped everything nicely in sublists of regions and subsublists of managers, we can sort each subsublist and then each sublist.

If each manager's subsublist is sorted by location, then the lowest location is going to be in its first element, so we can sort the sublist of manager's subsublists by looking at the location of the first element of each manager's subsublist.

Then we can chain the manager's subsublists together into a sorted sublist representing the region.

Then each region sublist is sorted, so its lowest location is going to be in its first element, so we can sort the list of region sublists by looking at the location of the first element of each region sublist.

Then we can chain all the sublists together into a sorted list.

from itertools import chain

originallist = [{&#39;location&#39;:1,&#39;mgr&#39;:&#39;Joe&#39;,&#39;region&#39;:&#39;France&#39;},{&#39;location&#39;:2,&#39;mgr&#39;:&#39;Sam&#39;,&#39;region&#39;:&#39;Japan&#39;},{&#39;location&#39;:3,&#39;mgr&#39;:&#39;Joe&#39;,&#39;region&#39;:&#39;France&#39;},{&#39;location&#39;:4, &#39;mgr&#39;:&#39;Sue&#39;, &#39;region&#39;:&#39;France&#39;},{&#39;location&#39;:5, &#39;mgr&#39;:&#39;Susan&#39;, &#39;region&#39;:&#39;Japan&#39;}]
# I replaced &#39;Franck&#39; with &#39;France&#39; and &#39;Jessica&#39; with &#39;Japan&#39; to avoid confusiong between regions and managers

def grouped_by_region(originallist):
    regions = {}
    for lmr in originallist:
        regions.setdefault(lmr[&#39;region&#39;], []).append(lmr)
    return regions

# print(grouped_by_region(originallist))
## {&#39;France&#39;: [{&#39;location&#39;: 1, &#39;mgr&#39;: &#39;Joe&#39;, &#39;region&#39;: &#39;France&#39;}, {&#39;location&#39;: 3, &#39;mgr&#39;: &#39;Joe&#39;, &#39;region&#39;: &#39;France&#39;}, {&#39;location&#39;: 4, &#39;mgr&#39;: &#39;Sue&#39;, &#39;region&#39;: &#39;France&#39;}],
##  &#39;Japan&#39;: [{&#39;location&#39;: 2, &#39;mgr&#39;: &#39;Sam&#39;, &#39;region&#39;: &#39;Japan&#39;}, {&#39;location&#39;: 5, &#39;mgr&#39;: &#39;Susan&#39;, &#39;region&#39;: &#39;Japan&#39;}]}

def grouped_by_mgr(region):
    by_mgr = {}
    for lmr in region:
        by_mgr.setdefault(lmr[&#39;mgr&#39;], []).append(lmr)
    return by_mgr

# regions = grouped_by_region(originallist)
# print(grouped_by_mgr(regions[&#39;France&#39;]))
## {&#39;Joe&#39;: [{&#39;location&#39;: 1, &#39;mgr&#39;: &#39;Joe&#39;, &#39;region&#39;: &#39;France&#39;}, {&#39;location&#39;: 3, &#39;mgr&#39;: &#39;Joe&#39;, &#39;region&#39;: &#39;France&#39;}], &#39;Sue&#39;: [{&#39;location&#39;: 4, &#39;mgr&#39;: &#39;Sue&#39;, &#39;region&#39;: &#39;France&#39;}]}

## PUTTING IT ALL TOGETHER
def sorted_by_region_mgr_location(originallist):
    regions = grouped_by_region(originallist)
    for region_name, region in regions.items():
        #print(&#39;\nregion: &#39;, region_name)
        by_mgr = grouped_by_mgr(region)
        #print(&#39;grouped by mgr: &#39;, by_mgr)
        for group in by_mgr.values():
            group.sort(key=lambda lmr: lmr[&#39;location&#39;])  # sort within each manager group
        sorted_groups = sorted(by_mgr.values(), key=lambda group: group[0][&#39;location&#39;])  # sort managers within each region
        #print(&#39;sorted groups: &#39;, sorted_groups)
        regions[region_name] = list(chain.from_iterable(sorted_groups))
        #print(&#39;final list: &#39;, regions[region_name])
    #print(&#39;\n\nregions before chaining: &#39;, regions)
    return list(chain.from_iterable(sorted(regions.values(), key=lambda region: region[0][&#39;location&#39;])))

print(
    sorted_by_region_mgr_location(originallist)
)

Result:

[{&#39;location&#39;: 1, &#39;mgr&#39;: &#39;Joe&#39;, &#39;region&#39;: &#39;France&#39;}, {&#39;location&#39;: 3, &#39;mgr&#39;: &#39;Joe&#39;, &#39;region&#39;: &#39;France&#39;}, {&#39;location&#39;: 4, &#39;mgr&#39;: &#39;Sue&#39;, &#39;region&#39;: &#39;France&#39;}, {&#39;location&#39;: 2, &#39;mgr&#39;: &#39;Sam&#39;, &#39;region&#39;: &#39;Japan&#39;}, {&#39;location&#39;: 5, &#39;mgr&#39;: &#39;Susan&#39;, &#39;region&#39;: &#39;Japan&#39;}]

通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。

如何在Python中按多个条件对项目进行排序？

问题

答案1

如何在Python中加载数据集并处理它，而不会超出内存限制？

如何解决Qt5应用程序的“无法初始化Qt平台插件”问题？

获取Azure Monitor的特定警报，使用Python。

如何更改 Visual Studio Code 中默认的虚拟环境命令？

What's the correct way to type hint an empty list as a literal in python?

如何在Highcharts Gantt中更改本地化的星期名称

如何在同一个流中使用多个过滤器和映射函数？

如何使用Map/Set来将代码优化到O(n)？

.NET MAUI Android在GitHub Actions上构建失败，错误代码为1。

如何在Playwright视觉比较中屏蔽多个定位器？

在C++中，可以使用可变模板参数来检索类型的内部类型。

selenium.common.exceptions.StaleElementReferenceException: Message: stale element reference: stale element not found

Creating and opening a URL to log in to Website via Basic Auth with Robot Framework/Selenium (Python)

AG Grid 在上下文菜单中以大文本形式打开

发表评论