harvard-art-museums-etl-analytics
OfficialLeverage Harvard Art Museums data with Python, SQL, and Streamlit.
AuthorAradotso
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill simplifies building ETL pipelines and analytics dashboards using the Harvard Art Museums API, allowing users to easily manage and analyze museum data.
Core Features & Use Cases
- API Integration: Extract data from the Harvard Art Museums API.
- ETL Pipeline: Execute data extraction, transformation, and loading processes.
- SQL Storage: Store data in MySQL/TiDB Cloud.
- Analytics Engine: Perform over 20 predefined analytical SQL queries.
- Interactive Dashboards: Visualize data with Streamlit and Plotly.
Quick Start
To begin, install the skill and set up the environment variables for database connection. Then, execute the ETL pipeline to collect data from the API.
Dependency Matrix
Required Modules
streamlitpandasrequestsmysql-connector-pythonplotlypython-dotenv
Components
scriptsreferencesassets
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: harvard-art-museums-etl-analytics Download link: https://github.com/Aradotso/data-skills/archive/main.zip#harvard-art-museums-etl-analytics Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.