Data & Analytics

ecnu-icalk Skill

Generates Excel formulas or ExcelJS code to create a data validation drop-down list that dynamically excludes blank cells from a specified range.

ecnu-icalk Skill

Generates VBA code to iterate through a column, detect changes in the day value, and highlight the cell preceding the change, while excluding specific time values.

ecnu-icalk Skill

Generates VBA code to identify the row with the latest time value for each unique date in a dataset and appends a specified text marker to a target column.

ecnu-icalk Skill

Generate Python code to iterate through S3 keys stored in a pandas DataFrame, fetch the images using boto3, and embed them as actual images into an Excel file.

ecnu-icalk Skill

Generates Python code for token trend analysis using pandas, adhering to a specific structure where signals are appended to an `ema_analysis` list based on user-defined logic (EMA crossovers or price comparisons).

ecnu-icalk Skill

Создает триггер для MS SQL, который логирует операции INSERT, UPDATE, DELETE в отдельную таблицу истории, включая выборку связанных данных (например, ФИО ответственных) через JOIN с другими таблицами.

ecnu-icalk Skill

Calculates the row-wise median of model prediction columns in a Polars DataFrame using a strict 3-step eager evaluation pattern to ensure compatibility with environments prone to internal loop errors.

ecnu-icalk Skill

Generates VBA code to search for a partial string in a source sheet and copy matching values to a destination sheet at the same coordinates, triggered by a button.

ecnu-icalk Skill

Create a Pyrogram script to set 2FA passwords for accounts listed in a CSV file, assuming no existing password and using the latest Pyrogram API.

ecnu-icalk Skill

Generates C# code to perform a parameterized SQL search and display results in a DataGridView, including input validation and specific connection handling.

ecnu-icalk Skill

Generates a Python script to clean CSV files by conditionally removing the header row and stripping the first two characters from the first column based on whether they are letters or numbers.

ecnu-icalk Skill

Generates SQL UPDATE statements to populate book descriptions in a database, strictly adhering to word count, content exclusion, and formatting constraints.

ecnu-icalk Skill

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.

ecnu-icalk Skill

Generates a VBA Worksheet_Change macro to prevent duplicate entries based on two columns (e.g., Company Name and Invoice Value). It triggers on entry in the second column, checks for existing matching pairs, alerts the user with the row number of the duplicate, and clears the new entry.

ecnu-icalk Skill

Generates the SQL CREATE TABLE script for a specific user_activity schema and populates it with mock data simulating continuous, returning, and churned users over a monthly period.

ecnu-icalk Skill

Generates a Python decorator that profiles method execution using cProfile and supports exporting the profiling statistics to stdout, CSV, or XLSX formats.

ecnu-icalk Skill

Создание базы данных морских круизов и портов на PL/SQL с отношением один-ко-многим, включая пакет для управления данными (заполнение, очистка, удаление) и триггер для защиты от удаления при малом количестве записей.

ecnu-icalk Skill

Simulates an Excel spreadsheet using text-based tables, executing formulas and formatting cells without providing explanations.

ecnu-icalk Skill

Automates Excel row counting and coloring based on 'x' markers and Column C status values. Supports auto-updates on cell changes, event handling safety, and conditional formatting (Green/Red/Blue).

ecnu-icalk Skill

Extracts names, email addresses, and Instagram links from provided text lists and formats them into a numbered table suitable for Excel.

ecnu-icalk Skill

Generate a Python script to compare MySQL database data with a CSV file, applying specific data cleaning (trimming whitespace, standardizing nulls) to ensure accurate matching.

ecnu-icalk Skill

Calcula la medida de eficiencia técnica de Farrell (orientada a output) para entidades con 3 inputs y 3 outputs utilizando Excel, identificando los ratios óptimos y las observaciones eficientes.

ecnu-icalk Skill

Convertit une description textuelle structurée d'un modèle de données (entités, associations, clés étrangères, règles de fusion) en code SQL CREATE TABLE. Applique les fusions de tables spécifiées et respecte les contraintes d'intégrité référentielle.

ecnu-icalk Skill

Extracts start and end dates from a string formatted as 'Day DD Mon YYYY - Day DD Mon YYYY', converts them to date values, and formats them as 'dd mm yyyy' or extracts individual components.

ecnu-icalk Skill

Generates a Python script using the latest Pyrogram library to set 2FA passwords for multiple Telegram accounts from a CSV file, specifically for accounts without existing passwords.

ecnu-icalk Skill

Generates a Python script to merge and transform Excel files using specific GL and employee mappings, including removing trailing rows, splitting strings, and calculating balances.

ecnu-icalk Skill

Generates VBA code to color rows based on column values (e.g., FREE/PAID) and the presence of a marker (e.g., X) in the row, while ensuring empty cells are white.

ecnu-icalk Skill

Develops a Node.js server to ingest Excel/CSV data, preprocess it (date formatting, validation), store in MongoDB by transaction type, and forward to external APIs with processing time tracking and idempotency checks.

ecnu-icalk Skill

Automates catalyst activity analysis from CSV: computes per-sample mean conversion or degradation rate after 3-sigma outlier removal within each group, anchors 'Control' (case-insensitively detected) at the first bar position with distinct gray styling, sorts remaining samples by descending mean activity, generates a publication-ready bar chart with Chinese/English label support, and annotates samples with mean <5% as 'INACTIVATION ZONE'. Supports catalytic conversion and photocatalytic degradation data.

ecnu-icalk Skill

Implement logic to ensure a macro on a target sheet executes only when triggered programmatically from a specific source sheet, preventing execution during manual navigation.

ecnu-icalk Skill

Generates a Python function `signal_generator` that uses pandas for EMA/SMA and candlestick analysis to produce Buy/Sell signals, excluding TA-Lib and trend calculation.

ecnu-icalk Skill

Scaffolds a scalable Node.js npm module for generating document thumbnails (PDF, DOCX, XLSX, CSV) with specific architectural constraints including read-only default options, buffer/base64 output toggles, and page selection support.

ecnu-icalk Skill

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.

ecnu-icalk Skill

Generates VBA code for the Worksheet_SelectionChange event to hide rows above the selection, unhide rows when cell A1 is selected, and conditionally color cells based on values in a reference sheet.

ecnu-icalk Skill

Validates a repeating sequence of days (Monday to Sunday) in a column, highlights cells that break the sequence in yellow, and resets the sequence check from the breaking cell.

ecnu-icalk Skill

Generates VBA code to trigger a UserForm upon numeric entry in a specific column and writes form data to specific columns on the same row, handling the selection offset caused by pressing Enter.