擅长:python、mysql、java
<p>您可以使用下面的代码来查找结果</p>
<pre><code>import pandas as pd
json_1 = pd.DataFrame({"key":["1111","2222","3333","4444","5555"],
"value":["Y","N","Y","N","Y"],
"identifier":[1,2,1,2,1]
})
json_2 = pd.DataFrame({"id" : ["1111","2222","3333","4444","5555"],
"Name" : ["Sri","Ravi","Kavitha","Ramesh","Power"],
"Address":["Guntur","SAP","Vizag","Goa","Delhi"],
"Zip":[1,2,3,4,5],
"Mobile":[11,22,33,44,55]
})
json_2.join(json_1.set_index('key'), on='id')
</code></pre>