Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
You are working as a Data Analytics in a high-tech payment company. Btw, congrats for the new job!
On your first day, you are being asked to categorize payment using the payments table which has the following columns:
| Column Name | Description |
|---|---|
| payment_id | Unique ID for each payment |
| customer_id | ID of the customer |
| amount | Amount of the payment |
| payment_date | Date of the payment |
| category |
You are working as a Data Analytics in a high-tech payment company. Btw, congrats for the new job!
On your first day, you are being asked to categorize payment using the payments table which has the following columns:
| Column Name | Description |
|---|---|
| payment_id | Unique ID for each payment |
| customer_id | ID of the customer |
| amount | Amount of the payment |
| payment_date | Date of the payment |
| category |
| Payment category ('Retail', 'Service', 'Subscription') |
So you came up with this suggestion to categorize payment in 2 categories: 'High Value' for payments over $500 and 'Regular Value' for payments $500 and below. Get the total amount of payments in 2 separate columns (High Value vs. Regular Value).
| high_value_total | regular_value_total |
|---|---|
| 16945 | 4155 |
| Payment category ('Retail', 'Service', 'Subscription') |
So you came up with this suggestion to categorize payment in 2 categories: 'High Value' for payments over $500 and 'Regular Value' for payments $500 and below. Get the total amount of payments in 2 separate columns (High Value vs. Regular Value).
| high_value_total | regular_value_total |
|---|---|
| 16945 | 4155 |