Advertisement
Guest User

Untitled

a guest
Oct 19th, 2019
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. # October 1, 2019
  2.  
  3. ### Points Caculator - Bunny's Credit Card
  4.  
  5. You work at Rewards Department at Bunny Bank. There was an accident this morning that caused the Bunny Points System down.
  6.  
  7. You need to use a workaround by create a Python program to "Calculate Reward Points" from customer's spending transaction records (>= 10M transactions)
  8.  
  9. A transaction records in Excel look like this
  10. ```
  11. amount currency location
  12. 10000 "THB" "Marks & Spencer(London)"
  13. 35000 "THB" "Bergdorf Goodman(New York)"
  14. 2780 "THB" "Top Supermarket"
  15. ```
  16.  
  17. ## Requirements
  18. - Every 5 THB earn 1 Bunny's point
  19. - Earn 4x Points at department stores and duty-free shops worldwide. Points have no expiry date. Valid when spending at
  20. - Central
  21. - King Power
  22. - Siam Paragon
  23. - Marks & Spencer(London)
  24. - Bergdorf Goodman(New York)
  25. - Earn 2X Points on other domestic and overseas spending. Points have no expiry date. Valid when spending at
  26. - Tesco Lotus
  27. - Top Supermarket
  28. - Other oversea spending
  29.  
  30. Example
  31. ```
  32. Spending 100 THB at "The Mall" = 20 points
  33. Spending 50 THB at "Siam Paragon" = 40 points (4x)
  34. Spending 1,000 THB at "Other oversea spending" = 400 points (2x)
  35. ```
  36.  
  37. **Bonus**
  38. - The calculator can calculate with USD currency.
  39. - Assume that 1 USD = 35 THB
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement