Average_Transaction_Value_Stats

Compute average transaction value statistics from payment data with optional filters.

128|12|Updated May 21, 2025
One-click install
npx skills add https://github.com/zjunlp/DataMind --skill average-transaction-value-stats
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Average_Transaction_Value_Stats
Source: https://github.com/zjunlp/DataMind/tree/main/datacope/reason_task/eval/skill/0/iter2/Average_Transaction_Value_Stats
Command: npx skills add https://github.com/zjunlp/DataMind --skill average-transaction-value-stats

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides a solution for calculating average transaction value statistics from payment transaction data, allowing users to analyze and understand average transaction amounts grouped by various categorical fields.

Core Features & Use Cases

  • Categorical Grouping: Computes mean eur_amount for transactions grouped by categorical fields such as shopper_interaction, issuing_country, acquirer_country, etc.
  • Optional Filters: Allows for optional filtering by merchant, card scheme, and date range to refine the analysis.
  • Use Case: Ideal for answering questions about average transaction amounts, such as "What is the average transaction amount for transactions in January 2023 by country?"

Quick Start

Use the Average_Transaction_Value_Stats skill to compute the average transaction value for transactions in January 2023, grouped by issuing_country.

Frequently Asked Questions about Average_Transaction_Value_Stats

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

FAQPage Schema
How do I compute average transaction value statistics from payment transaction data?

To compute average transaction value statistics from payment data, use this Skill to calculate the mean of transaction amounts grouped by categorical fields like issuing country or card scheme. It supports optional filtering by merchant and date range to refine the analysis.

Can I calculate average transaction amounts grouped by country using pandas?

Yes, you can calculate average transaction amounts grouped by country using pandas. This Skill computes the mean transaction value for categorical groupings such as issuing country, acquirer country, and shopper interaction, providing aggregated statistics for payment analysis.

How do I filter payment transaction data by merchant and date range before calculating averages?

You can filter payment transaction data by merchant, card scheme, and date range before calculating averages. This refines the average transaction value statistics, allowing targeted analysis such as computing the mean amount for transactions in January 2023 by issuing country.

What fields do I need in my payment transaction data to analyze average transaction values?

To analyze average transaction values, your payment transaction data should include an amount field like eur_amount and categorical fields for grouping, such as shopper_interaction, issuing_country, or acquirer_country. Optional filter fields like merchant and card scheme can further refine the computation.

Does this Skill require pandas for data manipulation and average transaction value computation?

Yes, this Skill requires pandas for data manipulation and average transaction value computation. The pandas library handles the underlying grouping by categorical fields and the calculation of mean transaction amounts from the payment data.