This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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" |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 | |
# ----------------------------- |