data-analysis
304
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.
ECNU-ICALK
data-ai
sorting
stars
current ordering strategy
query
all entries
refine the visible subset
data-analysis
304
matlab-hsihsv
用于将图像像素在RGB、HSV或HSI颜色空间中进行三维散点图可视化。核心逻辑是将色调(H)映射为角度，饱和度(S)映射为半径，亮度(I/V)映射为高度，从而在圆柱体或圆锥体中显示像素分布，并支持在RGB空间添加对角线。
ECNU-ICALK
data-ai
data-analysis
304
sort-number-rows-by-column-in-ascending-order
Sorts numbers in a dataset in ascending order within each column position, maintaining the row structure.
ECNU-ICALK
data-ai
data-analysis
304
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.
ECNU-ICALK
data-ai
data-analysis
304
lottery-frequency-optimizer
Analyzes provided lottery number series to generate optimized combinations based on frequency, supporting specific formats like '5 numbers + 2 stars'.
ECNU-ICALK
data-ai
data-analysis
304
matlab-mixed-gaussian-simulation-analysis
使用MATLAB生成符合Z=X+nY公式的混合高斯分布随机数，计算理论期望与方差，计算统计量U，并绘制频率分布直方图以分析样本量n的影响。
ECNU-ICALK
data-ai
data-analysis
304
pyspark-user-activity-log-analysis
Analyze website logs by joining user activity with user info using PySpark, calculating average time and popular pages, and utilizing accumulators and broadcast variables.
ECNU-ICALK
data-ai
data-analysis
304
scientific-claim-tuple-extraction
Extracts structured CLAIM tuples from HTML tables by distinguishing between contextual features (vector) and scientific measures (MEASURE), filtering for cells containing valid scientific data.
ECNU-ICALK
data-ai
data-analysis
304
calculate-and-list-distances-in-kilometers
Calculates the distance from a specified origin (defaulting to Melbourne) to a list of addresses and outputs only the kilometer values without any additional text or labels.
ECNU-ICALK
data-ai
data-analysis
304
python-chart-data-structure-generator
Generates Python code to create various types of charts (Line, Scatter, Bar, Heatmap, etc.) using explicit data structures like dictionaries or lists.
ECNU-ICALK
data-ai
data-analysis
304
html-table-to-scientific-claim-extraction
Extracts structured CLAIM tuples from HTML tables by distinguishing context vectors from scientific measures, utilizing captions and context for accuracy.
ECNU-ICALK
data-ai
data-analysis
304
matlab-csv
生成Matlab脚本，用于从CSV文件中提取A、B、C列，保存为新文件，并计算每列的最大值和最小值，最后将统计结果输出到新的Sheet表格中。
ECNU-ICALK
data-ai
data-analysis
304
polars-mstl-decomposition-data-preparation
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
data-ai
data-analysis
304
polars-data-cleaning-for-box-cox-transformation
Use Polars to clean a specific column for Box-Cox transformation by counting and replacing negative values with zero, and counting and replacing zero values with a small constant (e.g., 0.01).
ECNU-ICALK
data-ai