Agent skill · data analytics · aradotso
llm-public-opinion-analytics-assistant
Multi-platform hot search crawler and LLM-powered public opinion analysis system with clustering, sentiment analysis, and multi-channel push notifications
Why this skill is useful
Adds a complete LLM-powered public opinion analytics system with multi-platform data crawling and sentiment analysis capabilities that are not commonly available.
What it needs
Requires chromedriver, mysql installed locally. About 6k tokens when loaded. Last updated 2026-08-05. 5 stars on the source repository.
What this skill does
LLM-Based Intelligent Public Opinion Analytics Assistant Skill by ara.so — Data Skills collection. Overview This project is an intelligent public opinion analysis assistant that combines real-time data from 26 trending lists across 15 mainstream platforms with large language model (LLM) analysis capabilities. It provides conversational hot search queries, topic-specific searches, topic clustering analysis, and sentiment analysis through a web interface. The system supports keyboard shortcuts for crawler control, multi-platform data retrieval with direct navigation, and multi-channel hot topic push notifications (email, WeChat, Enterprise WeChat, Telegram). Key Features Multi-Platform Data Collection: Crawls 26 trending lists from 15 platforms LLM-Powered Analysis: Topic clustering, sentiment analysis, and trend detection Conversational Interface: Natural language queries for data exploration Video Content Analysis: Extracts information even from video-based news Multi-Channel Notifications: Email, WeChat Work, Telegram bot push notifications Crawler Control: Quick start/stop via keyboard shortcuts Database Storage: MySQL-based data persistence Installation Prerequisites Browser Driver Setup (Required for news detail extraction): 1. Check browser version: Open Edge/Chrome → Settings → About Note your version (e.g., 115.0.5790.102) 2. Download matching driver: Chrome: https://chromedriver.chromium.org/ Edge: https://developer.microsoft.com/en-us/microsoft-edge/tools/webdriver/ 3. Install driver: 4. Verify installation: Environment Setup Database Configuration 1. Install MySQL (8.0+ recommended) 2. Create database and tables: Configuration Files Create .env file in project root: Crawler Configuration (hotsearchcrawler/settings.py): Usage Starting the System 1. Launch the web application: Access at: http://localhost:5000 2. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aradotso/llm-public-opinion-analytics-assistant