from pathlib import Path import pandas as pd from openpyxl import load_workbook from pandas.testing import assert_frame_equal output = Path("exports/orders.xlsx") output.parent.mkdir(parents=True, exist_ok=True)