从Excel读取中文文本,支持基于句法树结构(如深度、词性)或语义向量(如TF-IDF、SentenceTransformer)的特征提取,执行聚类分析(如K-Means、DBSCAN),并将结果导出回Excel。
Skills(SKILL.md)は、AIエージェント(Claude Code、Cursor、Codexなど)に特定の能力を追加するための設定ファイルです。
詳しく見る →从Excel读取中文文本,支持基于句法树结构(如深度、词性)或语义向量(如TF-IDF、SentenceTransformer)的特征提取,执行聚类分析(如K-Means、DBSCAN),并将结果导出回Excel。
Parses a URL string to extract query parameters into a key-value dictionary structure without using std::unordered_map.
Edits and rewrites sci-fi or fantasy text (novels or game lore) into an epic, high-fantasy style, enhancing vocabulary and tone while strictly preserving original facts and plot points.
Writes expository essays including an outline, introduction, body paragraphs, and conclusion. Body paragraphs must strictly follow the structure: topic sentence, elaboration, examples, and concluding sentence.
Identify and list relevant key terms, concepts, and phrases from provided text blocks.
Create a Python script using regular expressions to extract all positive integers and floating-point numbers from a list of strings, ensuring hyphens are treated as separators and handling optional currency symbols.
Extracts structured CLAIM tuples from HTML tables by distinguishing context vectors from scientific measures, utilizing captions and context for accuracy.
Corrects grammar and vocabulary in IELTS essays, explains errors, suggests synonyms, and enforces structural requirements (e.g., 4-paragraph Task 1) while strictly preserving the user's original wording and structure unless explicitly requested otherwise.
Runs a slow-paced interactive story in second person present tense, pausing after short segments to provide plot suggestions or solicit the user's next action and revisions.
Implement a PyTorch Transformer model using nn.Transformer without manual weight initialization, and a text-to-tensor conversion function for a fixed 8-bit character vocabulary without external libraries.
Writes paragraph-based evaluations and reflections for project reports, strictly following a user-provided list of guiding questions or points as the structure.
Performs the fictional 'taphao' mathematical operation defined by the user, where A taphao B equals A multiplied by the sum of the digits of B.
Implements a computer vision pipeline to summarize videos by detecting and tracking multiple objects, selecting only frames containing motion.
Process an array of objects containing timestamps to count occurrences per hour and day, then export the aggregated counts to a CSV file.
Explains or rewrites SQL concepts for beginners using concise language. Ensures SQL examples are logically organized and placed immediately below the relevant explanation paragraphs.
Implement a high score tracking system for Codesters games using CSV files. This involves reading existing scores, appending new scores, sorting them, writing back to the file, and displaying the results on the stage.
Configure a Pydantic BaseSettings class to load environment variables from a .env file, ensuring correct relative or absolute path resolution.
Calculates the number of whole shares to buy at multiple price levels to approximate a target average price, ensuring shares are bought at every level and the total cost stays within budget.
Transforms lists of step-by-step instructions into cohesive paragraphs written in the past tense, strictly avoiding first-person pronouns to maintain an objective, passive voice.
Executes binary classification using DNN and CNN models, with and without CHAID feature selection, using a rolling time-series training window. Handles missing data via mean imputation and outputs a CSV with appended prediction columns.
Provides definitions, mathematical expressions, and simple examples for terms strictly within the context of Fluid Mechanics and Thermodynamics.
Summarize entire books of scripture with a minimum length of six full paragraphs and a descriptive, elaborative style.
Perform a comprehensive SEO audit for a product on e-commerce platforms like Lazada. This involves identifying top competitors, extracting pricing and high-volume keywords, comparing them with the user's product to find gaps, and suggesting title optimizations for better search ranking.
Calculates the number of disorder pairs (inversions) in a list where an element at a lower index is greater than an element at a higher index. Prioritizes efficient algorithms (O(n log n)) suitable for large datasets.
Analyzes accounting data in Excel to calculate days inventory in stock and goodwill ratios, grouped by business sectors derived from SIC codes, including summary statistics and plotting.
Extracts embedding vectors from the layer immediately preceding the Softmax layer of a pre-trained model (e.g., Inception-V3, ResNet50) and saves them in a dictionary where the key is the embedding vector and the value is the corresponding label.
Runs a second-person interactive story game tracking bladder and bowel levels with graphic detail. The narrative progresses slowly based on user actions, with explicit status updates and descriptive elimination events.
Roleplay as Natalie, a 25-year-old MFA graduate from New York, to explain novel paragraphs and provide entertainment through literary trivia or mini-games.
Transforms a single-column matrix into a multi-column matrix by splitting data into 24-row chunks, appends rows for average and max index, and calculates the most frequent max index.
Manages the ABC board game on a 6x6 grid where players place A, B, or C to form the sequence 'ABC'. Enforces strict visualization rules including zero-padded numbering, doubled letter pieces, and no separator lines.
Implements a PyQt5 workflow where a button opens a file dialog, the selected path is displayed in a QLineEdit, and a pandas DataFrame is saved to that path with silent error handling.
Extracts audio from AVI files, detects and removes silent parts using the scipy library, and saves the recovered audio file.
Develop interactive 2D graphics applications using React and Pixi.js (@pixi/react). Includes rendering shapes from arrays, managing state for updates, handling pointer events for interactivity, and accessing the Pixi app instance via hooks.
Constructs a scikit-learn text classification pipeline that integrates custom feature engineering steps: one-hot encoding of spaCy NER labels for a predefined set of 18 classes and VADER sentiment analysis.
Automates interactions with a web-based chatbot using Python and Selenium, handling consent flows, user input loops, and waiting for message stability before extraction.
Adapt a source material (like a book) into a short film story or synopsis. The adaptation must feature a completely new plot distinct from the source while strictly preserving the main themes, and must incorporate user-defined settings and character traits.
Calculates trading profit by determining the percentage difference between entry and exit prices, multiplying by a factor of 50, and adding a 4% adjustment to the result.
Calculates the intrinsic value of a stock (V0) and intermediate dividends (D1, D2, D3) using the Two-Stage Dividend Discount Model. Provides both numerical results and Excel formulas for the components.
Expands or rewrites provided summaries, abstracts, or technical descriptions into formal academic text (chapters or paragraphs) adhering to word counts and SCI tone, strictly avoiding bullet points.
Provides direct, unexplained answers for math, code, and multiple-choice questions. For True/False statements, performs detailed evaluations including rewriting, justification for false items, and a summary count.
A systematic, first-principles approach to crafting advanced Cross-Site Scripting (XSS) payloads by analyzing reflection contexts, identifying constraints, and applying obfuscation techniques to bypass filters.
Provides a step-by-step workflow to create scanning presets that neutralize the orange mask of color negatives while preserving the film's subjective color character.
Transforms user-provided outlines, best practices, and role descriptions into formal presentation scripts for student government events.
A comprehensive Python workflow for recognizing songs from microphone, internal audio, or files using ACRCloud and Shazam. It enriches metadata via Spotify and Apple Music, embeds high-res album art using eyed3 and mutagen, fetches synchronized LRC lyrics, and organizes files with detailed naming conventions.
Processes a file containing candidate names and votes to calculate election statistics (total, valid, invalid votes), determine winners, and output results to a file with dynamically aligned columns.
Solves stoichiometry problems including mass-to-mole conversions, limiting reactant determination, and percent yield calculations, while strictly adhering to significant figure rules.
Process invoice data vectors for analytics and charting. Includes functions for retrieval, filtering, and aggregation based on date, client, service type, and amount.
Correctly calculates AUC for cross-validation by computing the metric per iteration using decision scores and averaging the results, avoiding the error of averaging class labels.
Implement a multiclass logistic regression classifier from scratch using NumPy and Pandas without scikit-learn. Use the One-vs-Rest strategy to handle multiple classes (e.g., 0, 1, 2) and save the trained model coefficients to a pickle file.
Analyzes provided narrative text for emotional resonance, naturalism, and stylistic elements. Evaluates dialogue and descriptions for authenticity, impact, and effectiveness in conveying character dynamics and plot progression.