擅长:python、mysql、java
<p>让我们创建图像的数据帧并提取id</p>
<pre><code>from pathlib import Path
img_df = pd.DataFrame({'img' : [i.stem for i Path(your_images).glob('*.jpg')]})
img_df['ID'] = img_df['imgs'].astype(str).str.split('_',expand=True)[1].astype(int)
img_dfg = img_df.groupby('ID',as_index=False).agg(list)
ID imgs
0 10000 [leaflet_10000_1.jpg, leaflet_10000_2.jpg]
1 10001 [leaflet_10001_1.jpg, leaflet_10001_2.jpg]
2 10002 [leaflet_10002_1.jpg, leaflet_10002_2.jpg]
3 10003 [leaflet_10003_1.jpg, leaflet_10003_2.jpg]
</code></pre>
<p>然后我们只需要合并ID列</p>
<pre><code>df_merged = pd.merge(df,img_dfg,on='ID',how='left')
</code></pre>
<p>然后,您可以执行任何进一步的操作来分组或列出图像</p>