find_cells_with_value
Locates all cells containing a specific value in CSV datasets for data validation, quality checking, and pattern identification.
Instructions
Find all cells containing a specific value for data discovery.
Searches through the dataset to locate all occurrences of a specific value, providing coordinates and context. Essential for data validation, quality checking, and understanding data patterns.
Returns: Locations of all matching cells with coordinates and context
Search Features: 🎯 Exact Match: Precise value matching with type consideration 🔍 Substring Search: Flexible text-based search for string columns 📍 Coordinates: Row and column positions for each match 📊 Summary Stats: Total matches, columns searched, search parameters
Examples: # Find all cells with value "ERROR" results = await find_cells_with_value(ctx, "ERROR")
# Substring search in specific columns
results = await find_cells_with_value(ctx, "john",
columns=["name", "email"],
exact_match=False)AI Workflow Integration: 1. Data quality assessment and error detection 2. Pattern identification and data validation 3. Reference data location and verification 4. Data cleaning and preprocessing guidance
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| value | Yes | The value to search for (any data type) | |
| columns | Yes | List of columns to search (None = all columns) | |
| exact_match | Yes | True for exact match, False for substring search |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| success | No | Whether operation completed successfully | |
| coordinates | Yes | ||
| exact_match | Yes | ||
| search_value | Yes | ||
| matches_found | Yes | ||
| search_column | No |