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

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

README.md

flask_image_matcher

excel 相似图片搜索

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