【Python】 list dict数据合并汇总demo

moduwusuowei

【Python】 list dict数据合并汇总demo需求：

• 将列表a,根据company进行分类，同一个company的id放到一个列表里面数据：
  

a = [{
       "id": 214,
       "company": "CN920A"
     },
     {
       "id": 225,
       "company": "CN920A"
     },
     {
       "id": 239,
       "company": "CN920A"
     },
     {
       "id": 226,
       "company": "CN920E"
     },
     {
       "id": 236,
       "company": "CN920E"
     },
     {
       "id": 194,
       "company": "CN920E"
     },
     {
       "id": 193,
       "company": "CN930D"
     },
     {
       "id": 192,
       "company": "CN930D"
     },
     {
       "id": 191,
       "company": "CN940F"
     },
     {
       "id": 190,
       "company": "CN940F"
     }
     ]代码： def data_merge(a):
     classified_case_sensitive = {}
​
     for item in a:
         company = item['company']
         item_id = item['id']
​
         if company not in classified_case_sensitive:
             classified_case_sensitive[company] = []
​
         classified_case_sensitive[company].append(item_id)
     print(classified_case_sensitive)
​
​
if __name__ == '__main__':
     data_merge(a)结果：

{'CN920A': [214, 225, 239], 'CN920E': [226, 236, 194], 'CN930D': [193, 192], 'CN940F': [191, 190]}

CIBao

你是否在寻找 pandas

import pandas as pd

# 原始数据
a = [
    {"id": 214, "company": "CN920A"},
    {"id": 225, "company": "CN920A"},
    {"id": 239, "company": "CN920A"},
    {"id": 226, "company": "CN920E"},
    {"id": 236, "company": "CN920E"},
    {"id": 194, "company": "CN920E"},
    {"id": 193, "company": "CN930D"},
    {"id": 192, "company": "CN930D"},
    {"id": 191, "company": "CN940F"},
    {"id": 190, "company": "CN940F"}
]

# 将数据转换为 DataFrame
df = pd.DataFrame(a)

# 按 company 进行分组，并将相同 company 的 id 放到一个列表中
result = df.groupby('company')['id'].apply(list).reset_index()

# 输出最终结果
print(result)

  company              id
0  CN920A  [214, 225, 239]
1  CN920E  [226, 236, 194]
2  CN930D       [193, 192]
3  CN940F       [191, 190]

141442478

[Python] 纯文本查看 复制代码

?

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

from collections import defaultdict   # 原始数据 a = [     {"id": 214, "company": "CN920A"},     {"id": 225, "company": "CN920A"},     {"id": 239, "company": "CN920A"},     {"id": 226, "company": "CN920E"},     {"id": 236, "company": "CN920E"},     {"id": 194, "company": "CN920E"},     {"id": 193, "company": "CN930D"},     {"id": 192, "company": "CN930D"},     {"id": 191, "company": "CN940F"},     {"id": 190, "company": "CN940F"} ]     def data_merge(data):     classified_case_sensitive = defaultdict(list)     for item in data:         classified_case_sensitive[item['company']].append(item['id'])     print(classified_case_sensitive)     if __name__ == '__main__':     data_merge(a)

vethenc

我帮楼上排个版

from collections import defaultdict

# 原始数据
a = [
    {"id": 214, "company": "CN920A"},
    {"id": 225, "company": "CN920A"},
    {"id": 239, "company": "CN920A"},
    {"id": 226, "company": "CN920E"},
    {"id": 236, "company": "CN920E"},
    {"id": 194, "company": "CN920E"},
    {"id": 193, "company": "CN930D"},
    {"id": 192, "company": "CN930D"},
    {"id": 191, "company": "CN940F"},
    {"id": 190, "company": "CN940F"}
]

def data_merge(data):
    classified_case_sensitive = defaultdict(list)
    for item in data:
        classified_case_sensitive[item['company']].append(item['id'])
    print(classified_case_sensitive)

if __name__ == '__main__':
    data_merge(a)

wkdxz

我加两个不规范数据进去捣乱

[Python] 纯文本查看 复制代码

?

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

a = [     {"id": 214, "company": "CN920A"},     {"id": 225, "company": "CN920A"},     {"id": 239, "company": "CN920A"},     {"id": 226, "company": "CN920E"},     {"id": 236, "company": "CN920E"},     {"id": 194, "company": "CN920E"},     {"id": 193, "company": "CN930D"},     {"id": 192, "company": "CN930D"},     {"id": 191, "company": "CN940F"},     {"id": 190, "company": "CN940F"},     {"id": 9527},     {"company": "TTTTTT"} ]   new_dic = {}   for single_dic in a:       the_company = single_dic.get('company')     the_id = single_dic.get('id')       if the_company and the_id:         if the_company in new_dic:             new_dic[the_company].append(the_id)         else:             new_dic[the_company] = [the_id]   print(new_dic)