# Core Libraries
python-magic>=0.4.27
python-dotenv>=1.0.1
tqdm>=4.66.0

# Excel Processing
pandas>=2.0.0
openpyxl>=3.1.0

# PDF Processing
pypdf>=4.0.0
pdfplumber>=0.11.0
PyPDF2>=3.0.0

# Image Processing
Pillow>=10.2.0
pytesseract>=0.3.0
pdf2image>=1.16.0
piexif>=1.1.0
iptcinfo3>=2.1.0

# Office Documents
python-docx>=1.0.0
python-pptx>=0.6.0

# Video Processing
mutagen>=1.45.0
ffmpeg-python>=0.2.0
pymediainfo>=7.0.0

# AI & Metadata Generation
openai>=1.0.0
tiktoken>=0.5.0
tenacity>=8.2.0

# ExifTool Integration (optional but recommended)
PyExifTool>=0.5.6

# Web Framework
Flask>=3.0.0
Werkzeug>=3.0.0
gunicorn>=21.0.0

# Authentication & SSO
msal>=1.20.0  # Microsoft Authentication Library for SSO (optional)
