Comprehensive Test Case Execution List by File
1. employee_data_dirty.xlsx
Basic Data Operations
- ✅ "Show me the first 10 rows of data"
- ✅ "Filter data where Department is 'Marketing'"
- ✅ "Sort the data by Salary in descending order"
- ✅ "Find employees with Performance Score greater than 8"
- ✅ "Show me data for employees in the IT department"
Data Summarization
- ✅ "Calculate the average salary by department"
- ✅ "Show minimum, maximum and average performance scores"
- ✅ "Count the number of employees in each department"
- ✅ "Calculate average performance score by department"
Data Cleaning
- ✅ "Clean the phone number formats in the employee data"
- ✅ "Fix the inconsistent date formats in the hire date column"
- ✅ "Remove rows with missing values"
- ✅ "Identify and highlight potential duplicate entries"
- ✅ "Find and correct outliers in the performance score column"
- ✅ "Create a new column with standardized email addresses"
- ✅ "Create a new column that categorizes performance as 'High', 'Medium', or 'Low'"
- ✅ "Extract the hire year from the date column"
- ✅ "Create a column showing tenure in months since hire date"
2. sales_data.xlsx
Basic Data Operations
- ✅ "Show me the first 10 rows of data"
- ✅ "Sort the data by Total Sales in descending order"
- ✅ "Filter data where Region is 'East'"
- ✅ "Show me only the Electronics products"
- ✅ "Find rows where Quantity is greater than 5"
Data Summarization
- ✅ "Calculate the total sales by region"
- ✅ "What is the average price of products in each category?"
- ✅ "Show a summary of sales by month"
- ✅ "Calculate the minimum, maximum, and average sales"
- ✅ "Create a pivot table of sales by region and product category"
Data Visualization
- ✅ "Create a bar chart of sales by region"
- ✅ "Make a line chart showing sales trend over time"
- ✅ "Generate a pie chart showing the distribution of product categories"
- ✅ "Create a scatter plot comparing quantity and total sales"
- ✅ "Make a histogram of unit prices"
- ✅ "Create a new column that categorizes sales as 'High', 'Medium', or 'Low'"
- ✅ "Extract the month from the date column"
- ✅ "Convert all prices to euros using an exchange rate of 0.92"
Advanced Analytics
- ✅ "Perform linear regression to predict sales based on quantity"
- ✅ "Calculate growth rates for sales month-over-month"
- ✅ "Identify outliers or unusual patterns in the sales data"
- ✅ "Calculate quarterly profit growth rates and visualize the trend"
- ✅ "Analyze correlation between Product Category, Region, and Total Sales"
- ✅ "Group sales data by region and product category to identify customer segments"
- ✅ "Visualize sales performance by region with a bar chart and include a pie chart of product categories"
3. time_series_data.xlsx
Basic Data Operations
- ✅ "Show me the first 10 rows of data"
- ✅ "Sort the data by Temperature in descending order"
- ✅ "Filter data where Humidity is greater than 70"
Data Visualization
- ✅ "Make a line chart showing temperature trend over time"
- ✅ "Create a scatter plot comparing temperature and humidity"
- ✅ "Make a histogram of temperature values"
Advanced Analytics
- ✅ "Calculate the correlation between temperature and humidity"
- ✅ "Calculate moving averages for the temperature over a 3-day window"
- ✅ "Identify trends in the temperature data"
- ✅ "Perform linear regression to predict humidity based on temperature"
- ✅ "Convert temperature from Fahrenheit to Celsius"
- ✅ "Create a new column that categorizes precipitation as 'None', 'Light', 'Moderate'"
- ✅ "Extract the month from the date column"
4. financial_data.xlsx
Basic Data Operations
- ✅ "Show me the first 10 rows of data"
- ✅ "Sort the data by Revenue in descending order"
- ✅ "Filter data for Q1 quarters"
- ✅ "Show data for the year 2024"
Data Summarization
- ✅ "Calculate total revenue by quarter"
- ✅ "Show a summary of profit by year"
- ✅ "Calculate the quarterly averages for all financial metrics"
Data Visualization
- ✅ "Create a bar chart of revenue by quarter"
- ✅ "Make a line chart showing profit trend over time"
- ✅ "Generate a pie chart showing the distribution of expenses by quarter"
- ✅ "Create a bar chart comparing revenue and expenses by month"
Financial Operations
- ✅ "Calculate profit margins for each month"
- ✅ "Create a cash flow statement from the financial data"
- ✅ "Calculate the current ratio (assets/liabilities)"
- ✅ "Project revenue for the next quarter based on historical growth"
- ✅ "Calculate the return on assets (ROA) for each quarter"
Advanced Analytics
- ✅ "Calculate growth rates for revenue month-over-month"
- ✅ "Identify trends in the profit data over quarters"
- ✅ "Perform linear regression to predict future revenue"
- ✅ "Show the revenue trend over time and forecast the next 3 months"
- ✅ "Show correlation between Revenue, Expenses, and Profit and create a heatmap"
- ✅ "Cluster months based on Revenue, Expenses, and Profit metrics"
- ✅ "Create a financial summary dashboard with Revenue, Expenses, and Profit trends"
- ✅ "Validate the quality of the financial data and identify any issues"
- ✅ "Create a new column showing profit as percentage of revenue"
- ✅ "Calculate year-over-year growth for each quarter"
Error Handling and Additional Operations
- ✅ "Make the data look better"
- ✅ "Calculate the average profit margin using the Margin column"