dystat 0.1.2

Douyu Statistics Tools - analyze danmu data with rank, cluster, and search.

dystat

Douyu Statistics Tools - analyze danmu data with rank, cluster, and search.

Installation

pip install dystat

Quick Start

# Set DSN
export DYKIT_DSN="postgresql://user:pass@localhost:5432/douyu"

# Show version
dystat --version

# Rank users by message count
dystat rank -r 6657 --top 10

# Rank content (repeated messages)
dystat rank -r 6657 --by content --top 10

# Cluster similar messages
dystat cluster -r 6657 --threshold 0.5

# Search messages
dystat search -r 6657 --content "hello"
dystat search -r 6657 --user "username"

Commands

rank

Rank users or content by frequency.

dystat rank -r 6657 --top 10                    # Top users (default)
dystat rank -r 6657 --by content --top 10      # Repeated content
dystat rank -r 6657 --type dgb --top 5         # Gift messages
dystat rank -r 6657 --days 7                   # Last 7 days

Options:

• -r, --room ROOM - Room ID (required)
• --top N - Number of results (default: 10)
• --by user|content - Rank mode (default: user)
• --type TYPE - Message type (default: chatmsg)
• --days N - Limit to recent N days
• --from TIME - Start time (YYYY-MM-DD or YYYY-MM-DD HH:MM:SS)
• --to TIME - End time (YYYY-MM-DD or YYYY-MM-DD HH:MM:SS, inclusive)
• --last N - Use latest N messages as source window
• --first N - Use earliest N messages as source window

cluster

Cluster similar messages using fuzzy text matching.

dystat cluster -r 6657 --threshold 0.5         # Default threshold
dystat cluster -r 6657 --limit 100             # More source messages

Options:

• -r, --room ROOM - Room ID (required)
• --threshold FLOAT - Similarity threshold 0-1 (default: 0.5)
• --limit N - Source message limit (default: 50)
• --type TYPE - Message type (default: chatmsg)
• --from TIME - Start time (YYYY-MM-DD or YYYY-MM-DD HH:MM:SS)
• --to TIME - End time (YYYY-MM-DD or YYYY-MM-DD HH:MM:SS, inclusive)
• --last N - Use latest N messages as source window
• --first N - Use earliest N messages as source window
• --days N - Limit to recent N days

search

Search messages with filters.

dystat search -r 6657 --content "hello"        # ILIKE search
dystat search -r 6657 --user "username"        # By username
dystat search -r 6657 --type dgb               # By message type

Options:

• -r, --room ROOM - Room ID (required)
• --content TEXT - Content filter (ILIKE)
• --user USERNAME - Username exact match
• --user-id UID - User ID exact match
• --type TYPE - Message type
• --from TIME - Start time (YYYY-MM-DD or YYYY-MM-DD HH:MM:SS)
• --to TIME - End time (YYYY-MM-DD or YYYY-MM-DD HH:MM:SS, inclusive)
• --last N - Return latest N messages (default window size: 100 when --first/--last omitted)
• --first N - Return earliest N messages

Environment Variables

Variable	Description
DYKIT_DSN	PostgreSQL connection string
DYSTAT_DSN	Alias for DYKIT_DSN

License

MIT