Skill

SkillsData & Databases › Data engineering & pipelines

Excel Analysis

Analyze Excel spreadsheets, create pivot tables, generate charts, and perform data analysis. Use when analyzing Excel files, spreadsheets, tabular data, or .xlsx files.

Freerisk: low
excelanalysispythonopenaipandasxlsx

Tools: pandas

The full skill

— name: Excel Analysis description: Analyze Excel spreadsheets, create pivot tables, generate charts, and perform data analysis. Use when analyzing Excel files, spreadsheets, tabular data, or .xlsx files. — # Excel Analysis ## Quick start Read Excel files with pandas: “`python import pandas as pd # Read Excel file df = pd.read_excel("data.xlsx", sheet_name="Sheet1") # Display first few rows print(df.head()) # Basic statistics print(df.describe()) “` ## Reading multiple sheets Process all sheets in a workbook: “`python import pandas as pd # Read all sheets excel_file = pd.ExcelFile("workbook.xlsx") for sheet_name in excel_file.sheet_names: df = pd.read_excel(excel_file, sheet_name=sheet_name) print(f"\n{sheet_name}:") print(df.head()) “` ## Data analysis Perform common analysis tasks: “`python import pandas as pd df = pd.read_excel("sales.xlsx") # Group by and aggregate sales_by_region = df.groupby("region")["sales"].sum() print(sales_by_region) # Filter data high_sales = df[df["sales"] > 10000] # Calculate metrics df["profit_margin"] = (df["revenue"] – df["cost\c:[["$","$L1a",null,{"locale":"en","skill":{"id":"davila7-claude-code-templates-cli-tool-components-skills-enterprise-communication-excel-analysis-skill-md","name":"excel-analysis","author":"davila7","authorAvatarUrl":"https://avatars.githubusercontent.com/u/6216945?v=4"}}],["$","$L1b",null,{"locale":"en","skill":{"id":"davila7-claude-code-templates-cli-tool-components-skills-enterprise-communication-excel-analysis-skill-md","name":"excel-analysis","author":"davila7","authorAvatar":"https://avatars.githubusercontent.com/u/6216945?v=4","description":"Analyze Excel spreadsheets, create pivot tables, generate charts, and perform data analysis. Use when analyzing Excel files, spreadsheets, tabular data, or .xlsx files.","githubUrl":"https://github.com/davila7/claude-code-templates/tree/main/cli-tool/components/skills/enterprise-communication/excel-analysis","skillContent":null,"hasMarketplaceJson":true},"files":[{"id":"9b6dd538-b948-4a13-82a5-a45c7cfb0428","skillId":"davila7-claude-code-templates-cli-tool-components-skills-enterprise-communication-excel-analysis-skill-md","path":"SKILL.md","name":"SKILL.md","type":"file","size":5166,"content":"$1c","isBinary":false}],"fileTree":[{"name":"SKILL.md","path":"SKILL.md","type":"file","size":5166,"children":"$undefined"}],"hasFiles":true,"updatedAtText":"3 months ago","t":{"common":{"loading":"Loading…","error":"Error","search":"Search","searchPlaceholder":"AI Search","cancel":"Cancel","confirm":"Confirm","save":"Save","delete":"Delete","edit":"Edit","back":"Back","next":"Next","previous":"Previous","skills":"skills","skill":"skill","available":"available","signIn":"Sign In","signOut":"Sign Out","favorites":"favorites","history":"history"},"nav":{"categories":"cd /categories","stats":"watch stats","docs":"man docs","apiDocs":"api –docs","aiSearch":"ai –search"},"hero":{"title":"Agent Skills Marketplace","subtitle":"for Claude Code, Codex & ChatGPT","skillCount":"skills","description":"Discover open-source agent skills from GitHub","description2":"Search with AI semantics or keywords, browse by category, sort by popularity. All skills use the open SKILL.md standard and are ready to install","searchPlaceholder":"Type to filter, or press ⏎ for AI search. ⇧ + ⏎ for new line","noSkillsFound":"No skills found"},"categories":{"title":"Browse by Category","description":"Explore agent skills organized by their primary use case","pageTitle":"All Categories","breadcrumb":"Categories","skillCount":"skills","info":"Agent skills are organized into parent categories and subcategories. Each category shows the total number of available skills. Click on any category to explore the skills within.","viewAll":"cd /categories && ls -la"},"skills":{"title":"Browse Agent Skills","count":"count","available":"skills available","searchAi":"search –ai","noSkillsFound":"No skills found","install":"Install","download":"Download","similar":"Similar Skills","files":"Files","readme":"README","searchPlaceholder":"Search skills with AI: try 'skills about trading', 'data analysis related skills'…","showMarketplaceOnly":"Show only skills with","sortByStars":"Sort by stars","sortByRecent":"Sort by recent"},"about":{"title":"Why Agent Skills Marketplace?","description":"Finding the right agent skill among thousands of GitHub repositories can be overwhelming. Skills Marketplace solves this by providing smart search, category filtering, and quality indicators to help you quickly find exactly what you need.","description2":"Whether you're a developer automating workflows, a team lead building custom AI tools, or a hobbyist exploring AI coding assistants, you'll find skills for every use case. All skills use the open SKILL.md standard, compatible with Claude Code, OpenAI Codex CLI, and other tools adopting this format.","info":"Ready to explore the largest collection of agent skills for AI coding assistants?","browse":"Browse","easy":"Easy","github":"GitHub","browseDescription":"Search through 25,000+ agent skills with intelligent filtering by category, author, a