Django将两个字典列表中的公共值合并在一起

Question

我有两个字典列表，示例如下：

list one = [
  {'day': '2021-09-05 00:00:00+02:00', 'airtime_total_for_day': '650.00', 'data_total_for_day': '0'},
  {'day': '2021-09-16 00:00:00+02:00', 'airtime_total_for_day': '124.20', 'data_total_for_day': '20.00'},
]

list_two = [
  {'day': '2021-09-10 00:00:00+02:00', 'data_bundle_total_for_day': '100.00'},
  {'day': '2021-09-16 00:00:00+02:00', 'data_bundle_total_for_day': '50.00'},
  {'day': '2021-09-18 00:00:00+02:00', 'data_bundle_total_for_day': '45.00'},
]

我想将这两个列表合并在一起，同时将data_total_for_day与data_bundle_total_for_day合并在data_total_for_day的名称下

此外，如果data_total_for_day&data_bundle_total_for_day恰好落在2021-09-16的同一天，需要将这些值相加，例如

• ^在2021-09-16上的{}是：20.00
• ^在2021-09-16上的{}是：50.00

所以在特定的天，data_total_for_day需要：70.00

我一直在挣扎，一切&；非常感谢您对我们的任何帮助

我尝试过的事情：

• https://www.codegrepper.com/code-examples/python/merge+two+list+of+dictionaries+python
• How to merge two list of dictionaries based on a value
• join two lists of dictionaries on a single key