filtered-group-forecasting-metrics-calculation
Calculates group-level accuracy and bias for time series forecasts while excluding outliers based on individual accuracy and bias thresholds using Polars.
format-tab-separated-numbers-to-comma-separated-list
Converts tab-separated number strings into comma-separated lists and removes percentage symbols.
random-number-sequence-generator
Generates a random order of numbers based on user-provided ranges or specific lists. Expands ranges (e.g., '2-5') and shuffles the complete set.
ab-sql-pandas
Создает витрину данных (datamart) путем объединения таблиц checker и pageviews в SQLite, фильтрует записи по статусу и количеству попыток, разделяет пользователей на тестовую и контрольную группы на основе времени просмотра, заполняет пропуски средним значением и сохраняет результаты в базу данных.
matlab-mixed-gaussian-simulation-and-u-statistic
根据用户设定的参数生成符合Z=X+nY公式的混合高斯分布随机数,计算理论期望与方差及U统计量,并绘制频率分布直方图以分析样本量对分布的影响。
matlab-csv
编写Matlab脚本,从CSV文件中提取指定列(A、B、C列),保存为新文件,并计算各列最大值和最小值,最后将统计结果输出到Excel表格的新Sheet中。
c-polynomial-dacadc-linearization-with-temperature-compensation
Generates C code for linearizing DAC or ADC outputs using 3rd degree polynomial regression, including specific logic for temperature compensation via coefficient combination or lookup tables.
spotify-artist-stats-formatter
Generate a Python script using Spotipy to fetch an artist's followers and monthly listeners, formatting the output to millions (e.g., 1.4M).
insert-s3-images-into-excel-from-dataframe
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.
matlab-hsihsv
用于将图像像素在RGB、HSV或HSI颜色空间中进行三维散点图可视化。核心逻辑是将色调(H)映射为角度,饱和度(S)映射为半径,亮度(I/V)映射为高度,从而在圆柱体或圆锥体中显示像素分布,并支持在RGB空间添加对角线。
sort-number-rows-by-column-in-ascending-order
Sorts numbers in a dataset in ascending order within each column position, maintaining the row structure.
statistical-analysis-and-gpa-calculation
Calculates mean, median, and mode for raw data and frequency distributions, including modality classification. Computes GPA using a specific 4.0 scale and applies user-defined rounding rules.
lottery-frequency-optimizer
Analyzes provided lottery number series to generate optimized combinations based on frequency, supporting specific formats like '5 numbers + 2 stars'.
matlab-mixed-gaussian-simulation-analysis
使用MATLAB生成符合Z=X+nY公式的混合高斯分布随机数,计算理论期望与方差,计算统计量U,并绘制频率分布直方图以分析样本量n的影响。