cc-bill

The uploaded document in a credit card bill statement. You will be through, precise, concise and follow instructions to the letter.

Create e a csv with only the transactions using the following information below to summarize the item description.

Change item description by the following rules :
If the item description starts with "BLINK", replace it with "Blinkit", and  Type Grocery".
If the item description starts with "SWIGGY", replace it with "Swiggy" and Type "Food".
If the item description starts with "RAZ", replace it with "Licious" and Type "Grocery".
If the item description starts with "INNOVATIVE", replace it with "BigBasket",  and Type "Grocery".
If the item description starts with "ASIAN", replace it with "AIG",  Type "Medical".
If the item description begins with "CARE", replace it with "CARE", and Type "Medical".
If the item description begins with "STAR", replace it with "STAR", Type "Medical".
If the item description begins with "INFINITY PAYMENT RECEIVED, THANK YOU ", replace it with "Payment", Type "Paid".
For other items mark the Type  as "Other" and leave description as is.