从列表结构的字典中提取数据

Question

我有格式为s.t的结构化数据。

('["02100 - Albuquerque", "21: Mining", "2015", "1stqtr"]',
[6377340.58, 1783304.5, 124831.3, 0, 0]),

('["02200 - Los Ranchos de Albuquerque", "21: Mining", "2015", "1stqtr"]',
['*', '*', '*', '*', '*']),

('["03003 - Eddy County, Remainder", "21: Mining", "2015", "1stqtr"]',
[180120046.18, 113335033.42, 6518842.46, 0, 0]),

('["03106 - Carlsbad", "21: Mining", "2015", "1stqtr"]',
[31013031.93, 22417664.82, 1640017.58, 0, 0]),

('["02100 - Albuquerque", "21: Mining", "2015", "2ndqtr"]',
[7791546.64, 2305762.85, 161737.54, 0, 0]),

('["02200 - Los Ranchos de Albuquerque", "21: Mining", "2015", "2ndqtr"]',
['*', '*', '*', '*', '*']),

('["03003 - Eddy County, Remainder", "21: Mining", "2015", "2ndqtr"]',
[131428830.21, 78906981.18, 4529132.1, 0, 0]),

('["03106 - Carlsbad", "21: Mining", "2015", "2ndqtr"]',
[41144494.15, 28958781.08, 2158603.95, 0, 0]),

当我使用这个函数时

def search_and_export(dictionary, substr):
result = []
for key in dictionary:
    if substr in key:
        result.append((key, dictionary[key]))
        print("")
        print("This is the key: " + key)
        print(“")

我出去了：

This is the key: ["02100 - Albuquerque", "21: Mining", "2015", “1stqtr”] 
etc...

我想要做的是定义一个函数，它允许我在字典中进行搜索，并且只允许我查找

('["02100 - Albuquerque”, "21: Mining”, “2015", “1stqtr"]', [6377340.58])
('["02100 - Albuquerque", "21: Mining", "2015", "2ndqtr"]’, [7791546.64])

然后将该值导出到csv中，文件名分别为"02100 - Albuquerque / 21: Mining / 2015 /1stqtr“和"02100 - Albuquerque / 21: Mining / 2015 /2ndtqtr”

Answer 1

找到了解决这个问题的办法。非常简单。我这么做是为了阿尔伯克基。现在只需要做一个简单的导出到csv。

def search_and_export(dictionary):

for key, value in dictionary.items():
    if "02100 - Albuquerque" in key:
        if "21: Mining" in key:

            print("")
            print("This is the key: " + key)
            print("This is the value: " + str(value[0]))
            print("")


pprint(search_and_export(dataDict))

输出

这是关键字："02100 -阿尔伯克基“，"21:正在挖掘”，“2015年”，"1stqtr“这是值: 180120046.18这是关键字："02100 -阿尔伯克基”，"21:正在挖掘“，"2015"，"2ndqtr”这是值: 131428830.21是关键字："02100 -阿尔伯克基“，"21:正在挖掘”，"2015"，"3rdqtr“这是值: 99306332.26这是关键字："02100 -阿尔伯克基”，"21:挖掘“，"2015"，"4thqtr”取值: 122534519.98