Use small Python scripts to handle repetitive file tasks.
Step by step, with examples
Scan subfolders and record file paths, extensions, sizes, and modification times in a table. Start with 4 small example files while keeping the originals and existing results intact.
Merge CSV files with the same column structure in order and add a source_file column. Use small datasets to check item names containing commas, missing columns, and existing output.
Compare old and new names in a table and check for conflicts. Only an explicit --apply creates copies in a new folder, keeping the originals.
Convert the data to a table while distinguishing missing keys, null values, and empty strings, and create a separate issue report.
Check the result of a file copy by comparing hashes of the file bytes rather than relying only on names or sizes.
Try a short search term such as CSV or AI.
All examples are for practice. Automotive data is synthetic and used for illustration.