Customer ID Age Date Category Transaction Amount

11001 15 Jan-18 Travel 5375

11001 15 Feb-18 Travel 15375
11001 15 Feb-18 Online Shopping 10000
11002 34 Jan-18 Dining 447
11002 34 Feb-18 Dining 447
11002 34 Feb-18 Travel 400000
11002 34 Feb-18 Online Shopping 99999
11003 25 Jan-18 Travel 2715
11003 25 Feb-18 Travel 2715
11003 25 Feb-18 Online Shopping 359999
11004 54 Jan-18 Dining 1075
11004 54 Feb-18 Dining 1075
11004 54 Feb-18 Travel 79167
11004 54 Feb-18 Shopping 69999
11004 54 Feb-18 Travell 289618
11005 40 Jan-18 Travel 4000
11005 40 Feb-18 Travel 4000
11005 40 Feb-18 Dining 10000
11005 40 Feb-18 Dining 13637
11005 40 Feb-18 Travel 56802
11005 40 Feb-18 Online Shopping 123769
11005 40 Feb-18 Online Shopping 423561
11006 30 Jan-18 Fuel 1694
11006 30 Feb-18 Fuel 1694
11006 30 Feb-18 Travel 19689
11006 30 Feb-18 Dining 20999
11007 21 Jan-18 Dining 887
11007 21 Feb-18 Dining 887
11008 26 Jan-18 Travel 2273
11008 26 Feb-18 Travel 2273
11009 53 Jan-18 Travel 6621
11009 53 Feb-18 Travel 6621
11010 20 Jan-18 Travel 3292
11010 20 Feb-18 Travel 3292
11007 21 Feb-18 Travel 69999
11008 26 Jan-18 Online Shopping 112273
11009 53 Feb-18 Online Shopping 59999
11009 53 Feb-18 Online Shopping 40000
11010 20 Feb-18 Online Shopping 29999
11010 20 Feb-18 Online Shopping 19999
11011 24 Jan-18 Dining 980
11011 24 Feb-18 Dining 980
11012 43 Jan-18 Dining 974
11012 43 Feb-18 Dining 974
11013 25 Jan-18 Travel 6762
11013 25 Feb-18 Travel 6762
11014 26 Jan-18 Online Shopping 310
11014 26 Feb-18 Online Shopping 310
11015 55 Jan-18 Fuel 1882
11015 55 Feb-18 Fuel 1882
11016 18 Jan-18 Dining 584
11016 18 Feb-18 Dining 584
11017 52 Jan-18 Online Shopping 1554
11017 52 Feb-18 Online Shopping 1554
11018 50 Jan-18 Travel 1631
11018 50 Feb-18 Travel 1631
11019 21 Jan-18 Travel 3294
11019 21 Feb-18 Travel 3294
11020 43 Jan-18 Dining 1014
11020 43 Feb-18 Dining 1014
11021 49 Jan-18 Online Shopping 427
11021 49 Feb-18 Online Shopping 427
11022 24 Jan-18 Dining 1932
11022 24 Feb-18 Dining 1932
11023 42 Jan-18 Online Shopping 1108
11023 42 Feb-18 Online Shopping 1108
11024 48 Jan-18 Fuel 1245
11024 48 Feb-18 Fuel 1245
11025 38 Jan-18 Online Shopping 1847
11025 38 Feb-18 Online Shopping 1847
11026 17 Jan-18 Travel 5974
11026 17 Feb-18 Travel 5974
11027 26 Jan-18 Dining 755
11027 26 Feb-18 Dining 755
11028 18 Jan-18 Online Shopping 301
11028 18 Feb-18 Online Shopping 301
11029 16 Jan-18 Fuel 833
11029 16 Feb-18 Fuel 833
11030 55 Jan-18 Dining 825
11030 55 Feb-18 Dining 825
11031 28 Jan-18 Online Shopping 228
11031 28 Feb-18 Online Shopping 228
11032 29 Jan-18 Fuel 1633
11032 29 Feb-18 Fuel 1633
11033 52 Jan-18 Fuel 1023
11033 52 Feb-18 Fuel 1023
11034 40 Jan-18 Fuel 1837
11034 40 Feb-18 Fuel 1837
11035 34 Jan-18 Fuel 1058
11035 34 Feb-18 Fuel 1058
11036 35 Jan-18 Travel 3183
11036 35 Feb-18 Travel 3183
11037 46 Jan-18 Fuel 1725
11037 46 Feb-18 Fuel 1725
11038 34 Jan-18 Online Shopping 1505
11038 34 Feb-18 Online Shopping 1505
11039 45 Jan-18 Travel 3878
11039 45 Feb-18 Travel 3878
11040 24 Jan-18 Dining 1623
11040 24 Feb-18 Dining 1623
11041 48 Jan-18 Online Shopping 153
11041 48 Feb-18 Online Shopping 153
11042 46 Jan-18 Online Shopping 1456
11042 46 Feb-18 Online Shopping 1456
11043 49 Jan-18 Travel 2102
11043 49 Feb-18 Travel 2102
11044 36 Jan-18 Fuel 1138
11044 36 Feb-18 Fuel 1138
11045 31 Jan-18 Fuel 437
11045 31 Feb-18 Fuel 437
11046 43 Jan-18 Dining 435
11046 43 Feb-18 Dining 435
11047 39 Jan-18 Dining 455
11047 39 Feb-18 Dining 455
11048 53 Jan-18 Fuel 945
11048 53 Feb-18 Fuel 945
11049 40 Jan-18 Online Shopping 1643
11049 40 Feb-18 Online Shopping 1643
11050 41 Jan-18 Dining 1019
11050 41 Feb-18 Dining 1019
11051 35 Jan-18 Fuel 1933
11051 35 Feb-18 Fuel 1933
11052 37 Jan-18 Dining 1075
11052 37 Feb-18 Dining 1075
11053 40 Jan-18 Fuel 1037
11053 40 Feb-18 Fuel 1037
11054 21 Jan-18 Dining 765
11054 21 Feb-18 Dining 765
11055 29 Jan-18 Dining 1258
11055 29 Feb-18 Dining 1258
11056 21 Jan-18 Dining 572
11056 21 Feb-18 Dining 572
11057 39 Jan-18 Online Shopping 856
11057 39 Feb-18 Online Shopping 856
11058 31 Jan-18 Dining 807
11058 31 Feb-18 Dining 807
11059 26 Jan-18 Fuel 1508
11059 26 Feb-18 Fuel 1508
11060 46 Jan-18 Fuel 511
11060 46 Feb-18 Fuel 511
11061 15 Jan-18 Online Shopping 127
11061 15 Feb-18 Online Shopping 127
11062 31 Jan-18 Online Shopping 848
11062 31 Feb-18 Online Shopping 848
11063 29 Jan-18 Fuel 1434
11063 29 Feb-18 Fuel 1434
11064 33 Jan-18 Travel 3502
11064 33 Feb-18 Travel 3502
11065 22 Jan-18 Dining 1784
11065 22 Feb-18 Dining 1784
11066 47 Jan-18 Online Shopping 1513
11066 47 Feb-18 Online Shopping 1513
11067 45 Jan-18 Travel 2980
11067 45 Feb-18 Travel 2980
11068 17 Jan-18 Fuel 1833
11068 17 Feb-18 Fuel 1833
11069 16 Jan-18 Online Shopping 1845
11069 16 Feb-18 Online Shopping 1845
11070 47 Jan-18 Travel 4169
11070 47 Feb-18 Travel 4169
11071 46 Jan-18 Travel 7740
11071 46 Feb-18 Travel 7740
11072 29 Jan-18 Dining 1440
11072 29 Feb-18 Dining 1440
11073 45 Jan-18 Online Shopping 1286
11073 45 Feb-18 Online Shopping 1286
11074 36 Jan-18 Fuel 1914
11074 36 Feb-18 Fuel 1914
11075 17 Jan-18 Dining 1645
11075 17 Feb-18 Dining 1645
11076 17 Jan-18 Dining 739
11076 17 Feb-18 Dining 739
11077 43 Jan-18 Dining 1631
11077 43 Feb-18 Dining 1631
11078 52 Jan-18 Travel 4992
11078 52 Feb-18 Travel 4992
11079 49 Jan-18 Travel 5013
11079 49 Feb-18 Travel 5013
11080 49 Jan-18 Dining 380
11080 49 Feb-18 Dining 380
11081 30 Jan-18 Dining 1649
11081 30 Feb-18 Dining 1649
11082 49 Jan-18 Travel 6079
11082 49 Feb-18 Travel 6079
11083 52 Jan-18 Travel 3064
11083 52 Feb-18 Travel 3064
11084 25 Jan-18 Travel 5295
11084 25 Feb-18 Travel 5295
11085 28 Jan-18 Dining 1189
11085 28 Feb-18 Dining 1189
11086 27 Jan-18 Fuel 1752
11086 27 Feb-18 Fuel 1752
11087 18 Jan-18 Fuel 632
11087 18 Feb-18 Fuel 632
11088 15 Jan-18 Fuel 128
11088 15 Feb-18 Fuel 128
11089 32 Jan-18 Travel 4037
11089 32 Feb-18 Travel 4037
11090 35 Jan-18 Online Shopping 991
11090 35 Feb-18 Online Shopping 991
11091 54 Jan-18 Dining 648
11091 54 Feb-18 Dining 648
11092 36 Jan-18 Online Shopping 263
11092 36 Feb-18 Online Shopping 263
11093 42 Jan-18 Fuel 1361
11093 42 Feb-18 Fuel 1361
11094 28 Jan-18 Fuel 553
11094 28 Feb-18 Fuel 553
11095 50 Jan-18 Fuel 689
11095 50 Feb-18 Fuel 689
11096 37 Jan-18 Fuel 592
11096 37 Feb-18 Fuel 592
11097 41 Jan-18 Dining 372
11097 41 Feb-18 Dining 372
11098 22 Jan-18 Dining 388
11098 22 Feb-18 Dining 388
11099 50 Jan-18 Dining 121
11099 50 Feb-18 Dining 121
11100 16 Jan-18 Fuel 938
11100 16 Feb-18 Fuel 938
Customer ID Date Total Due Total Payment
11001 2/1/2018 25375 3506
11002 2/1/2018 500446 403
11003 2/1/2018 362714 4283
11004 2/1/2018 439859 4220
11005 2/1/2018 631769 6199
11006 2/1/2018 42382 2784
11007 2/1/2018 70886 3411
11008 2/1/2018 114546 4990
11009 2/1/2018 106620 3709
11010 2/1/2018 53290 6003
11001 1/1/2018 8976 3506
11002 1/1/2018 9080 6403
11003 1/1/2018 7793 4283
11004 1/1/2018 5392 4220
11005 1/1/2018 9717 6199
11006 1/1/2018 2784 2784
11007 1/1/2018 7872 3411
11008 1/1/2018 9850 4990
11009 1/1/2018 3709 3709
11010 1/1/2018 8781 6003
11011 1/1/2018 9052 6582
11012 1/1/2018 6269 3650
11013 1/1/2018 5987 4212
11014 1/1/2018 9691 5287
11015 1/1/2018 6057 3620
11016 1/1/2018 6208 6208
11017 1/1/2018 5395 5395
11018 1/1/2018 4268 4268
11019 1/1/2018 9527 5204
11020 1/1/2018 5015 5015
11021 1/1/2018 3271 3271
11022 1/1/2018 7336 5709
11023 1/1/2018 6774 3602
11024 1/1/2018 2860 2860
11025 1/1/2018 8896 6392
11026 1/1/2018 2469 2469
11027 1/1/2018 4741 4741
11028 1/1/2018 5147 5147
11029 1/1/2018 4616 4616
11030 1/1/2018 7368 6384
11031 1/1/2018 3462 3288
11032 1/1/2018 9986 4450
11033 1/1/2018 7203 4908
11034 1/1/2018 7726 3828
11035 1/1/2018 7652 6012
11036 1/1/2018 7734 3501
11037 1/1/2018 8139 4009
11038 1/1/2018 9662 6652
11039 1/1/2018 3542 3542
11040 1/1/2018 7848 3209
11041 1/1/2018 3067 3067
11042 1/1/2018 2241 2241
11043 1/1/2018 5813 4392
11044 1/1/2018 9879 3340
11045 1/1/2018 7036 6636
11046 1/1/2018 7086 4902
11047 1/1/2018 4330 3412
11048 1/1/2018 3741 3741
11049 1/1/2018 4608 3194
11050 1/1/2018 4783 3033
11051 1/1/2018 2165 2165
11052 1/1/2018 8112 4667
11053 1/1/2018 4197 4197
11054 1/1/2018 5745 4466
11055 1/1/2018 7593 3723
11056 1/1/2018 8446 6677
11057 1/1/2018 6342 4027
11058 1/1/2018 4159 3671
11059 1/1/2018 2863 2863
11060 1/1/2018 3737 3737
11061 1/1/2018 2436 2436
11062 1/1/2018 7150 5190
11063 1/1/2018 9065 3447
11064 1/1/2018 5456 4144
11065 1/1/2018 6473 5275
11066 1/1/2018 9060 6590
11067 1/1/2018 3598 3598
11068 1/1/2018 6229 4817
11069 1/1/2018 2569 2569
11070 1/1/2018 8653 5557
11071 1/1/2018 3785 3785
11072 1/1/2018 7309 5154
11073 1/1/2018 4689 4689
11074 1/1/2018 2362 2362
11075 1/1/2018 6482 4771
11076 1/1/2018 2856 2856
11077 1/1/2018 8230 3944
11078 1/1/2018 8600 4624
11079 1/1/2018 6973 4663
11080 1/1/2018 2647 2647
11081 1/1/2018 5632 5632
11082 1/1/2018 6666 3239
11083 1/1/2018 3170 3170
11084 1/1/2018 5308 3186
11085 1/1/2018 4061 3316
11086 1/1/2018 6291 4324
11087 1/1/2018 6939 6939
11088 1/1/2018 4370 4370
11089 1/1/2018 3162 3162
11090 1/1/2018 6630 5610
11091 1/1/2018 8773 6717
11092 1/1/2018 4350 4350
11093 1/1/2018 7206 5252
11094 1/1/2018 9723 3102
11095 1/1/2018 5088 4399
11096 1/1/2018 4738 4738
11097 1/1/2018 9169 3981
11098 1/1/2018 3826 3826
11099 1/1/2018 4382 4382
11100 1/1/2018 5230 3894
Customer ID Card No. Name Age Location Credit Limit
11001 Credit Card 1 Anshu Sinha 15 Delhi 20000
11002 Credit Card 2 Radhey Shyam 34 Nagpur 400000
11003 Credit Card 1 Nikita Sharma 125 Delhi 347000
11004 Credit Card 1 Anuj Tripathi 54 Delhi 423000
11005 Credit Card 1 Aashish Bharadwaj 40 Delhi 600000
11006 Credit Card 2 Akshay Singhal 30 Delhi 34000
11006 Credit Card 2 Rishabh Gupta 21 Delhi 67000
11008 Credit Card 2 Ankita Bhansal 26 Nagpur 90000
11009 Credit Card 2 Vishal Garg 53 Nagpur 87000
11010 Credit Card 2 Anu Sharma 20 Nagpur 45000
Customer Segment Age Group Purchasing Power
Segment A 40-55 years High
Segment B 20-39 years High
Segment C 15-19 years Low
 Product Category Reward %
Credit Card 1 Travel 2%
Credit Card 1 Dining 10%
Credit Card 1 Fuel 1%
Credit Card 1 Online Shopping 5%
Credit Card 2 Travel 8%
Credit Card 2 Dining 5%
Credit Card 2 Fuel 2%
Credit Card 2 Online Shopping 2%

Product Charge Rate on Due

Credit Card 1 2%
Credit Card 2 8%
Online Shopping
Dining
Travel
Fuel