Communitygithub.com

Charles 的個人作品集網站

Charles 建立並維護一個生產級資料管道,用於攝取、轉換和驗證多個來源的資料。

Charles 的個人作品集網站 是什麼?

此技能文件概述了一位名為 Charles 的資料工程師的專業能力與專案。Charles 目前任職於 Clearway Energy Group,擔任 Data Engineer I,日常工作涉及 Dagster、dbt、Polars 和 Snowflake 等技術,用於自動化可再生能源資產的資料工作流程。他擁有設計 ETL/ELT 流程的經驗,能夠處理 API 整合、空間資料連結以及增量載入模式。除了資料工程,Charles 在統計分析、機器學習、資料視覺化和 SQL 方面也有深厚功底,並熟悉現代開發工具與 DevOps 實務。此技能支援的平台涵蓋 Python、R、Tableau 及多種雲端資料庫,適用於任何需要資料工程與分析能力的 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 的 Data Engineer I,他日常使用 Dagster、dbt、Polars 和 Snowflake 來自動化可再生能源資產的資料工作流程。他具備設計 ETL/ELT 流程的經驗,能處理 API 整合、空間資料連結及增量載入模式。

工具與技術: Python、Dagster、dbt、dlt、Polars、Snowflake、DuckDB、Hex

體現於: 可再生能源資產效能管線、住宅可負擔性與通勤分析、Google Analytics 資料歸檔、能源分析管線、合成訊號觀測站


統計分析與建模

Charles 應用嚴謹的統計方法來回答研究問題並驗證發現。他的工作包括使用穩健標準誤的 OLS 迴歸、ANOVA、交互作用模型、分位數迴歸和交叉驗證。他能熟練地使用 AIC 選擇模型規格、以 VIF 診斷多重共線性,並為技術與非技術受眾解讀結果。

工具與技術: Python (statsmodels, scipy)、scikit-learn、R

體現於: 住宅可負擔性與通勤分析、葡萄酒品質分析、艾姆斯房價預測、睡眠剝奪分析


機器學習

Charles 擁有針對迴歸與分類任務建立及評估監督式學習模型的經驗。他處理過線性模型、k-最近鄰、隨機森林、XGBoost、神經網路 (TensorFlow/Keras) 以及堆疊集成模型。他應用特徵工程、交叉驗證、超參數調整,以及像是 SHAP 的模型可解釋性技術,來理解並溝通模型的行為。

工具與技術: scikit-learn、TensorFlow/Keras、XGBoost、SHAP

體現於: 艾姆斯房價預測、太空船泰坦尼克號分類、葡萄酒品質分析、住宅可負擔性與通勤分析


資料視覺化與儀表板

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 進行資料框操作的經驗,以及使用 GeoPandas 進行空間連結和地理分析的經驗。

工具與技術: Python (Pandas, Polars, GeoPandas)、API 整合、Census ACS、OpenStreetMap Overpass

體現於: 住宅可負擔性與通勤分析、電力消耗分析、AirBnB 房源分析、Google Analytics 資料歸檔


網站開發

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) 來強制執行程式碼標準。他遵循 Conventional Commits 和 SemVer 的版本控制實務。

工具與技術: 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}.

相關技能