| import pandas as pd | |
| import re | |
| def excel_answer(file_path, question): | |
| df = pd.read_excel(file_path) | |
| # Example: sum for food sales, or other logic based on question | |
| if 'food' in question.lower(): | |
| # Try to find a column with 'food' or a category column | |
| if 'Category' in df.columns and 'Sales' in df.columns: | |
| total = df[df['Category'].str.lower() == 'food']['Sales'].sum() | |
| return f"{total:.2f}" | |
| # Fallback: sum last column | |
| total = df.iloc[:, -1].sum() | |
| return f"{total:.2f}" | |
| # Add more logic for average, etc., if needed | |
| # Fallback: sum last column | |
| total = df.iloc[:, -1].sum() | |
| return f"{total:.2f}" | |