skills.rest
Shubhamsaboo
ShubhamsabooCOMMUNITY
Explore all skills by this author →
Website𝕏@Saboo_Shubham_GitHub

data-analyst

Analyze datasets using SQL and pandas for extraction and reporting.

132k|19.4k|Updated Apr 29, 2024
Search Tags:#SQL#pandas#statistics#transformation#data-analysis#data-cleaning
One-click install
npx skills add https://github.com/Shubhamsaboo/awesome-llm-apps --skill data-analyst-shubhamsaboo
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: data-analyst
Source: https://github.com/Shubhamsaboo/awesome-llm-apps/tree/main/awesome_agent_skills/data-analyst
Command: npx skills add https://github.com/Shubhamsaboo/awesome-llm-apps --skill data-analyst-shubhamsaboo

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill addresses the challenge of turning raw data into actionable insights by enabling structured data analysis using SQL and Python's pandas.

Core Features & Use Cases

  • SQL querying: write and optimize queries to extract and summarize data from relational databases.
  • Pandas data manipulation: clean, transform, and analyze data within Python.
  • Statistics & insights: perform descriptive statistics and derive data-driven conclusions.
  • Use Case: Example: a business user wants to compute monthly revenue by region from a sales database and prepare a clean dataset for reporting.

Quick Start

Analyze a sample dataset with the data-analyst skill to compute the total revenue by category in sales.csv.

Frequently Asked Questions about data-analyst

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I clean and transform raw data for analysis using pandas?▼

To clean and transform raw data with pandas, you use this Skill to perform structured data manipulation, handling missing values and reshaping datasets to prepare clean inputs for extracting actionable insights.

Can I use SQL to extract and summarize data from a relational database?▼

Yes, you can use SQL to extract and summarize data from a relational database. This Skill writes and optimizes queries to pull structured data, enabling computation of metrics like monthly revenue by region.

What is the best way to compute descriptive statistics on a dataset?▼

The best way to compute descriptive statistics on a dataset is using this Skill, which applies statistical analysis techniques to derive data-driven conclusions and generate basic reporting outputs.

Does this data analysis workflow require Python and pip installed?▼

Yes, this data analysis workflow requires Python with pandas and SQL tooling installed via pip. Setting up this standard development environment is necessary to execute the data exploration and transformation tasks.

How do I compute total revenue by category from a CSV file?▼

You compute total revenue by category from a CSV file by analyzing the sample dataset with this Skill. It leverages pandas data manipulation to group, aggregate, and summarize the sales data for reporting.

Related Skills

Explore More Data & Analytics Skills→
vibeingingvibeinging
49

xlsx

Read, analyze, and generate results from Excel and CSV files.

Community
Intermediate
rar-filerar-file
42

Data Analyst

Analyze datasets to extract insights and present actionable findings.

Community
Intermediate
ya-wayya-way

seaborn

Generate publication-ready statistical visuals from datasets using seaborn.

Community
Intermediate
Phife726Phife726

data-analyst

Analyze datasets with SQL, pandas, and statistical methods.

Community
Intermediate