[json] response

Viewer

copydownloadembedprintName: response
  1. {
  2.   "ecom": {
  3.     "data": [
  4.       {
  5.         "Category": "Amusement",
  6.         "MALAYSIA - Sum (RM)": 0.0,
  7.         "MALAYSIA - Transaction Count": 0.0,
  8.         "OTHER COUNTRIES - Sum (RM)": 1687.55,
  9.         "OTHER COUNTRIES - Transaction Count": 146.0,
  10.         "Total - Sum (RM)": 1687.55,
  11.         "Total - Transaction Count": 146.0
  12.       },
  13.       {
  14.         "Category": "Commercial",
  15.         "MALAYSIA - Sum (RM)": 0.0,
  16.         "MALAYSIA - Transaction Count": 0.0,
  17.         "OTHER COUNTRIES - Sum (RM)": 13567.23,
  18.         "OTHER COUNTRIES - Transaction Count": 50.0,
  19.         "Total - Sum (RM)": 13567.23,
  20.         "Total - Transaction Count": 50.0
  21.       },
  22.       {
  23.         "Category": "Entertainment",
  24.         "MALAYSIA - Sum (RM)": 1791.0,
  25.         "MALAYSIA - Transaction Count": 40.0,
  26.         "OTHER COUNTRIES - Sum (RM)": 124.59,
  27.         "OTHER COUNTRIES - Transaction Count": 13.0,
  28.         "Total - Sum (RM)": 1915.59,
  29.         "Total - Transaction Count": 53.0
  30.       },
  31.       {
  32.         "Category": "Financial",
  33.         "MALAYSIA - Sum (RM)": 2605098.75,
  34.         "MALAYSIA - Transaction Count": 7035.0,
  35.         "OTHER COUNTRIES - Sum (RM)": 7115.09,
  36.         "OTHER COUNTRIES - Transaction Count": 129.0,
  37.         "Total - Sum (RM)": 2612213.84,
  38.         "Total - Transaction Count": 7164.0
  39.       },
  40.       {
  41.         "Category": "Food",
  42.         "MALAYSIA - Sum (RM)": 799.65,
  43.         "MALAYSIA - Transaction Count": 28.0,
  44.         "OTHER COUNTRIES - Sum (RM)": 2761.32,
  45.         "OTHER COUNTRIES - Transaction Count": 28.0,
  46.         "Total - Sum (RM)": 3560.97,
  47.         "Total - Transaction Count": 56.0
  48.       },
  49.       {
  50.         "Category": "Fuel",
  51.         "MALAYSIA - Sum (RM)": 7.11,
  52.         "MALAYSIA - Transaction Count": 13.0,
  53.         "OTHER COUNTRIES - Sum (RM)": 0.0,
  54.         "OTHER COUNTRIES - Transaction Count": 0.0,
  55.         "Total - Sum (RM)": 7.11,
  56.         "Total - Transaction Count": 13.0
  57.       },
  58.       {
  59.         "Category": "Government",
  60.         "MALAYSIA - Sum (RM)": 16883.97,
  61.         "MALAYSIA - Transaction Count": 123.0,
  62.         "OTHER COUNTRIES - Sum (RM)": 54194267.22,
  63.         "OTHER COUNTRIES - Transaction Count": 752.0,
  64.         "Total - Sum (RM)": 54211151.19,
  65.         "Total - Transaction Count": 875.0
  66.       },
  67.       {
  68.         "Category": "Hotel",
  69.         "MALAYSIA - Sum (RM)": 3161.79,
  70.         "MALAYSIA - Transaction Count": 27.0,
  71.         "OTHER COUNTRIES - Sum (RM)": 30197.68,
  72.         "OTHER COUNTRIES - Transaction Count": 134.0,
  73.         "Total - Sum (RM)": 33359.47,
  74.         "Total - Transaction Count": 161.0
  75.       },
  76.       {
  77.         "Category": "Insurance",
  78.         "MALAYSIA - Sum (RM)": 3121.73,
  79.         "MALAYSIA - Transaction Count": 7.0,
  80.         "OTHER COUNTRIES - Sum (RM)": 10175.0,
  81.         "OTHER COUNTRIES - Transaction Count": 14.0,
  82.         "Total - Sum (RM)": 13296.73,
  83.         "Total - Transaction Count": 21.0
  84.       },
  85.       {
  86.         "Category": "Merchant",
  87.         "MALAYSIA - Sum (RM)": 0.0,
  88.         "MALAYSIA - Transaction Count": 0.0,
  89.         "OTHER COUNTRIES - Sum (RM)": 8666.21,
  90.         "OTHER COUNTRIES - Transaction Count": 887.0,
  91.         "Total - Sum (RM)": 8666.21,
  92.         "Total - Transaction Count": 887.0
  93.       },
  94.       {
  95.         "Category": "Other",
  96.         "MALAYSIA - Sum (RM)": 171356.41,
  97.         "MALAYSIA - Transaction Count": 1235.0,
  98.         "OTHER COUNTRIES - Sum (RM)": 1816233.38,
  99.         "OTHER COUNTRIES - Transaction Count": 10084.0,
  100.         "Total - Sum (RM)": 1987589.7899999998,
  101.         "Total - Transaction Count": 11319.0
  102.       },
  103.       {
  104.         "Category": "Professional",
  105.         "MALAYSIA - Sum (RM)": 14759.32,
  106.         "MALAYSIA - Transaction Count": 14.0,
  107.         "OTHER COUNTRIES - Sum (RM)": 3579.15,
  108.         "OTHER COUNTRIES - Transaction Count": 58.0,
  109.         "Total - Sum (RM)": 18338.47,
  110.         "Total - Transaction Count": 72.0
  111.       },
  112.       {
  113.         "Category": "Restaurant",
  114.         "MALAYSIA - Sum (RM)": 1405.82,
  115.         "MALAYSIA - Transaction Count": 25.0,
  116.         "OTHER COUNTRIES - Sum (RM)": 21.83,
  117.         "OTHER COUNTRIES - Transaction Count": 2.0,
  118.         "Total - Sum (RM)": 1427.65,
  119.         "Total - Transaction Count": 27.0
  120.       },
  121.       {
  122.         "Category": "Retail",
  123.         "MALAYSIA - Sum (RM)": 95644.58,
  124.         "MALAYSIA - Transaction Count": 2596.0,
  125.         "OTHER COUNTRIES - Sum (RM)": 317843.85,
  126.         "OTHER COUNTRIES - Transaction Count": 1005.0,
  127.         "Total - Sum (RM)": 413488.43,
  128.         "Total - Transaction Count": 3601.0
  129.       },
  130.       {
  131.         "Category": "Transportation",
  132.         "MALAYSIA - Sum (RM)": 118903.91,
  133.         "MALAYSIA - Transaction Count": 3080.0,
  134.         "OTHER COUNTRIES - Sum (RM)": 364107.63,
  135.         "OTHER COUNTRIES - Transaction Count": 96.0,
  136.         "Total - Sum (RM)": 483011.54,
  137.         "Total - Transaction Count": 3176.0
  138.       },
  139.       {
  140.         "Category": "Utility",
  141.         "MALAYSIA - Sum (RM)": 21853.87,
  142.         "MALAYSIA - Transaction Count": 128.0,
  143.         "OTHER COUNTRIES - Sum (RM)": 5312.36,
  144.         "OTHER COUNTRIES - Transaction Count": 52.0,
  145.         "Total - Sum (RM)": 27166.23,
  146.         "Total - Transaction Count": 180.0
  147.       },
  148.       {
  149.         "Category": "Total",
  150.         "MALAYSIA - Sum (RM)": 3054787.91,
  151.         "MALAYSIA - Transaction Count": 14351.0,
  152.         "OTHER COUNTRIES - Sum (RM)": 56775660.09,
  153.         "OTHER COUNTRIES - Transaction Count": 13450.0,
  154.         "Total - Sum (RM)": 59830448.0,
  155.         "Total - Transaction Count": 27801.0
  156.       }
  157.     ],
  158.     "schema": {
  159.       "fields": [
  160.         {
  161.           "name": "Category",
  162.           "type": "string"
  163.         },
  164.         {
  165.           "name": "MALAYSIA - Sum (RM)",
  166.           "type": "number"
  167.         },
  168.         {
  169.           "extDtype": "Float64",
  170.           "name": "MALAYSIA - Transaction Count",
  171.           "type": "number"
  172.         },
  173.         {
  174.           "name": "OTHER COUNTRIES - Sum (RM)",
  175.           "type": "number"
  176.         },
  177.         {
  178.           "extDtype": "Float64",
  179.           "name": "OTHER COUNTRIES - Transaction Count",
  180.           "type": "number"
  181.         },
  182.         {
  183.           "name": "Total - Sum (RM)",
  184.           "type": "number"
  185.         },
  186.         {
  187.           "name": "Total - Transaction Count",
  188.           "type": "number"
  189.         }
  190.       ],
  191.       "pandas_version": "1.4.0",
  192.       "primaryKey": [
  193.         "Category"
  194.       ]
  195.     }
  196.   },
  197.   "pos": {
  198.     "data": [
  199.       {
  200.         "Category": "Amusement",
  201.         "MALAYSIA - Sum (RM)": 5672.05,
  202.         "MALAYSIA - Transaction Count": 133.0,
  203.         "OTHER COUNTRIES - Sum (RM)": 20.9,
  204.         "OTHER COUNTRIES - Transaction Count": 2.0,
  205.         "Total - Sum (RM)": 5692.95,
  206.         "Total - Transaction Count": 135.0
  207.       },
  208.       {
  209.         "Category": "Commercial",
  210.         "MALAYSIA - Sum (RM)": 2438.66,
  211.         "MALAYSIA - Transaction Count": 419.0,
  212.         "OTHER COUNTRIES - Sum (RM)": 710.78,
  213.         "OTHER COUNTRIES - Transaction Count": 38.0,
  214.         "Total - Sum (RM)": 3149.44,
  215.         "Total - Transaction Count": 457.0
  216.       },
  217.       {
  218.         "Category": "Entertainment",
  219.         "MALAYSIA - Sum (RM)": 5926.8,
  220.         "MALAYSIA - Transaction Count": 138.0,
  221.         "OTHER COUNTRIES - Sum (RM)": 2051.29,
  222.         "OTHER COUNTRIES - Transaction Count": 118.0,
  223.         "Total - Sum (RM)": 7978.09,
  224.         "Total - Transaction Count": 256.0
  225.       },
  226.       {
  227.         "Category": "Financial",
  228.         "MALAYSIA - Sum (RM)": 1690475.38,
  229.         "MALAYSIA - Transaction Count": 21992.0,
  230.         "OTHER COUNTRIES - Sum (RM)": -3736389.32,
  231.         "OTHER COUNTRIES - Transaction Count": 219.0,
  232.         "Total - Sum (RM)": -2045913.94,
  233.         "Total - Transaction Count": 22211.0
  234.       },
  235.       {
  236.         "Category": "Food",
  237.         "MALAYSIA - Sum (RM)": 93919.46,
  238.         "MALAYSIA - Transaction Count": 3769.0,
  239.         "OTHER COUNTRIES - Sum (RM)": 3485332.22,
  240.         "OTHER COUNTRIES - Transaction Count": 313.0,
  241.         "Total - Sum (RM)": 3579251.68,
  242.         "Total - Transaction Count": 4082.0
  243.       },
  244.       {
  245.         "Category": "Fuel",
  246.         "MALAYSIA - Sum (RM)": 125054.03,
  247.         "MALAYSIA - Transaction Count": 5671.0,
  248.         "OTHER COUNTRIES - Sum (RM)": 45947.39,
  249.         "OTHER COUNTRIES - Transaction Count": 46.0,
  250.         "Total - Sum (RM)": 171001.42,
  251.         "Total - Transaction Count": 5717.0
  252.       },
  253.       {
  254.         "Category": "Government",
  255.         "MALAYSIA - Sum (RM)": 39947.01,
  256.         "MALAYSIA - Transaction Count": 256.0,
  257.         "OTHER COUNTRIES - Sum (RM)": 191.81,
  258.         "OTHER COUNTRIES - Transaction Count": 4.0,
  259.         "Total - Sum (RM)": 40138.82,
  260.         "Total - Transaction Count": 260.0
  261.       },
  262.       {
  263.         "Category": "Hotel",
  264.         "MALAYSIA - Sum (RM)": 25978.93,
  265.         "MALAYSIA - Transaction Count": 223.0,
  266.         "OTHER COUNTRIES - Sum (RM)": 743328.98,
  267.         "OTHER COUNTRIES - Transaction Count": 68.0,
  268.         "Total - Sum (RM)": 769307.91,
  269.         "Total - Transaction Count": 291.0
  270.       },
  271.       {
  272.         "Category": "Insurance",
  273.         "MALAYSIA - Sum (RM)": 1614.28,
  274.         "MALAYSIA - Transaction Count": 8.0,
  275.         "OTHER COUNTRIES - Sum (RM)": 0.0,
  276.         "OTHER COUNTRIES - Transaction Count": 0.0,
  277.         "Total - Sum (RM)": 1614.28,
  278.         "Total - Transaction Count": 8.0
  279.       },
  280.       {
  281.         "Category": "Merchant",
  282.         "MALAYSIA - Sum (RM)": 7824.7,
  283.         "MALAYSIA - Transaction Count": 48.0,
  284.         "OTHER COUNTRIES - Sum (RM)": 44546.25,
  285.         "OTHER COUNTRIES - Transaction Count": 3253.0,
  286.         "Total - Sum (RM)": 52370.95,
  287.         "Total - Transaction Count": 3301.0
  288.       },
  289.       {
  290.         "Category": "Other",
  291.         "MALAYSIA - Sum (RM)": 521384.08,
  292.         "MALAYSIA - Transaction Count": 11806.0,
  293.         "OTHER COUNTRIES - Sum (RM)": 1054670.99,
  294.         "OTHER COUNTRIES - Transaction Count": 38643.0,
  295.         "Total - Sum (RM)": 1576055.07,
  296.         "Total - Transaction Count": 50449.0
  297.       },
  298.       {
  299.         "Category": "Professional",
  300.         "MALAYSIA - Sum (RM)": 45160.53,
  301.         "MALAYSIA - Transaction Count": 312.0,
  302.         "OTHER COUNTRIES - Sum (RM)": 2163.66,
  303.         "OTHER COUNTRIES - Transaction Count": 64.0,
  304.         "Total - Sum (RM)": 47324.19,
  305.         "Total - Transaction Count": 376.0
  306.       },
  307.       {
  308.         "Category": "Restaurant",
  309.         "MALAYSIA - Sum (RM)": 279508.9,
  310.         "MALAYSIA - Transaction Count": 12358.0,
  311.         "OTHER COUNTRIES - Sum (RM)": 3267684.76,
  312.         "OTHER COUNTRIES - Transaction Count": 171.0,
  313.         "Total - Sum (RM)": 3547193.6599999997,
  314.         "Total - Transaction Count": 12529.0
  315.       },
  316.       {
  317.         "Category": "Retail",
  318.         "MALAYSIA - Sum (RM)": 3290890.67,
  319.         "MALAYSIA - Transaction Count": 101780.0,
  320.         "OTHER COUNTRIES - Sum (RM)": 8959419.43,
  321.         "OTHER COUNTRIES - Transaction Count": 1993.0,
  322.         "Total - Sum (RM)": 12250310.1,
  323.         "Total - Transaction Count": 103773.0
  324.       },
  325.       {
  326.         "Category": "Transportation",
  327.         "MALAYSIA - Sum (RM)": 343734.93,
  328.         "MALAYSIA - Transaction Count": 36417.0,
  329.         "OTHER COUNTRIES - Sum (RM)": 4851541.44,
  330.         "OTHER COUNTRIES - Transaction Count": 344.0,
  331.         "Total - Sum (RM)": 5195276.37,
  332.         "Total - Transaction Count": 36761.0
  333.       },
  334.       {
  335.         "Category": "Utility",
  336.         "MALAYSIA - Sum (RM)": 3007.61,
  337.         "MALAYSIA - Transaction Count": 24.0,
  338.         "OTHER COUNTRIES - Sum (RM)": 72093.96,
  339.         "OTHER COUNTRIES - Transaction Count": 12.0,
  340.         "Total - Sum (RM)": 75101.57,
  341.         "Total - Transaction Count": 36.0
  342.       },
  343.       {
  344.         "Category": "Total",
  345.         "MALAYSIA - Sum (RM)": 6482538.02,
  346.         "MALAYSIA - Transaction Count": 195354.0,
  347.         "OTHER COUNTRIES - Sum (RM)": 18793314.540000003,
  348.         "OTHER COUNTRIES - Transaction Count": 45288.0,
  349.         "Total - Sum (RM)": 25275852.560000002,
  350.         "Total - Transaction Count": 240642.0
  351.       }
  352.     ],
  353.     "schema": {
  354.       "fields": [
  355.         {
  356.           "name": "Category",
  357.           "type": "string"
  358.         },
  359.         {
  360.           "name": "MALAYSIA - Sum (RM)",
  361.           "type": "number"
  362.         },
  363.         {
  364.           "extDtype": "Float64",
  365.           "name": "MALAYSIA - Transaction Count",
  366.           "type": "number"
  367.         },
  368.         {
  369.           "name": "OTHER COUNTRIES - Sum (RM)",
  370.           "type": "number"
  371.         },
  372.         {
  373.           "extDtype": "Float64",
  374.           "name": "OTHER COUNTRIES - Transaction Count",
  375.           "type": "number"
  376.         },
  377.         {
  378.           "name": "Total - Sum (RM)",
  379.           "type": "number"
  380.         },
  381.         {
  382.           "name": "Total - Transaction Count",
  383.           "type": "number"
  384.         }
  385.       ],
  386.       "pandas_version": "1.4.0",
  387.       "primaryKey": [
  388.         "Category"
  389.       ]
  390.     }
  391.   },
  392.   "total": {
  393.     "data": [
  394.       {
  395.         "Category": "Grand Total",
  396.         "MALAYSIA - Sum (RM)": 9537325.93,
  397.         "MALAYSIA - Transaction Count": 209705.0,
  398.         "OTHER COUNTRIES - Sum (RM)": 75568974.63000001,
  399.         "OTHER COUNTRIES - Transaction Count": 58738.0,
  400.         "Total - Sum (RM)": 85106300.56,
  401.         "Total - Transaction Count": 268443.0
  402.       }
  403.     ],
  404.     "schema": {
  405.       "fields": [
  406.         {
  407.           "name": "Category",
  408.           "type": "string"
  409.         },
  410.         {
  411.           "name": "MALAYSIA - Sum (RM)",
  412.           "type": "number"
  413.         },
  414.         {
  415.           "extDtype": "Float64",
  416.           "name": "MALAYSIA - Transaction Count",
  417.           "type": "number"
  418.         },
  419.         {
  420.           "name": "OTHER COUNTRIES - Sum (RM)",
  421.           "type": "number"
  422.         },
  423.         {
  424.           "extDtype": "Float64",
  425.           "name": "OTHER COUNTRIES - Transaction Count",
  426.           "type": "number"
  427.         },
  428.         {
  429.           "name": "Total - Sum (RM)",
  430.           "type": "number"
  431.         },
  432.         {
  433.           "name": "Total - Transaction Count",
  434.           "type": "number"
  435.         }
  436.       ],
  437.       "pandas_version": "1.4.0",
  438.       "primaryKey": [
  439.         "Category"
  440.       ]
  441.     }
  442.   }
  443. }
  444.  

Editor

You can edit this paste and save as new:


File Description
  • response
  • Paste Code
  • 16 Apr-2024
  • 14.01 Kb
You can Share it: