数据与研究

harvard-artifacts-etl-streamlit-analytics

reason-machines/data-skills

Build ETL pipelines and analytics dashboards using Harvard Art Museums API data with Python, SQL, and Streamlit

  • 1895 次安装
  • 5 星标
  • 收录于

安装命令

npx skills add https://github.com/reason-machines/data-skills --skill harvard-artifacts-etl-streamlit-analytics

SKILL.md

Harvard Artifacts ETL & Analytics Skill

Skill by ara.so — Data Skills collection.

This skill enables AI coding agents to help developers build end-to-end data engineering and analytics applications using the Harvard Art Museums API. The project demonstrates ETL pipelines, SQL database design, analytical queries, and interactive Streamlit visualizations for museum artifact data.

What This Project Does

The Harvard Artifacts Collection Data Engineering & Analytics App provides:

  • API Integration: Fetch artifact data from Harvard Art Museums API with pagination and rate limiting
  • ETL Pipeline: Extract, transform, and load artifact metadata, media, and color data into relational SQL tables
  • SQL Analytics: Pre-built analytical queries for insights on culture, century, media availability, and color patterns
  • Interactive Dashboard: Streamlit-based UI with Plotly visualizations for query results

Installation

Harvard Artifacts ETL & Analytics Skill

Skill by ara.so — Data Skills collection.

This skill enables AI coding agents to help developers build end-to-end data engineering and analytics applications using the Harvard Art Museums API. The project demonstrates ETL pipelines, SQL database design, analytical queries, and interactive Streamlit visualizations for museum artifact data.

What This Project Does

The Harvard Artifacts Collection Data Engineering & Analytics App provides:

  • API Integration: Fetch artifact data from Harvard Art Museums API with pagination and rate limiting
  • ETL Pipeline: Extract, transform, and load artifact metadata, media, and color data into relational SQL tables
  • SQL Analytics: Pre-built analytical queries for insights on culture, century, media availability, and color patterns
  • Interactive Dashboard: Streamlit-based UI with Plotly visualizations for query results

Installation