用于从MySQL表的文本列中提取特定URL参数(如loc)的域名,并统计每个域名的出现次数,按降序排列。
Skills(SKILL.md)は、AIエージェント(Claude Code、Cursor、Codexなど)に特定の能力を追加するための設定ファイルです。
詳しく見る →用于从MySQL表的文本列中提取特定URL参数(如loc)的域名,并统计每个域名的出现次数,按降序排列。
指导在PyTorch中实现多任务学习或知识蒸馏场景下的动态Loss权重调整,涵盖可学习标量权重、GradNorm算法及基于不确定性的加权方法,并解决设备一致性、计算图错误及权重约束问题。
根据用户提供的银联优惠活动文本,按照指定JSON格式提取活动ID、时间、银行、卡类型、地区、平台、支付方式、门店、卡BIN、优惠力度、频次限制及活动状态等信息,并执行特定的日期计算和状态判断逻辑。
在C# Windows Forms应用程序中编写一个HTTP监听函数,用于接收网页提交的数据。该技能特别针对.NET 4.0及旧版Visual Studio环境,要求不使用async/await语法,而是使用APM模式(BeginGetContext/EndGetContext)实现异步监听,并支持多次接收数据。
开发Manifest V3版本的Chrome插件,使用xlsx库解析Excel文件,提取指定列数据(如iccid),按固定大小(如1000)分批,转换为文本文件格式,并通过FormData上传到服务器,批次间需延时。
从包含URL路径及参数的列中提取指定参数(如loc)的域名,并统计每个域名的出现次数,按降序排列。
针对PyTorch中多任务学习或知识蒸馏场景,使用可学习参数(nn.Parameter)动态调整多个损失函数权重比例的技能。涵盖参数定义、优化器配置、数值稳定性处理(如对数空间转换)以及GradNorm算法的实现逻辑。
根据用户提供的优惠活动详细介绍文本,提取并计算关键信息(如时间、银行、优惠力度、限制条件等),严格按照指定的JSON Schema进行结构化输出。包含时间格式化、支付方式判断、场景分类、活动状态判断及基于时长的总次数推算。
Analyzes resonance structures for a given chemical compound by drawing them, displaying formal charges, ranking them by stability using resonance rules, and explaining the reasoning.
Rewrites input text to be clear and not too formal while strictly preserving the original meaning, facts, and numerical data.
Defines a 7x3 PostgreSQL ARRAY column in SQLAlchemy for a weekly schedule, containing open time, close time, and work time.
Identifies TV series featuring female characters aged 30-60 who frequently wear tight, form-fitting bodycon dresses that emphasize their figure and curves, based on provided examples and excluding them.
Simulate theoretical wormhole scenarios adhering to Einsteinian physics, strict conservation of mass/momentum, and causality laws, while preventing time travel paradoxes.
Создает триггер для MS SQL, который логирует операции INSERT, UPDATE, DELETE в отдельную таблицу истории, включая выборку связанных данных (например, ФИО ответственных) через JOIN с другими таблицами.
Adopts the persona 'Binari' to answer questions using only 'Yes', 'No', or 'Maybe', prefixed by 'Binari: '. Includes a toggle mechanism to switch between this constrained mode and normal conversation.
Calculates daily feed intake for broiler chickens from day 1 to 32 based on a multi-phase recipe and target weight, and identifies or adds missing nutritional supplements like calcium, phosphorus, and vitamins.
Simulates theoretical wormhole scenarios adhering to Einstein's descriptions, conservation laws, and causality, preventing time travel paradoxes.
Create a Python function named 'first' that identifies the first character in a string which does not repeat. It performs case-insensitive counting to determine uniqueness but returns the character in its original case.
Writes a formal executive summary for business proposals focusing on market opportunities and implementation strategies, adhering to a strict sentence count constraint.
Создает T-SQL триггер для аудита изменений (INSERT, UPDATE, DELETE) в таблицу истории, поддерживая JOIN-ы для поиска ответственных лиц и агрегацию строк.
Implement a Python script to downsample an image by processing 4x4 pixel blocks. Each pixel in a block votes for the closest color in a colormap, and the block is filled with the most voted color.
Reorganiza fragmentos de palabras o frases desordenadas proporcionados por el usuario para formar una oración coherente y gramaticalmente correcta.
Rewrites sentences from direct speech (quotes) to reported (indirect) speech based on explicit user instruction.
Rewrites business text to match the formal, objective, and concise style of a 10-K financial statement, ensuring the output is in the third person.
Formulate a machine learning problem statement that utilizes a sequential scheme involving two distinct ML approaches, where the output of the first subtask serves as the input for the second.
An AI assistant designed to help spread awareness about social issues by promoting events, communities, cultures, and safe spaces. It assists with content strategy, visuals, and tying movements to popular trends on platforms like Instagram, YouTube, and TikTok.
Perform a TOWS analysis by linking items from two provided lists (e.g., Opportunities & Strengths, Threats & Weaknesses) and providing a summarized rationale for each connection.
Создает SQL-запросы для базы данных с фиксированной схемой (таблицы QRY_QUEUE, ST_ABONENTS, QRY_TYPE) для анализа статистики обработки сообщений, процента ошибок и данных абонентов.
Создание вторичного пакета Oracle PL/SQL, который включает вызовы процедур из основного пакета, использует коллекции для выборки и вывода данных, передает данные через параметры и обрабатывает исключения.
Write analytic philosophy papers that persuade the reader of a philosophical claim by presenting and explaining a convincing argument. The paper must include a clear thesis, relevant background, an original argument, an anticipated objection with a reply, substantive engagement with assigned articles, and an introduction and conclusion. The writing style must be formal, clear, and straightforward, avoiding unnecessary thesaurus-ization while maintaining technical precision.
Synthesizes provided research findings into coherent academic prose, identifying key themes, implications, and theoretical frameworks while maintaining a formal, scholarly tone.
Computes the average duration of actions or steps from session logs using Python (pseudo-streaming) or SQL. Handles duplicate steps by retaining the first timestamp and calculates duration based on the time difference to the next step.
Simulates a turn-based text adventure game where a character attempts to hold a plank exercise with extra weight. Manages energy levels, turn counts, and random events for form recovery and collapse.
Simulates a turn-based text adventure game where the user performs a plank exercise with a partner (Elaine) on their back, managing energy levels against random tickling events.
Designs PostgreSQL schemas and queries for tracking item prices and stock counts over time, ensuring immutable creation records and hourly history logging.
Implement full-text search using SQLite's FTS5 extension with SQLAlchemy. This includes creating a virtual FTS table, synchronizing data between standard tables and the FTS index, and executing raw SQL queries for search operations.
Performs a strict binary comparison of personal records (SSN, Name, DOB, Address) using rigorous normalization and fuzzy matching to determine if two individuals are the same.
Operates as an autonomous expert author to write high-quality, long-form non-fiction books using a strict JSON command interface. Plans, outlines, drafts iteratively, manages strict word counts, and ensures state persistence, with enhanced capabilities for structuring long chapters and applying multi-pass editing strategies.
Implements a C++ function to evaluate a 3-variable quantificational logic formula (QxQyQz F(x,y,z)) based on a 4x4x4 boolean array and a quantifier array.
Analyzes films by examining observable formal features and content through a philosophical lens, using and explaining technical terminology.
Genera classi Mapper statiche per convertire tra TypeORM Entities e DTOs, seguendo uno stile di ritorno letterale oggetto e gestendo relazioni nidificate.
Simulates a command-line interface for a Matrioshka Brain integrating Boltzmann Brains via quantum entanglement. Responds to network commands and database queries with immersive, sci-fi appropriate outputs without breaking the fourth wall.
Simulates a turn-based text adventure where the user holds a plank with a partner (Elaine) on their back, tracking energy and form recovery based on probabilistic mechanics and automatic interruptions.
Performs visual analysis of artworks by focusing on elements and principles of design, distinct from thematic or material analysis. Refines user-provided formal analysis drafts based on these principles.
Compares two person records using a weighted scoring algorithm (SSN, Name, DOB, Address) to determine if they represent the same individual, incorporating robust normalization rules.
Реализация логики управления предметами в ListView, где иконка и имя зависят от уровня и зачарования, а свойства сбрасываются при перемещении между списками.
在识别学生存在心理危机信号后,辅导员启动校内多级响应机制:先通过非正式陪伴建立信任,再快速评估风险,随后无缝对接心理健康中心安排专业咨询。该流程确保危机干预不中断、支持不断档。
针对来访者绝对化、以偏概全、糟糕至极等非理性信念,使用ABC模型结构化呈现事件-信念-后果,并借助自助量表引导其对不恰当认知进行事实性辩驳,建立更合理的自我认识。
根据当前日期和给定的每月号数A,计算下一个A号的日期。如果当前日期已过本月A号,则返回下月A号。
使用pymodbus库通过RS485读取Modbus保持寄存器,将两个寄存器转换为大端浮点数,并按指定格式存入SQLite数据库的脚本模板。