Data & Analytics

ecnu-icalk Skill

Создает SQL-запросы для базы данных с фиксированной схемой (таблицы QRY_QUEUE, ST_ABONENTS, QRY_TYPE) для анализа статистики обработки сообщений, процента ошибок и данных абонентов.

ecnu-icalk Skill

Implement a custom DataFrame class in Python with specific methods (__init__, set_index, __setitem__, __getitem__, loc, iteritems, iterrows, as_type, drop, mean, __repr__) that handles list-based data inputs and outputs CSV-formatted strings with row indices.

ecnu-icalk Skill

Design a comprehensive star schema data model from business KPIs, generate MySQL DDL scripts, and create secure Python ETL scripts for daily data synchronization using upserts and complex SQL queries.

ecnu-icalk Skill

Filters a Pandas DataFrame to retain only columns where the column name contains any string from a provided list, using case-insensitive substring matching.

ecnu-icalk Skill

Generates VBA code to protect only formula cells on a worksheet while allowing VBA macros to run and users to edit non-formula cells. Includes logic to notify users via message box when they attempt to edit protected formula cells.

ecnu-icalk Skill

Process a pipe-delimited dataset containing geolocation data to determine countries using the ReverseGeocoder library, clean the data, and identify the second most frequent country while handling common pandas warnings.

ecnu-icalk Skill

A skill to join user activity and user info CSV datasets using PySpark 1.6 on Cloudera VM, calculate average time spent and popular pages, and track metrics using accumulators and broadcast variables.

ecnu-icalk Skill

Generates Excel formulas to filter rows based on a date offset from today, format the date, and concatenate values from adjacent columns with specific spacing.

ecnu-icalk Skill

Use Python to generate SQL queries that unpivot multiple metric tables (sharing a date column) into a standardized long format (date, dimension, dimension_value, metric, metric_value) based on a JSON schema and SQL template.

ecnu-icalk Skill

Guides the user in setting up an Excel spreadsheet to perform slope stability analysis using the Ordinary Method of Slices, specifically for circular failure surfaces with two distinct soil layers.

ecnu-icalk Skill

Generates Python scripts to perform daily ETL updates on MySQL databases, combining insert and update operations using UNION ALL logic and parameterized queries for security.

ecnu-icalk Skill

Generates VBA code to copy all data from a source .xlsx file to the current .xlsm workbook located in the same directory. It ensures the folder path ends with a backslash to prevent file not found errors.

ecnu-icalk Skill

Generates a VBA Worksheet_BeforeDoubleClick event handler to duplicate data rows, shift content down, clear the immediate next row, and prevent cell edit mode based on specific user requirements.

ecnu-icalk Skill

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.

ecnu-icalk Skill

Generates SQL UPDATE statements for book descriptions based on provided titles and IDs, ensuring descriptions are approximately 70 words long and exclude the book title or author name.

ecnu-icalk Skill

Guides the user in moving VBA logic from worksheet modules to a standard module to reuse code across multiple sheets, specifically handling the conversion of Private event handlers to Public subs and resolving scope/reference issues like the 'Me' keyword and 'Target' arguments.

ecnu-icalk Skill

Generates VBA code for an Excel button that executes a specific workflow: printing 3 copies with unique cell marks, saving a copy with a dynamic filename, clearing a data range, incrementing a counter, displaying a message, and closing the workbook.

ecnu-icalk Skill

Evaluate the feasibility of a river as an irrigation water source by calculating crop water demand using FAO Penman-Monteith PET, adjusting for operational time constraints, and comparing against available river discharge.

ecnu-icalk Skill

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.

ecnu-icalk Skill

Implement a multiclass logistic regression classifier from scratch using NumPy and Pandas, avoiding libraries like scikit-learn. The implementation uses a One-vs-Rest strategy to handle multiple classes (e.g., 0, 1, 2) and saves the trained model coefficients to a pickle file.

ecnu-icalk Skill

Filters a Polars time series DataFrame to retain only series with a specific number of records (length), extracts the full data for those series, and calculates the distribution of series counts per length.

ecnu-icalk Skill

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.

ecnu-icalk Skill

Generates an Excel formula to extract the substring between the first occurrence of a start character and the first occurrence of an end character when searching from the right side of the string.

ecnu-icalk Skill

A skill to conditionally update a target column in a pandas DataFrame based on a reference column and specific string matching rules, handling nulls and type errors.

ecnu-icalk Skill

Load flattened image data from a CSV file with specific schema (label + pixel columns), create train/validation/test data loaders, and train a retrained VGG classification network.

ecnu-icalk Skill

Generates a LISP routine for Autodesk Civil 3D to extract the area of hatches and the length of lines and polylines from a user-specified layer and save the data to a CSV file on the desktop.

ecnu-icalk Skill

Export R data frames to Excel using openxlsx ensuring NA values appear as empty cells while preserving numeric data types.

ecnu-icalk Skill

Designs sales compensation models for Series-A subscription-based enterprise software startups using a 6-step Monte Carlo simulation methodology. Integrates advanced analytics like predictive modeling and CLTV analysis to generate executive-level documentation such as ATS-optimized resume bullet points and interview responses.

ecnu-icalk Skill

Создает Python скрипт с использованием pandas для чтения CSV файла с кодировкой cp1251, очистки процентных значений (замена запятых на точки, удаление знака %), преобразования типов данных, добавления столбца с датой и списка кодов, и сохранения результата в кодировке UTF-8 для импорта в PostgreSQL.

ecnu-icalk Skill

Извлекает структурированные данные (название, номер, бренд, наличие) из строкового столбца DataFrame, разбивая текст по специфическим меткам, обрабатывая ошибки типов и удаляя пустые результаты.

ecnu-icalk Skill

Навык для разработки процедур на PL/pgSQL (DO-блоков), которые выполняют итерацию по данным, полученным через dblink, делают дополнительные выборки для каждого элемента, объединяют результаты и массово вставляют их в локальную таблицу.

ecnu-icalk Skill

Genera fórmulas de Excel para separar el número inicial del texto restante en celdas donde el número está pegado al texto, utilizando obligatoriamente el separador de punto y coma (;).

ecnu-icalk Skill

Desarrolla funciones SQL para calcular créditos, verificar actividad y estado VIP, y triggers para auditoría, historial de cambios, notificaciones y restricciones de negocio en una base de datos universitaria.

ecnu-icalk Skill

Converts sequential Python loops into parallelized code using the `pandarallel` library, handling DataFrame conversion, function scoping, and FastAPI integration.

ecnu-icalk Skill

Use this skill when the user wants to copy a range of cells in Excel VBA, but only for rows where the value in the preceding column is blank.

ecnu-icalk Skill

Develop a Python solution using BERT to classify speakers (agent vs. user) in a continuous conversation paragraph without newlines, trained on a CSV file of interactions, specifically optimized for CPU execution.