擅长:python、mysql、java
<p>希望这有助于:</p>
<pre><code>metadata = [
[{'id': 0, 'imageUrl': 'http://example.com/images/41dY3ASVn7L.jpg', 'score': 54.09280014038086},
{'id': 0, 'imageUrl': 'http://example.com/images/41dY3ASVn7L.jpg', 'score': 54.09280014038086}],
[{'id': 0, 'imageUrl': 'http://example.com/images/31mnLrB5IHL.jpg' ,'score': 99.902099609375},
{'id': 0, 'imageUrl': 'http://example.com/images/31mnLrB5IHL.jpg', 'score': 99.902099609375}],
[{'id': 0, 'imageUrl': 'http://example.com/images/4189TDx0e0L.jpg' ,'score': 97.33160400390625},
{'id': 0, 'imageUrl': 'http://example.com/images/4189TDx0e0L.jpg', 'score': 97.33160400390625}]
]
# Extract metadata into dataframe
df = pd.DataFrame([a[0] for a in metadata])
# List of filenames NOTE: added last file so match is found
fnList = ["41456gn7L.jpg","31mndfg.jpg","dsfsdf8587eh.jpg","31mnLrB5IHL.jpg"]
# show DF
print(df)
print("\n \n Matching Filename\n")
# Generate list of matching scores
for f in fnList:
try: v = df[df.imageUrl.str.contains(f)]['score'].iloc[0]
except: v = None
print(f, v)
</code></pre>