擅长:python、mysql、java
<p>非熊猫解决方案:</p>
<pre><code>import pandas as pd
json1 = {"key":["1111","2222","3333","4444"],
"Value":["Y","N","Y","N"],
"identifier":[1,1,2,1]
}
json2 = {"ID" : ["1111","2222","5555","4444"],
"name" : ["SRI","Ravi","kavitha","power"],
"address":["Guntur","Medikonduru","Goa","SAP"],
"zip":[522438,522238,789889,827736],
"mobile":[999999,888888,777777,666666]
}
result = {}
include = []
for key_index in range(0,len(json1["key"])):
if json1["key"][key_index] in json2["ID"]:
include.append(key_index)
for key in json1.keys():
result[key] = [json1[key][i] for i in include]
for key in json2.keys():
result[key] = [json2[key][i] for i in include]
print(pd.DataFrame(result))
</code></pre>