Skip to content

Instantly share code, notes, and snippets.

@csing-95
csing-95 / getFolderInfo.py
Created September 18, 2025 08:41
Gets the metadata for files in file structure
import os
import pandas as pd
from datetime import datetime
def get_file_metadata(folder_path):
data = []
for root, dirs, files in os.walk(folder_path):
for file in files:
filepath = os.path.join(root, file)
@csing-95
csing-95 / identifyDupes.py
Created September 18, 2025 08:39
Finds duplicate files and marks which ones to remove
import pandas as pd
import re
# ===== CONFIG =====
file_path = r"C:\path_filename.xlsx"
sheet_name = "Documents"
output_sheet = "Dupe Decisions"
COL_DOC = "Document Name"
COL_SIZE = "File size"
@csing-95
csing-95 / renditionPath.py
Created September 18, 2025 08:38
Propagating rendition path column
#!/usr/bin/env python3
from __future__ import annotations
from pathlib import Path
from typing import List, Optional
from datetime import datetime
import pandas as pd
from openpyxl import load_workbook
# ========= CONFIG =========
WORKBOOK_PATH = r"path_filename.xlsx"
@csing-95
csing-95 / splitLoadsheets.py
Created September 18, 2025 08:36
Split Loadsheets
# split_import_sheets.py
import sys
import os
import time
import pandas as pd
from typing import List, Tuple, Dict, Optional
from openpyxl.worksheet.table import Table, TableStyleInfo
from openpyxl.utils import get_column_letter
# -----------------------------