如何使用多个对象循环通过JSON数据

Question

我的json文件data.json看起来

[
{"host" : "192.168.0.25", "username":"server2", "path":"/home/server/.ssh/01_id"},
{"host" : "192.168.0.26", "username":"server3", "path":"/home/server/.ssh/01_id"}
]

我想以这种方式发生循环（让我们忽略远程变量）

for remotes,host,username in zip(remote , data["host"] ,data["username"]):

这是我遇到的错误

    for remotes,host,username in list(zip(remote , data["host"] ,data["username"])):
TypeError: list indices must be integers or slices, not str

Answer 1

您需要迭代数据以提取host和用户名值，以便您可以zip它们到远程>远程列表：

data = [
 {"host" : "192.168.0.25", "username":"server2", "path":"/home/server/.ssh/01_id"},
 {"host" : "192.168.0.26", "username":"server3", "path":"/home/server/.ssh/01_id"}
]
hosts_users = [(d['host'], d['username']) for d in data]
remote = [1, 2]

for remote, (host, username) in zip(remote, hosts_users):
    print(remote, host, username)

输出：

1 192.168.0.25 server2
2 192.168.0.26 server3

Answer 2

如果您有JSON首先需要阅读，则可以将数据操纵为Python对象

import json

with open("data.json") as json_file:
    data = json.load(json_file)

for d in data:
    host = d['host']
    username = d['username']
    path = d['path']
    print(host, username, path)

Answer 3

您可以使用 map 与 zip 喜欢

# uncomment following code if data reside in json
# import json
# file = open('path_of_your_json')
# data = json.load(file)

data = [
    {"host" : "192.168.0.25", "username":"server2", "path":"/home/server/.ssh/01_id"},
    {"host" : "192.168.0.26", "username":"server3", "path":"/home/server/.ssh/01_id"}
]

for (host, username, path) in zip(*zip(*map(lambda x: x.values(), data))): 
   print(host, username, path)   
   # whatever you want

zip（*zip（*map（lambda x：x.values（），data）））该行将以线性方式提供数据

Answer 4

由于您特别提到了使用Zip列Wise遍历数据，因此您可以做到这一点。

说json文件名是如此。json

在变量数据中加载JSON对象。

import json
f = open(r'C:\Users\YYName\Desktop\Temp\SO.json')
data = json.load(f)

现在，您可以使用zip和列遍地遍历这些值。将JSON数据加载到PANDAS数据框架中。

import pandas as pd
df = pd.DataFrame(data)
for host,username in zip(df["host"] ,df["username"]):
    print(host, username)

假设遥控器的长度与JSON中的行数相同。你现在可以做

for remotes,host,username in zip(remote , df["host"] ,df["username"]):
    print(remotes, host, username)