代码之家  ›  专栏  ›  技术社区  ›  Jordan

创建字典的python循环

  •  1
  • Jordan  · 技术社区  · 8 年前

    name variable level value

    下面是生成示例数据集的代码:

     Name = ['model1', 'model1', 'model1', 'model2', 'model2', 
    'model2','model1', 'model1', 'model1', 'model1', 'model2', 'model2', 
    'model2','model2']
     Variable = ['channel_model','channel_model','channel_model','channel_model','channel_model','channel_model', 'driver_age', 'driver_age', 'driver_age', 'driver_age', 
    'driver_age', 'driver_age', 'driver_age', 'driver_age']
    channel_Level = ['Dir', 'IA', 'EA','Dir', 'IA', 'EA', '21','22','23','24', '21','22','23','24']
    Value = [1.11,1.18,1.002, 2.2, 2.5, 2.56, 1.1,1.2,1.3,1.4,2.1,2.2,2.3,2.4]
    df= {'Name': Name, 'Variable': Variable, 'Level': channel_Level, 'Value':Value}
    factor_table = pd.DataFrame(df)
    

    Python Creating Dictionary from excel data

    import pandas as pd
    factor_table = pd.read_excel('...\\factor_table_example.xlsx')
    
    #define function to be used multiple times
    def factor_tables(file, model_column, variable_column, level_column, value_column):
        for i in file[model_column]:
            for row in file[variable_column]:
                lookup = {}
                lookup = dict(zip(file[level_column], file[value,column]))
    

    {{'model2':{'channel':{'EA':1.002, 'IA': 1.18, 'DIR': 1.11}}}, {'model1'::{'channel':{'EA':1.86, 'IA': 1.66, 'DIR': 1.64}}}}

    2 回复  |  直到 8 年前
        1
  •  1
  •   jpp    8 年前

    collections.defaultdict ,您可以在迭代数据帧时创建嵌套字典。然后通过列表理解重新排列成字典列表。

    from collections import defaultdict
    
    tree = lambda: defaultdict(tree)
    
    d = tree()
    for row in factor_table.itertuples(index=False):
        d[(row.Name, row.Variable)].update({row.Level: row.Value})
    
    res = [{k[0]: {k[1]: dict(v)}} for k, v in d.items()]
    
    print(res)
    
    [{'model1': {'channel_model': {'Dir': 1.110, 'EA': 1.002, 'IA': 1.180}}},
     {'model2': {'channel_model': {'Dir': 2.200, 'EA': 2.560, 'IA': 2.500}}},
     {'model1': {'driver_age': {'21': 1.100, '22': 1.200, '23': 1.300, '24': 1.400}}},
     {'model2': {'driver_age': {'21': 2.100, '22': 2.200, '23': 2.300, '24': 2.400}}}]
    
        2
  •  1
  •   C.Nivs    8 年前

    lookup = dict(zip(file[level_column], file[value,column]))
    

    在哪里? file value,column

    def factor_tables(file, model_column, variable_column, level_column, value_column):
        lookup = {}
    
        for i in file[model_column]:
    
            lookup[model_column] = dict(zip(file[level_column], file[value_column]))
    
        return lookup
    

    这将返回给您一个单独的字典,其中的键对应于单个(和唯一)模型:

    {'model_1':{'level_col': 'val_col'}, 'model_2':...}

    lookups.get('model_1') {'level_col': 'val_col'}

    如果你需要 variable_column

    def factor_tables(file, model_column, variable_column, level_column, value_column):
        lookup = {}
    
        for i in file[model_column]:
    
            lookup[model_column] = {variable_column: dict(zip(file[level_column], file[value_column]))}
    
        return lookup
    
    推荐文章