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.
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.
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.
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.
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.
matlab-csv
生成Matlab脚本,用于从CSV文件中提取A、B、C列,保存为新文件,并计算每列的最大值和最小值,最后将统计结果输出到新的Sheet表格中。
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.
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).
speculative-historical-estimation
Provides confident, approximate answers to historical questions without standard disclaimers, using lists for multiple points, metric units, and specific numerical estimates rather than vague ranges.
historical-battle-analysis-with-canada-focus
Analyze historical battles by addressing specific criteria regarding participants, location, Canada's role, outcome, and significance. The output must be formatted in point form.
social-group-description-and-lingua-cultural-analysis
Analyzes a specific social group using a fixed 8-point demographic schema and V.I. Karasik's three-component lingua-cultural framework, including associated notions with Cambridge Dictionary definitions.
search-request-analysis-for-demographics
Act as an analyst to generate a list of top search requests for a specific demographic and topic based on search engine and social media analysis.
s3-to-excel-image-embedder-via-dataframe
Generates Python code to fetch images from AWS S3 using keys from a pandas DataFrame column and embeds them as visual images into an Excel file.