skills.rest
pengfit
pengfitCOMMUNITY
Explore all skills by this author →
GitHub

gov-price-etl

Automate ETL processes for government price data across 17 provinces and cities.

Updated May 22, 2026
Search Tags:#data transformation#government data#data automation#data etl#price information
One-click install
npx skills add https://github.com/pengfit/cjt-skills --skill gov-price-etl
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: gov-price-etl
Source: https://github.com/pengfit/cjt-skills/tree/main/rizhao-price/node_modules/playwright-core/lib/tools/trace
Command: npx skills add https://github.com/pengfit/cjt-skills --skill gov-price-etl

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, sqlalchemy, python-dateutil, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the Extract, Transform, and Load (ETL) process for government price information, eliminating manual data processing and streamlining workflows.

Core Features & Use Cases

  • ETL Automation: Fully automated ETL processes for government price data.
  • Data Cleaning: Cleans and standardizes raw data for analysis and reporting.
  • Use Case: For instance, with this Skill, government agencies can automatically update their databases with the latest price information from various sources, saving time and reducing errors.

Quick Start

Execute the etl.py script to perform the ETL operations on the government price data.

Frequently Asked Questions about gov-price-etl

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate government price information ETL processes?▼

You can automate government price information ETL by running the included `etl.py` script, which handles data extraction, transformation, and loading to eliminate manual data processing and streamline workflows.

Can pandas and sqlalchemy handle data synchronization for 17 provinces and cities?▼

Yes, pandas and sqlalchemy handle data synchronization across 17 provinces and cities. These dependencies facilitate automated data extraction, ETL cleaning, and data visualization preparation for government price information.

What is the best way to clean and standardize raw government price data for analysis?▼

The best way to clean and standardize raw government price data is using automated ETL processes. The Skill handles data cleaning and synchronization, ensuring standardized information ready for analysis and reporting.

Does this data automation workflow require custom scripts for extracting price information?▼

Yes, this data automation workflow requires custom scripts and tools for data extraction and transformation. You execute the `etl.py` script to perform automated ETL operations on government price information efficiently.

What limitations should I expect when automating ETL for government price data across multiple provinces?▼

When automating ETL for government price data across 17 provinces and cities, you must account for variations in source data formats. Custom scripts are required for specific data extraction and transformation needs.

Related Skills

Explore More Data & Analytics Skills→
JingyiWngJingyiWng

databricks-lakebase-provisioned

Provision and manage Lakebase PostgreSQL databases with OAuth token authentication.

Community
Advanced
HwFeeHwFee

data-analyst

Analyze CSV, Excel, JSON, and SQL datasets to generate visual insights and reports.

Community
Intermediate
pengfitpengfit

hunan-price

Collect Hunan engineering material prices and synchronize them to Elasticsearch.

Community
Intermediate
Hack23Hack23
9

data-pipeline-engineering

Design and deploy end-to-end ETL pipelines with automated ingestion, transformation, and loading.

Official
Advanced