find_cells_with_value

Locate all cells containing a specific value in datasets for data validation, quality checking, and pattern identification. Provides coordinates and context for each match.

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
`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

Input Schema (JSON Schema)

{ "properties": { "columns": { "anyOf": [ { "items": { "type": "string" }, "type": "array" }, { "type": "null" } ], "description": "List of columns to search (None = all columns)" }, "exact_match": { "description": "True for exact match, False for substring search", "type": "boolean" }, "value": { "description": "The value to search for (any data type)", "title": "Value" } }, "required": [ "value", "columns", "exact_match" ], "type": "object" }

DataBeak