<p>我认为这不是最好的办法。但这是解决办法</p>
<pre><code>s={
"Functions": [
{
"CodeSha256": "",
"CodeSize": "",
"Description": "",
"Environment": {
"Variables": {
"COMMIT_HASH": "test",
"CodeSha256": "",
"ECS_LOG_STREAM": "",
"ELASTIC_SEARCH_DOMAIN_ENDPOINT": "",
"ENVIRONMENT": "prod",
"SERVICE_NAME": "testingservicename",
"SERVICE_OWNER": "testingserviceowner",
}
},
"FunctionName": "demofunctionname",
"Timeout": "" ,
"TracingConfig": {
"Mode": ""
},
"Version": "",
"VpcConfig": {
"SecurityGroupIds": [
""
],
"SubnetIds": [
"",
"",
""
],
"VpcId": ""
}
}
] }
import pandas as pd
import json
s = json.dumps(s)
data = json.loads(s)
result={'FunctionName': data["Functions"][0]["FunctionName"], 'COMMIT_HASH': data["Functions"][0]["Environment"]["Variables"]["COMMIT_HASH"], 'SERVICE_OWNER': data["Functions"][0]["Environment"]["Variables"]["SERVICE_OWNER"]}
df = pd.DataFrame(data= [result])
print(df)
</code></pre>
<p>注意:我认为你的json有一些问题,我已经在我的解决方案中解决了</p>
<h4 id="edit-version-e6z9">编辑版本</h4>
<p>下面是多个“函数”的代码</p>
<pre><code>s={
"Functions": [
{
"CodeSha256": "",
"CodeSize": "",
"Description": "",
"Environment": {
"Variables": {
"COMMIT_HASH": "test",
"CodeSha256": "",
"ECS_LOG_STREAM": "",
"ELASTIC_SEARCH_DOMAIN_ENDPOINT": "",
"ENVIRONMENT": "prod",
"SERVICE_NAME": "testingservicename",
"SERVICE_OWNER": "testingserviceowner",
}
},
"FunctionName": "demofunctionname",
"Timeout": "" ,
"TracingConfig": {
"Mode": ""
},
"Version": "",
"VpcConfig": {
"SecurityGroupIds": [
""
],
"SubnetIds": [
"",
"",
""
],
"VpcId": ""
}
},
{
"CodeSha256": "",
"CodeSize": "",
"Description": "",
"Environment": {
"Variables": {
"COMMIT_HASH": "test",
"CodeSha256": "",
"ECS_LOG_STREAM": "",
"ELASTIC_SEARCH_DOMAIN_ENDPOINT": "",
"ENVIRONMENT": "prod",
"SERVICE_NAME": "testingservicename",
"SERVICE_OWNER": "testingserviceowner",
}
},
"FunctionName": "demofunctionname 1",
"Timeout": "" ,
"TracingConfig": {
"Mode": ""
},
"Version": "",
"VpcConfig": {
"SecurityGroupIds": [
""
],
"SubnetIds": [
"",
"",
""
],
"VpcId": ""
}
}
]
}
import pandas as pd
import json
s = json.dumps(s)
data = json.loads(s)
function_name_list=[]
commit_hash_list=[]
service_owner_list=[]
for i in range(len(data["Functions"])):
function_name_list.append(data["Functions"][i]["FunctionName"])
commit_hash_list.append(data["Functions"][i]["Environment"]["Variables"]["COMMIT_HASH"])
service_owner_list.append(data["Functions"][i]["Environment"]["Variables"]["SERVICE_OWNER"])
result={'FunctionName': function_name_list, 'COMMIT_HASH': commit_hash_list, 'SERVICE_OWNER': service_owner_list}
df = pd.DataFrame(list(zip(function_name_list, commit_hash_list, service_owner_list)),
columns =['FunctionName', 'COMMIT_HASH', 'SERVICE_OWNER'])
print(df)
</code></pre>