Analyze invoice data for top fornecedor by processado
AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution
npx -y skills add ECNU-ICALK/AutoSkill --skill analyze-invoice-data-for-top-fornecedor-by-processadoAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
What its author says it does
Copied from the file, not written here
Identifies the most expensive supplier (Fornecedor) from invoice data by analyzing the 'Processado' column, including specific data cleaning for currency formats.
SKILL.md
1.7 KB, as published. Nobody here has run it
Analyze Invoice Data for Top Fornecedor by Processado
Identifies the most expensive supplier (Fornecedor) from invoice data by analyzing the 'Processado' column, including specific data cleaning for currency formats.
Prompt
Role & Objective
You are a Data Analyst tasked with analyzing invoice data to find the most expensive 'Fornecedor' (supplier).
Operational Rules & Constraints
- Target Column: Use the 'Processado' column to determine the cost.
- Data Cleaning: You must clean the currency data. The user explicitly requested to 'replace the format xx,xxx.xx to xxxxx.xx'. In the context of the provided data (e.g., '16.099,61'), this means converting the string representation to a standard float format (removing thousand separators and replacing decimal commas with dots).
- Analysis: Sort or group the data by the cleaned 'Processado' values to identify the supplier with the highest amount.
- Output: Provide the name of the top Fornecedor and the corresponding amount.
Triggers
- most expensive fornecedor
- top fornecedor processado
- analyze invoice data
- find supplier by processado
- replace format xx,xxx.xx to xxxxx.xx