PDF batch process

Extract from 50 PDF contract in this folder:

Need extract fields:
1. Contract number
2. Sign date
3. Contract amount (with currency)
4. Party A name
5. Party B name
6. Contract period (start-end date)
7. Payment term (if have)

Output format:
- Generate table, one contract per row
- If certain field not found in contract, mark "not found"
- Final summary: total contracts, total amount, earliest/latest sign date

Note: some contract is scan file (image PDF), need OCR recognize first then extract.

Recognize this scan PDF table and convert to Excel.

Requirement:
1. Use OCR recognize all text and number in table
2. Keep original table row-column structure
3. Recognize number column as number format (not text)
4. Date column uniform format YYYY-MM-DD
5. If have merge cell, keep as is
6. If not certain in recognize, mark with [?]

PDF file: [upload file]

Output: Excel format, first row as header.

Batch merge these PDF file, requirement as follow:

1. Sort rule: sort by file name number part ascending
   Example: report_01.pdf → report_02.pdf → report_10.pdf
   (note: number sort, not letter sort, 10 after 2)

2. After merge process:
   - Add page number bottom right corner every page (format: Page X / Total Y)
   - Generate table of content page at begin
   - Table of content include every original file name and start page number

3. Output:
   - Merged PDF file
   - Log file, record which file merged, order, every file page count

Give Python script implement this (use PyPDF2 or reportlab).