Keyword Counter

😫 The Pain Point

You have 50 product reviews and want to know how often “quality”, “price”, “delivery” are mentioned. Reading and counting manually is tedious.

🚀 Agentic Solution

A Keyword Frequency Analyzer for text data.

Key Features:

• Multi-File Support: Scan multiple documents.
• Case Insensitive: Count “Quality” and “quality” together.
• Export Stats: CSV with file, keyword, count.

⚔️ Phase 1: Commander (Quick Fix)

For quick counting.

Prompt:

“I have an Excel reviews.xlsx with column ‘Review_Text’. Write a Python script to:

1. Keywords: Count occurrences of ‘quality’, ‘price’, ‘delivery’, ‘service’.
2. Case Insensitive: Treat all variations equally.
3. Output: Summary table with keyword counts.

Print total counts and per-row breakdown.”

Result: Quantified feedback insights.

🏗️ Phase 2: Architect (Permanent Tool)

For SEO Specialists.

Engineering Prompt:

**Role:** Python GUI Developer (PyQt6 Specialist)
**Task:** Create "Keyword Analyzer" Desktop App

**Objective:** A text analysis tool to count keyword frequencies across multiple documents.

**Tech Stack:**
* Language: Python 3.10+
* GUI Library: PyQt6 (Cross-platform)
* Data Engine: Pandas
* Packaging: PyInstaller

**Functional Requirements:**
1.  **UI Layout (PyQt6):**
    *   **Input:** File List (Excel/CSV/Txt).
    *   **Keywords:** Text Area for comma-separated keywords.
    *   **Options:** Checkboxes for "Case Sensitive", "Whole Word Only".
    *   **Results:** TableWidget showing counts per file.

2.  **Core Logic:**
    *   Iterate rows/files.
    *   Apply Regex counting based on options.
    *   **Threading:** Analysis runs in background thread.

3.  **Deliverables:**
    *   `main.py`: Complete source code.
    *   `requirements.txt`: Dependencies.
    *   **Build Instructions:**
        *   Windows: `pyinstaller --onefile --noconsole main.py`
        *   macOS: `pyinstaller --windowed --noconsole main.py`

🧠 Prompt Decoding

• Whole Word: Match “price” but not “prices” or “priced”.

🛠️ Instructions

1. Copy Prompt → Add keywords → Run.