Opencode

# Function to process sales data and generate a summary report
# Input: CSV file containing sales data
# Output: JSON file with summarized sales metrics

import csv
import json

def process_sales_data(input_file, output_file):
    """
    Processes sales data from a CSV file and generates a summary report in JSON format.

    Args:
        input_file (str): Path to the input CSV file
        output_file (str): Path to the output JSON file
    """
    try:
        with open(input_file, mode='r') as csv_file:
            csv_reader = csv.DictReader(csv_file)
            total_sales = 0
            sales_by_region = {}
            for row in csv_reader:
                total_sales += float(row['Amount'])
                region = row['Region']
                sales_by_region[region] = sales_by_region.get(region, 0) + float(row['Amount'])
            
            # Calculate average sale
            average_sale = total_sales / len(sales_by_region)
            
            # Prepare output data
            output_data = {
                'total_sales': total_sales,
                'average_sale': average_sale,
                'sales_by_region': sales_by_region
            }
            
            # Write output to JSON file
            with open(output_file, mode='w') as json_file:
                json.dump(output_data, json_file, indent=4)
                
    except FileNotFoundError:
        print(f"Error: The file {input_file} was not found.")
    except Exception as e:
        print(f"An error occurred: {str(e)}")

# Example usage
# process_sales_data('sales_data.csv', 'sales_summary.json')