选择性读取 JSON 对象

Question

假设我有这个JSON字符串(从 digitalocean.com 复制(

{ 
"sammy" : {
"username"  : "SammyShark",
"location"  : "Indian Ocean",
"online"    : true,
"followers" : 987
},
"jesse" : {
"username"  : "JesseOctopus",
"location"  : "Pacific Ocean",
"online"    : false,
"followers" : 432
},
"drew" : {
"username"  : "DrewSquid",
"location"  : "Atlantic Ocean",
"online"    : false,
"followers" : 321
},
"jamie" : {
"username"  : "JamieMantisShrimp",
"location"  : "Pacific Ocean",
"online"    : true,
"followers" : 654
}
}

我需要有选择地仅读取在名为位置的键中包含太平洋的对象/记录。我如何不能读取其他记录，例如以"印度洋"和"大西洋"作为位置值的记录？到目前为止，我能找到的所有示例都在整个文件中读取。

非常感谢您的帮助，甚至答案是"您只需要阅读整件事"！

Answer 1

如果你真的无法读取文件并切片，你可以循环进行

selective_data = ['Pacific Ocean']
batch = []
for k, v in data.items():
for ii, jj in v.items():
if jj in selective_data:
batch.append(v) 

df = pd.DataFrame(batch)

username       location  online  followers
0       JesseOctopus  Pacific Ocean   False        432
1  JamieMantisShrimp  Pacific Ocean    True        654