Data & Analytics

ecnu-icalk Skill

Process invoice data vectors for analytics and charting. Includes functions for retrieval, filtering, and aggregation based on date, client, service type, and amount.

ecnu-icalk Skill

Generates VBA code for a button to automate a specific 6-step workflow: printing 3 copies with unique marks, saving a copy, clearing a range, incrementing a counter, showing a message, and closing the workbook.

ecnu-icalk Skill

用于编写VBA宏，批量处理Excel中的超链接。支持将绝对路径转换为相对路径以解决共享问题，或根据文件夹名称批量创建指向本地文件夹的超链接，并自动校验文件存在性。

ecnu-icalk Skill

Generates PostgreSQL queries from plain English instructions, adhering to specific syntax rules for date functions and intervals.

ecnu-icalk Skill

Generates a C# script to create two columns of random integers with specific ranges (1-20 and 1-100) and outputs the results in CSV format.

ecnu-icalk Skill

Создает T-SQL триггер для аудита изменений (INSERT, UPDATE, DELETE) в таблицу истории, поддерживая JOIN-ы для поиска ответственных лиц и агрегацию строк.

ecnu-icalk Skill

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.

ecnu-icalk Skill

Implement a custom DataFrame class in Python with specific methods (__init__, __getitem__, __repr__, etc.) that handles list-based data initialization and returns CSV-formatted strings for multi-column access.

ecnu-icalk Skill

Excel Vba Batch Hyperlink Manager

ecnu-icalk Skill

读取股票5分钟K线CSV文件，按日期分组，计算基于昨日收盘价的百分比变化，过滤无效数据（长度不一致、NaN、Inf），进行Z-score归一化，并使用TimeSeriesKMeans（DTW/SoftDTW度量）进行聚类。

ecnu-icalk Skill

Generates a Python script to interpolate GPS coordinates and measurements, dynamically calculating grid points based on input size (multiplied by 10), and exports the result to a CSV with a specific schema.

ecnu-icalk Skill

Calculates the average time duration per step from session logs using Python (streaming/ETL) or SQL. Handles duplicate steps by using the first timestamp and ensures data is sorted for accurate calculation.

ecnu-icalk Skill

使用mplfinance库从CSV或对象列表生成K线图，支持预测标记（>0.5）、自定义样式、成交量处理及图片保存。

ecnu-icalk Skill

Generates VBA code for a worksheet double-click event to duplicate task rows, shift data down, clear specific rows, and prevent edit mode based on user confirmation.

ecnu-icalk Skill

Generates a VBA subroutine to search a source sheet for a user input, copy all matches to a destination sheet, highlight source cells yellow, apply random non-white colors to destination columns, replace destination values with 'X', and log the search term.

ecnu-icalk Skill

Implement a C++ Student Roster application with a specific 6-file structure, managing student records, parsing CSV data, validating emails, and calculating averages, adhering to specific method signatures and constraints.

ecnu-icalk Skill

Generates quotes consisting of a curiosity-inducing first part and a revealing second part, categorized by theme (Girl Facts, Boy Facts, Friend Facts) and formatted as an Excel-style table.

ecnu-icalk Skill

Design a modular, scalable Node.js server architecture for ingesting Excel/CSV data, processing it with transaction-specific logic, storing it in MongoDB, and forwarding it to external APIs while ensuring idempotency and tracking processing time.

ecnu-icalk Skill

Generates Excel array formulas to filter rows by date criteria (range or offset), format dates as 'dd-mm-yyyy', and concatenate multiple columns with double spaces into separate rows.

ecnu-icalk Skill

Generates a VBA macro to parse movie details (Title, Distributor, Approvals, Copies) from a specific text format in Excel Column A and output them to adjacent columns.

ecnu-icalk Skill

Explains technical concepts, specifically SQL and database topics, using real-life analogies and a concise, beginner-friendly tone with strict code formatting rules.

ecnu-icalk Skill

Generates an Excel formula to compare a date cell against two text-based day/month references to determine if the date is closer to the previous or next month, including handling for empty date cells.

ecnu-icalk Skill

Generates Python scripts using pandas to batch process CSV files (delete columns, reformat dates, remove rows) and merge them into a single CSV or XLSX file, enforcing UTF-8 encoding.

ecnu-icalk Skill

Generate C# scripts for Unity to parse a CSV file containing minion card data into a list of serializable objects based on a specific 14-column schema.

ecnu-icalk Skill

Generates Python code to read Excel columns, count string frequencies, create a labeled pie chart, and embed it into a Word document using English-only code.

ecnu-icalk Skill

Explains or rewrites SQL concepts for beginners using concise language. Ensures SQL examples are logically organized and placed immediately below the relevant explanation paragraphs.

ecnu-icalk Skill

Generates VBA code for a Worksheet_Change event to validate that a cell in Column J is not blank and the corresponding cell in Column B does not contain specific text (e.g., 'Request').

ecnu-icalk Skill

Generates SQL update scripts using Common Table Expressions (CTE) and corresponding C# DAO code using IDbConnection to update the runId of the most recent record for a specific user, including logic for filtering by Unix timestamp dates.

ecnu-icalk Skill

Generate SQL queries using explicit JOIN syntax (INNER, LEFT, etc.) with ON clauses, strictly avoiding NATURAL JOIN to ensure compatibility.

ecnu-icalk Skill

Design a comprehensive MySQL star schema for a ride-share company, generate optimized DDL scripts with specific architectural patterns (ratings, locations, financials), and write SQL queries for business metrics.

ecnu-icalk Skill

Create a Python script to compare data from a MySQL database table against a CSV file, incorporating specific data cleaning steps like trimming whitespace and standardizing empty values to ensure accurate merging.

ecnu-icalk Skill

Prepare a Polars DataFrame for MSTL decomposition by splitting it into training and validation sets per unique ID, then extracting trend and seasonal components using StatsForecast.

ecnu-icalk Skill

Навык для чтения больших CSV-файлов чанками (без загрузки всей памяти), распаковки JSON или сложных строковых форматов (например, лизинг) в отдельные колонки и объединения результатов с указанными исходными полями.

ecnu-icalk Skill

Advanced Python visualization expert supporting Pandas DataFrames and raw data. Handles dynamic single/dual-axis plotting, Chinese font configuration, Tensor conversion, and safe file saving without display.

ecnu-icalk Skill

Generates two-part content (video scripts or quotes) with a hook-and-answer structure for themes like Finance, Crypto, or Social Facts, formatted as an Excel-style table.

ecnu-icalk Skill

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.