Data & Analytics

ecnu-icalk Skill

Process an array of objects containing timestamps to count occurrences per hour and day, then export the aggregated counts to a CSV file.

ecnu-icalk Skill

Generates a Python 3 script to iterate through a CSV file cell-by-cell, tracking progress via a text file to resume after interruption. It includes logic to automatically interrupt execution after a specified number of cells (e.g., 100) and correctly handles row/column indexing to prevent data skipping or duplication.

ecnu-icalk Skill

Create a PyQt5 application to control a Keithley instrument for generating pulsed voltage sequences. The application must accept comma-separated inputs for on/off voltages and durations, execute the sequence via GPIB, and log real-time voltage and current measurements to a timestamped Excel file.

ecnu-icalk Skill

Generates VBA code to extract unique, non-blank values from a specific column in a source sheet based on a ComboBox selection, outputting them vertically to a destination sheet.

ecnu-icalk Skill

Modifies OCR entity mapping code to handle duplicate entity values by assigning unique bounding boxes, reversing the dataframe for 'amounts_and_tax' sections, and ensuring no coordinate overlap for multi-token entities.

ecnu-icalk Skill

Generates an Excel nested IF formula to determine task status (Completed, Incomplete, or Pending) by comparing a Target column against an Actual column and appending the status to an ID column.

ecnu-icalk Skill

Generates Python code using pandas to batch process CSV files, including deleting columns, converting date formats to Year.Month, enforcing UTF-8 encoding, and adding process completion markers.

ecnu-icalk Skill

Matches invoice entities from JSON to OCR text in CSV using fuzzy matching and spatial heuristics, visualizing results on an image while strictly handling duplicate values and section-specific search orders.

ecnu-icalk Skill

Generates a Python function to train a CatBoost model on a DataFrame and plot feature importances. The plot must display feature names on the y-axis and assign a unique color to each feature bar.

ecnu-icalk Skill

Generates a Python script using pandas to iterate through CSV files in a directory, split the first column into multiple columns based on a comma delimiter, and save the result.

ecnu-icalk Skill

Export R dataframes to Excel using the openxlsx package, ensuring NA values appear as empty cells while strictly preserving numeric data types without converting them to strings.

ecnu-icalk Skill

Implements a Python-based query executor that converts informal keywords to SQL commands, parses queries preserving string literals, and executes operations on pandas DataFrames.

ecnu-icalk Skill

Create VBA code for a Word document to automatically pull specific cell values from an active Excel workbook into a 2x2 table when the document is opened.

ecnu-icalk Skill

Создание и корректировка SQL-запросов для базы данных ClickHouse (таблица ComponentsRaw.flow) с учетом специфических правил преобразования типов портов и синтаксических ограничений.

ecnu-icalk Skill

Generates Python code or algorithms to render text-to-speech using 11Labs API by managing multiple accounts from an Excel file, respecting character limits, and splitting text across keys.

ecnu-icalk Skill

Implement comprehensive logging, checkpointing, and visualization for a Reinforcement Learning training loop, tracking rewards, losses, actions, states, entropy, and performance metrics using CSV and log files.

ecnu-icalk Skill

Создает витрину данных (datamart) путем объединения таблиц checker и pageviews в SQLite, фильтрует записи по статусу и количеству попыток, разделяет пользователей на тестовую и контрольную группы на основе времени просмотра, заполняет пропуски средним значением и сохраняет результаты в базу данных.

ecnu-icalk Skill

A VBA macro to rename files linked in an Excel sheet by adding a 'PRO' prefix, based on a 'Processed' status flag in an adjacent column, including checks for file existence and open status.

ecnu-icalk Skill

Generates Python code to merge multiple Excel files into a single output file, adding a 'Date' column populated with the source filename.

ecnu-icalk Skill

Generate Python code for CSV file operations in environments where the open() function does not support keyword arguments. Output only the code block without explanations.

ecnu-icalk Skill

Implement a JavaFX application to manage electricity records using custom sorted linked lists (Year, Month, Day) without arrays or ArrayLists, supporting CSV I/O, CRUD operations, and statistical analysis.

ecnu-icalk Skill

Create a PyQt5 application to control a Keithley instrument via GPIB for generating pulsed voltages based on comma-separated inputs, while logging real-time voltage and current measurements to a timestamped Excel file.

ecnu-icalk Skill

Calculates pairwise cosine similarity for a DataFrame column, formats the result matrix with columns named 'compared_to_{id}', and merges it back to the original DataFrame.

ecnu-icalk Skill

Guides the user through calculating days inventory in stock and goodwill ratios in Excel, grouping data by business sectors derived from SIC codes.

ecnu-icalk Skill

Extracts seasonality features (specifically STL features) from a panel time series dataset to determine the optimal season length for forecasting models. Handles conversion from Polars to Pandas and ensures correct data formatting.

ecnu-icalk Skill

Create an Excel spreadsheet to calculate the Factor of Safety (FOS) for slope stability using the Ordinary Method of Slices, accommodating multiple soil layers and circular failure surfaces.

ecnu-icalk Skill

Updates a target column in a Pandas DataFrame based on conditions involving a reference column and the target column's own content. Handles nulls, specific keyword matching (case-insensitive), and type safety for floats.

ecnu-icalk Skill

Extracts unique, non-blank values from a specific column in a source sheet based on a ComboBox selection, displaying them vertically in a destination sheet.

ecnu-icalk Skill

Generates specific sections of an onboarding playbook from the perspective of a data analytics manager, adhering to specific team objectives and paragraph formatting.

ecnu-icalk Skill

Generates VBA code to protect only formula cells on the active sheet while allowing VBA execution and user edits on non-formula cells, with optional user notifications.

ecnu-icalk Skill

Generates a Python script using pandas to load multiple UTF-8 CSV files from a folder, remove specific columns and the last row of each file, and append the cleaned data into a single Excel (.xlsx) file.

ecnu-icalk Skill

Создание вторичного пакета Oracle PL/SQL, который включает вызовы процедур из основного пакета, использует коллекции для выборки и вывода данных, передает данные через параметры и обрабатывает исключения.

ecnu-icalk Skill

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.

ecnu-icalk Skill

Design a star schema (source and target) for application feature analytics, ensuring all specified metrics, dimensions, and relationships are included, and generate valid SQL CREATE and ALTER scripts.

ecnu-icalk Skill

Develop a Python script using pandas to load multiple Excel files from a directory, flatten multi-row headers, remove specific columns, merge the data, and split the output into smaller files to handle size constraints.

ecnu-icalk Skill

Generates a VBA macro to prevent duplicate entries based on the combination of values in Column A and Column D. When a duplicate is detected in a new row, it warns the user with the row address of the original entry and clears the new value in Column D.