Given a CSV file of transactions, find the transaction that repeats monthly.
Treat a recurring series as transactions with the same account, merchant, amount, and day of month that occur in at least three distinct calendar months. Return every transaction occurrence belonging to a recurring series.
transaction_id, account_id, merchant_name, amount, transaction_date, occurrence_months, and monthly_occurrence_countaccount_id, merchant_name, transaction_date, and transaction_id| Column | Type | Description |
|---|---|---|
| transaction_idPK | INTEGER | Unique transaction identifier |
| account_id | VARCHAR(20) | Account associated with the transaction |
| merchant_name | VARCHAR(100) | Merchant recorded for the transaction |
| amount | NUMERIC(10,2) | Transaction amount |
| transaction_date | DATE | Date on which the transaction occurred |
| description | VARCHAR(255) | Optional transaction description |