CSV Sales Data Loader
Paste the following prompt into your AI chat to install this skill:
Please follow https://skillhub.cn/install/skillhub.md to install @user_5f8aef2c/loaddata01
About this skill
Problem
When a script or analysis pipeline only needs raw local CSV sales records, manually parsing headers, nulls, and duplicate rows can turn simple loading into implicit cleaning. LoadData has a narrow goal: read a standard local CSV sales file and return a consistent raw list, so downstream code can filter, aggregate, or validate according to business rules.
How It Works
- Input: call
main("sales.csv");file_pathaccepts an absolute or relative path. - Parsing: automatically skip the header row and parse data rows into a two-dimensional list of
[date string, sales integer/None]. - Raw fidelity: preserve null values and duplicate rows without deduplication, imputation, normalization, or unit conversion.
- Output: return a
raw_dataarray for furtherpandaswork, statistics, or intermediate storage.
Boundaries
It fits local CSV files with a clear “date + sales” structure, not complex headers, multi-column business data, abnormal encodings, or nonstandard delimiters. If the file already contains aggregates, multiple currencies, timestamps, or free-text anomalies, define field expectations before calling. If cleaning is required, implement it separately after this skill instead of mixing loading and transformation.
Use Cases
- Load a local sales CSV file, skip the header, and return raw date-sales rows.
- Extract null and duplicate sales rows before cleaning to preserve records.
- Prepare simple sales report inputs by parsing CSV rows into a 2D array.
- Debug local load behavior by confirming it returns date and sales only.
Best For
- Python script authors who need local sales CSV loading: raw date-sales lists.
- Analytics engineers validating sales data: preserve nulls and duplicates first.
- Automation engineers maintaining simple reports: stable CSV rows to arrays.
- Engineering interns debugging data pipelines: no implicit cleaning or normalization.
Related Skills
Track multiple GitHub projects, check releases and changelogs, and generate structured update summaries with impact analysis.
Upload local files to Qiniu Object Storage with server-side auto-delete days and public or private permanent URLs, ideal for temporary files and replacing Base64 storage.
Creates themed learning sites by generating flashcards, lessons, quizzes, index, and progress pages into a deployable website.
End-to-end mathematical optimization modeling with Gurobi and Python, covering data validation, code generation, solving, result analysis, and iterative revision.