Anyone know any easy way to get a clip name and Total number of frames in vfx shots


Hello Friends

I am AK working as vfx coordinator every day I am
wasting lots of time to get total number of frames each individual video
clips to calculating Mandays excel, i have to create 1000 vfx shots
mandays men’s every time i am open all video one by one in quicklime
player and get frame count any one know easy way to get frame
information for all videos,

like automation tool, python scripting ,any software pls let me know if you know any easy way