iterate over list of files & write information about them (including MIME type) to CSV

files.py

#!/usr/bin/env python3
import csv
import os
import subprocess

with open('files.csv', 'w') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerow(['path', 'size (bytes)', 'time last accessed', 'time last modified', 'time created', 'mime type'])
    with open('dbcheck-files.txt', 'r') as listfile:
        for path in listfile:
            path = path.strip()
            stat = os.stat(path)
            # python's mimetypes library only guesses based on file extension, not contents
            # so seems like UNIX `file` command is much more informative
            result = subprocess.run(['file', path], stdout=subprocess.PIPE, universal_newlines=True)
            mime = ''.join(result.stdout.split(': ')[1:])
            writer.writerow([path, stat.st_size, stat.st_atime, stat.st_mtime, stat.st_ctime, mime])