opencode-web

# Debugging a Python Script

**Task:** Identify and fix issues in the following Python script that processes customer data.

```python
import pandas as pd

def process_data(file_path):
    df = pd.read_csv(file_path)
    df['total_spend'] = df['amount'] * df['quantity']
    return df[df['total_spend'] > 1000]

# Example usage
processed_data = process_data('customer_data.csv')
```

**Potential Issues:**
- Missing error handling for file operations
- No input validation
- Hardcoded threshold value

**Suggested Improvements:**
1. Add try-except blocks for file operations
2. Implement input validation for file path and content
3. Make the threshold value configurable
4. Add logging for debugging purposes

**Improved Code:**
```python
import pandas as pd
import logging

logging.basicConfig(level=logging.INFO)

def process_data(file_path, threshold=1000):
    try:
        if not file_path.endswith('.csv'):
            raise ValueError('File must be a CSV')
        
        df = pd.read_csv(file_path)
        if 'amount' not in df.columns or 'quantity' not in df.columns:
            raise ValueError('Required columns missing in CSV')
        
        df['total_spend'] = df['amount'] * df['quantity']
        return df[df['total_spend'] > threshold]
    except Exception as e:
        logging.error(f'Error processing data: {str(e)}')
        raise
```