Communitygithub.com

cdcoonce/Portfolio_Website

Charles 构建生产级数据管道,从多个来源摄取、转换和验证数据。作为 Clearway Energy Group 的数据工程师 I,他日常使用 Dagster、dbt、Polars 和 Snowflake 来自动化可再生能源资产数据工作流。

Portfolio_Website 是什么?

该技能概述了 Charles 在数据工程与分析领域的综合能力。他专注于构建生产级数据管道,熟练使用 Dagster、dbt、dlt、Polars、Snowflake 和 DuckDB 等工具。此外,他还具备统计建模、机器学习、数据可视化和仪表板开发等技能,并擅长使用 SQL 进行数据库分析。他的工作流涉及从多个来源(包括 API、空间数据和 web)摄取、转换和验证数据,并运用 ETL/ELT 模式和增量加载策略。该技能适用于需要端到端数据工程解决方案的平台,如 Claude Code 或 Cursor,通过展示其 GitHub 仓库中的实际项目,帮助 AI 代理准确理解其专业背景。

兼容平台~Claude Code~Codex CLI~Cursor
npx skills add https://github.com/cdcoonce/Portfolio_Website/tree/HEAD/WebContent/context

在你喜欢的 AI 中提问

打开一个已预加载此 Agent Skill 的新对话。

文档

技能概述

数据工程与管道

Charles 构建生产级数据管道,从多个来源摄取、转换和验证数据。作为 Clearway Energy Group 的数据工程师 I,他日常使用 Dagster、dbt、Polars 和 Snowflake 来自动化可再生能源资产数据工作流。他具备设计 ETL/ELT 流程的经验,这些流程处理 API 集成、空间数据连接和增量加载模式。

工具与技术: Python, Dagster, dbt, dlt, Polars, Snowflake, DuckDB, Hex

展示项目: 可再生能源资产性能管道、住房可负担性与通勤分析、Google Analytics 数据归档、能源分析管道、合成信号观测站


统计分析与建模

Charles 应用严格的统计方法回答研究问题并验证发现。他的工作包括带有稳健标准误的 OLS 回归、方差分析、交互模型、分位数回归和交叉验证。他擅长使用 AIC 选择模型规范、使用 VIF 诊断多重共线性,并向技术及非技术受众解读结果。

工具与技术: Python (statsmodels, scipy), scikit-learn, R

展示项目: 住房可负担性与通勤分析、葡萄酒质量分析、埃姆斯房价预测、睡眠剥夺分析


机器学习

Charles 具备构建和评估监督学习模型的经验,涵盖回归和分类任务。他曾使用线性模型、k-近邻、随机森林、XGBoost、神经网络(TensorFlow/Keras)和堆叠集成学习。他应用特征工程、交叉验证、超参数调优以及 SHAP 等模型可解释性技术来理解和沟通模型行为。

工具与技术: scikit-learn, TensorFlow/Keras, XGBoost, SHAP

展示项目: 埃姆斯房价预测、Spaceship Titanic 分类、葡萄酒质量分析、住房可负担性与通勤分析


数据可视化与仪表板

Charles 创建的可视化和交互式仪表板使决策者能够轻松访问数据。他构建了带有动态筛选和交互式表格的 R Shiny 仪表板、带有参数化视图的 Tableau 仪表板,以及使用 Matplotlib 和 Streamlit 的 Python 可视化。他注重清晰性、合适的图表选择,并让数据背后的故事易于理解。

工具与技术: Tableau, R Shiny, Matplotlib, Streamlit, ggplot2, Plotly

展示项目: 全球 CO₂ 排放仪表板、国家公园访问量仪表板、世界幸福指数仪表板、合成信号观测站、住房可负担性与通勤分析


SQL 与数据库分析

Charles 编写 SQL 用于数据提取、转换和分析查询。他熟悉聚合、窗口函数(RANK, ROW_NUMBER)、CTE、子查询、连接和集合操作。他既使用传统关系数据库,也使用 DuckDB 和 Snowflake 等现代分析引擎。

工具与技术: SQL (MySQL, Snowflake, DuckDB)

展示项目: 餐厅销售分析、婴儿名字分析、机动车盗窃分析、可再生能源资产性能管道、能源分析管道


电子表格与业务分析

Charles 将 Excel 作为分析工具使用——不仅用于数据录入,还用于构建包含数据透视表、VLOOKUP/SUMIFS、条件格式、帕累托图和热力图的结构化分析。他的电子表格工作侧重于将原始运营数据转化为可执行的业务洞察。

工具与技术: Excel (数据透视表、Power Query、VLOOKUP、SUMIFS、条件格式、组合图)

展示项目: 制造停机时间分析、纽约市碰撞分析


数据处理与 ETL

Charles 定期清理、转换和整合来自多个来源的杂乱数据集。他处理表格数据、空间数据(shapefile、GeoJSON)和 API 响应。他精通使用 Pandas 和 Polars 进行 DataFrame 操作,以及使用 GeoPandas 进行空间连接和地理分析。

工具与技术: Python (Pandas, Polars, GeoPandas), API 集成, Census ACS, OpenStreetMap Overpass

展示项目: 住房可负担性与通勤分析、电力消耗分析、AirBnB 房源分析、Google Analytics 数据归档


Web 开发

Charles 使用纯 HTML5、CSS3 和 ES 模块 JavaScript 从头构建了他的个人作品集网站——没有使用任何框架或打包工具。该网站具备响应式设计、可访问性标记(WCAG 2.1 AA)、带有 URL 驱动筛选的可筛选项目画廊以及一个评价轮播图。他采用专业实践维护代码库,包括代码检查、自动化测试和 CI/CD 部署。

工具与技术: HTML5, CSS3, JavaScript (ES Modules)

展示项目: 个人作品集网站


DevOps 与工具链

Charles 使用现代开发工具来维护代码质量和自动化工作流。他使用 GitHub Actions 设置 CI/CD 管道,使用 pytest 和 Jest 编写测试,使用 uv 管理 Python 环境,并使用代码检查工具(ESLint、Stylelint、Ruff)和格式化工具(Prettier)强制执行代码标准。他遵循常规提交和语义化版本控制实践。

工具与技术: Git, GitHub Actions, CI/CD, uv, pytest, Jest, Playwright, ESLint, Stylelint, Ruff, Prettier

展示项目: 个人作品集网站、可再生能源资产性能管道、住房可负担性与通勤分析

Individual skills in this repo

This repo contains 20 individual skills — each has its own dedicated page.

cdcoonce/Portfolio_Website

Git commit workflow with enforced conventional commit style. Use when Claude needs to stage and commit changes, craft commit messages, or the user asks to commit, make a commit, or save their work. Ensures consistent commit message format, proper scoping, and atomic commits across the project.

cdcoonce/Portfolio_Website

AI-powered code quality analysis for Python, Markdown, and Mermaid diagrams. Use this skill when: (1) reviewing code for quality issues, (2) checking Python files for PEP8 violations, unused code, missing type hints, docstring problems, complexity issues, or potential runtime errors, (3) validating Markdown documentation for broken links, heading structure, or formatting issues, (4) validating Mermaid diagram syntax, (5) the user asks for a "code review" or "quality check", (6) analyzing code snippets pasted in conversation, or (7) suggesting and applying fixes for code quality issues.

cdcoonce/Portfolio_Website

Deploy the portfolio chat agent Lambda function to AWS. Use when the user asks to deploy, redeploy, push to Lambda, update the chat agent, or after updating context files or lambda_function.py. Rebuilds the knowledge base, packages dependencies, and deploys to AWS Lambda.

cdcoonce/Portfolio_Website

Generate multiple radically different interface designs for a module using parallel sub-agents. Use when user wants to design an API, explore interface options, compare module shapes, or mentions "design it twice".

cdcoonce/Portfolio_Website

Orchestrate the full GitHub-issues-driven development lifecycle. 7-phase pipeline from brainstorm through PR with state tracking and cross-conversation resume. Use when user says "dev cycle", "development workflow", "full development pipeline", or invokes /dev-cycle.

cdcoonce/Portfolio_Website

Production Python coding standards with automatic version detection (3.10-3.13). Use when writing, reviewing, or refactoring Python to ensure adherence to modern type syntax, LBYL exception handling, pathlib operations, ABC-based interfaces, and production-tested patterns. Not Dagster-specific - applies to any Python project.

cdcoonce/Portfolio_Website

Set up Claude Code hooks to block dangerous git commands (push, reset --hard, clean, branch -D, etc.) before they execute. Use when user wants to prevent destructive git operations, add git safety hooks, or block git push/reset in Claude Code.

cdcoonce/Portfolio_Website

GitHub CLI (gh) integration for managing issues, pull requests, branches,

cdcoonce/Portfolio_Website

Interview the user relentlessly about a plan or design until reaching shared understanding, resolving each branch of the decision tree. Use when user wants to stress-test a plan, get grilled on their design, or mentions "grill me".

cdcoonce/Portfolio_Website

Explore a codebase to find opportunities for architectural improvement, focusing on making the codebase more testable by deepening shallow modules. Use when user wants to improve architecture, find refactoring opportunities, consolidate tightly-coupled modules, or make a codebase more AI-navigable.

cdcoonce/Portfolio_Website

CEO/founder-mode plan review. Rethink the problem, find the 10-star product, challenge premises, expand scope when it creates a better product. Three modes: SCOPE EXPANSION (dream big), HOLD SCOPE (maximum rigor), SCOPE REDUCTION (strip to essentials). Use when the user asks for a plan review, CEO review, mega review, or wants a plan challenged/stress-tested before implementation.

cdcoonce/Portfolio_Website

Break a PRD into independently-grabbable GitHub issues using tracer-bullet vertical slices. Use when user wants to convert a PRD to issues, create implementation tickets, or break down a PRD into work items.

cdcoonce/Portfolio_Website

Turn a PRD into a multi-phase implementation plan using tracer-bullet vertical slices, saved as a local Markdown file in docs/plans/. Use when user wants to break down a PRD, create an implementation plan, plan phases from a PRD, or mentions "tracer bullets".

cdcoonce/Portfolio_Website

Generate or update the `.claude/docs/project.md` file that gives Claude project-specific context. Use this skill when the user asks to create, update, regenerate, or refresh project context, or says things like "update project.md", "generate project context", "this repo needs a project.md", or "Claude doesn't know about this project". Also trigger when onboarding Claude to a new repository for the first time.

cdcoonce/Portfolio_Website

Generate comprehensive, high-quality README.md files for code repositories. Use this skill whenever the user asks to create, write, generate, update, or improve a README for any project or repository. Also trigger when the user says things like "document this project", "write docs for this repo", "this repo needs a README", "help me onboard developers to this codebase", or asks for project documentation in markdown. Even if the user just says "README" or "readme" in the context of a codebase, use this skill.

cdcoonce/Portfolio_Website

Create a detailed refactor plan with tiny commits via user interview, then file it as a GitHub issue. Use when user wants to plan a refactor, create a refactoring RFC, or break a refactor into safe incremental steps.

cdcoonce/Portfolio_Website

Set up pre-commit hooks for the current repo. Use when user wants to add pre-commit hooks, configure commit-time linting, formatting, type checking, or testing. Triggers on "pre-commit", "git hooks", "linting hooks", or /setup-pre-commit.

cdcoonce/Portfolio_Website

Test-driven development with red-green-refactor loop. Use when user wants to build features or fix bugs using TDD, mentions "red-green-refactor", wants integration tests, or asks for test-first development.

cdcoonce/Portfolio_Website

Triage a bug or issue by exploring the codebase to find root cause, then create a GitHub issue with a TDD-based fix plan. Use when user reports a bug, wants to file an issue, mentions "triage", or wants to investigate and plan a fix for a problem.

cdcoonce/Portfolio_Website

Rewrites the prose sections of wiki pages in-place. Reads source files to understand current context, then updates only the content inside <!-- claude:prose --> ... <!-- claude:prose:end --> markers. Never touches <!-- generated:start --> ... <!-- generated:end --> blocks. Supports targeting a single page with /update-wiki {PageName}.

相关技能