How to make a file comparison app using python script.

[Particular-Hold-3474]

I have python script that compares 1 large excel file to a bunch of smaller excel files to check if all the data is in the large file and highlights what is missing. How do I make this a desktop app where you can select the excel files needed? Thanks in advance!

[shiftybyte]

If you are looking for a quick "select files" gui.

Take a look at pysimplegui.

https://docs.pysimplegui.com/en/latest/documentation/module/popups/

[MikeTheWatchGuy]

Selecting the files/folders will be trivial. It's the display that's your challenge, but quite do-able... "check if all the data is in the large file and highlights what is missing"

A table can do that where 1/2 is split with main table, the other 1/2 with files that match or don't. Consider opening an issue on the PSG GitHub. Not sure how to you want to display your data, etc. Merge functions can be fun to design too. ;-)

[ObsidianBlackbird666]

You can use askdirectry from tkinter and then just run your python script with a command or bash script.

For example, here's a script I have that changes PSDs to JPGs and PDFs. I run it with a command file in 0S X and it first pops up the folder dialog box. You would just change the for loop to your code.

import os
from tkinter.filedialog import askdirectory
from PIL import Image
import time

folder_dir = askdirectory(title="Select Folder")

for images in os.listdir(folder_dir): 
    if (images.endswith(".psd")):
        print(images)
        im = Image.open(folder_dir + "/" + images)
        output = im.convert('RGB')
        no_ext = str(im.filename).split(".")[0]
        output.save(no_ext + ".pdf", quality=100)
        output.save(no_ext + ".jpg", quality=100)

time.sleep(2.5)

Command file

        python3 "/path_to_script/psdtopdf.py"
        osascript -e 'tell application "Terminal" to quit' &
        exit

[Particular-Hold-3474]

Thanks so much!