excel-data-merge-transformation-pipeline
Generates a Python script to merge and transform Excel files using specific GL and employee mappings, including removing trailing rows, splitting strings, and calculating balances.
Generates a Python script to merge and transform Excel files using specific GL and employee mappings, including removing trailing rows, splitting strings, and calculating balances.
Execute a univariate time series forecasting pipeline using StatsForecast and Polars. Includes ID concatenation, cross-validation, ensemble generation (AutoARIMA, AutoETS, DynamicOptimizedTheta), non-negative constraints, outlier-aware metrics, and formatted output with specific type casting for split IDs.
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.
Generates a Markdown table dataset of math problems with specific columns for descriptions, solutions, and detailed derivations, adhering to strict output constraints regarding completeness and formatting.
Constructs mathematical models and MATLAB simulations for human population growth coupled with information diffusion, incorporating user-defined feedback loops and carrying capacity constraints.
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.
Calculates the area of a circle given the diameter, using 3.14 for pi, without rounding the result, and including the correct unit.
Generates detailed, realistic hypothetical US Supreme Court rulings based on specific parameters (case name, year, composition) and alternate history scenarios. Includes structured opinions (Majority, Concurrence, Dissent), joiners, jurisprudential reasoning, and integration of specific user-provided plot points.
Generates arithmetic problems (add, subtract, multiply, divide) involving decimal numbers with specific digit constraints and provides the answers.
Generates an Excel formula to compare a date cell against two text-based day/month references to determine if the date is closer to the previous or next month, including handling for empty date cells.
Generates detailed alternate timelines based on a user-defined Point of Divergence (PoD), reflecting historical context and comparing the outcome to the original timeline.
Generates a list of female characters from specified anime franchises paired with a target male character, followed by a hypothetical dating scenario describing the relationship dynamics.
Generates a custom word problem scenario involving two variables, models it with standard form equations, converts them to slope-intercept form, and solves the system while ensuring the solution fits within a 0-10 graph range.
Calculates the number of disorder pairs (inversions) in a list where i < j and pi > pj, optimized for large datasets.
Generates standardized SCP Foundation logs (Test, Interview, Event, Discussion, Experiment, Analysis) featuring SCP-085, SCP-079, SCP-914, and SCP-978. Adheres to strict character constraints, clinical tone, mandatory anomalous events, and specific formatting including table headers.
Compares entities (e.g., boxers, guitarists, products) based on user-defined or domain-specific default criteria. Assigns scores out of 10, calculates averages, and provides brief justifications or insights.
Generates a synthetic dataset of math problems in a Markdown table with specific columns, detailed derivations, and strict behavioral constraints regarding output completeness and tone.
Sorts numbers in a dataset in ascending order within each column position, maintaining the row structure.
Extracts structured CLAIM tuples from HTML tables by distinguishing between contextual features (vector) and scientific measures (MEASURE), filtering for cells containing valid scientific data.
Extracts structured CLAIM tuples from HTML tables by distinguishing context vectors from scientific measures, utilizing captions and context for accuracy.