Unify 7 tables and impute missing values

Using pandas, write a robust function unify_orders(...) that ingests seven DataFrames (or CSVs) whose column names may have inconsistent casing or whitespace, and returns a single denormalized OrdersAnalytics table. Output schema The result must have exactly these columns, in this order: Rules order_date must be a YYYY-MM-DD string. total_amount is sum(quantity * unit_price) across the items of each order. product_count is the count of distinct product_id per order.…