批量读取 excel 内相似图片搜索

fish b41c421751 Automatic Commit By liuyuqi 1 week ago
docs c67e0fed8c Automatic Commit By liuyuqi 1 week ago
static c67e0fed8c Automatic Commit By liuyuqi 1 week ago
templates c67e0fed8c Automatic Commit By liuyuqi 1 week ago
test b41c421751 Automatic Commit By liuyuqi 1 week ago
uploads c67e0fed8c Automatic Commit By liuyuqi 1 week ago
utils c67e0fed8c Automatic Commit By liuyuqi 1 week ago
.gitignore c67e0fed8c Automatic Commit By liuyuqi 1 week ago
README.md 4b05244efb Automatic Commit By liuyuqi 1 week ago
__init__.py c67e0fed8c Automatic Commit By liuyuqi 1 week ago
app.py c67e0fed8c Automatic Commit By liuyuqi 1 week ago
config.py c67e0fed8c Automatic Commit By liuyuqi 1 week ago
models.py b41c421751 Automatic Commit By liuyuqi 1 week ago
poetry.lock c67e0fed8c Automatic Commit By liuyuqi 1 week ago
pyproject.toml c67e0fed8c Automatic Commit By liuyuqi 1 week ago
requirements.txt c67e0fed8c Automatic Commit By liuyuqi 1 week ago
routes.py c67e0fed8c Automatic Commit By liuyuqi 1 week ago

README.md

flask_image_matcher

excel 相似图片搜索

alt text

alt text

Usage

python app.py

访问 http://127.0.0.1:5000/ 选择图片,设置文件目录,设置相似度,设置时间标签,点击开始匹配按钮,批量搜索指定目录的文件(excel,doc),搜索文件中的图片,找到指定图片所在文件位置。

技术栈

  • flask 封装UI
  • 图片计算相似度:

    from skimage.metrics import structural_similarity as ssim
    
    score, _ = ssim(grayA, grayB, full=True)
    

注意这里把彩色是3层数组改为灰色1层。

  • 读取excel openpyxl

  • 读取 word docx

Reference

License