Log Analysis Challenge 1 - MCC

Prompt

ChaChing Bank needs some questions answered relating to the MCC codes of some credit card transactions. Can you help?

Answers

Q1 (20 pts) - How many transactions took place at The Paris Las Vegas Hotel?
4

Q2 (20 pts) - What is the only merchant in the Department Store Category?
Note: Please be careful of typos!

Q3 (20 pts) - Which MCC Code appears most frequently in the logs?
N/A

Q4 (20 pts) - What is the total amount spent at Doctors or Physicians (Not classified Elsewhere)?
N/A

Q5 (20 pts) - What is the total number of transactions that were above $50?**
Q1 - Was confused at first because I could nto find anything in the log about the paris las vegas hotel. realzied I needed to look up the MCC for the hotel Used grep to get the answer

Steps I Took

Q2 — searched for department store mcc then greped this too

Submitted 1 as the answer before realizing it was asking for the name of this company

Q3 — used awk with some pipes to get the result

Q4 — Looked up the mcc for this question It only lists doctors, but I confirmed it also includes physicians

Used awk to find all the purchases

198.26

Q5 — used awk to print all transactions over 50

This answer was wrong piped head to the command realized “amount” was at the top

answer was 504

https://www.citibank.com/tts/solutions/commercial-cards/assets/docs/govt/Merchant-Category-Codes.pdf