from db-gpt18,480
Analyze Walmart weekly sales versus unemployment to produce charts, regression analysis, and a polished HTML report with business recommendations.
This skill ingests a Walmart sales CSV (Store, Date, Weekly_Sales, Unemployment) and performs deep exploratory analysis: correlation heatmaps, sales vs. unemployment regression with interpretation, time-series trend charts per store, cross-store comparisons, and a consolidated responsive HTML report that bundles charts and actionable recommendations.
Use this skill when you need quick, data-driven insights into how macroeconomic factors (unemployment) relate to store-level sales performance — useful for analysts, regional managers, and data teams preparing executive summaries. Ideal for one-off analyses or regular reporting when given a standardized CSV.
scripts/generate_html_report.py (generates full report and charts), scripts/generate_correlation_heatmap.py, scripts/generate_sales_unemployment_scatter.py, scripts/generate_time_series_trend.py, scripts/generate_store_avg_comparison.py.templates/report_template.html for generating a responsive HTML report.input_file and output_dir, and presenting the result via an HTML interpreter/UI.Best used with agents that can run provided scripts and render HTML outputs (agents with script-execution or code-runner tools such as Copilot/Codex-like execution tools, or integrations that allow execute_skill_script_file and html_interpreter).
Walmart sales data analyzer from DB-GPT that generates correlation heatmaps, scatter plots, time series trends, and an HTML report comparing sales vs unemployment. All 6 scripts failed to run due to missing pandas/matplotlib/seaborn dependencies. Code is functional but lacks input validation and error handling. Tied to DB-GPT-specific tooling (execute_skill_script_file, html_interpreter) which limits general usability.
matplotlibpandasseabornNo security concerns — scripts only read/write local files with no network calls, no credentials, no destructive commands. Architecture is decent with modular scripts and a template directory, but the DB-GPT tool coupling significantly limits portability. Niche usefulness — only relevant for users with Walmart-format CSV data running inside DB-GPT.
