{"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"pygments_lexer":"ipython3","nbconvert_exporter":"python","version":"3.6.4","file_extension":".py","codemirror_mode":{"name":"ipython","version":3},"name":"python","mimetype":"text/x-python"}},"nbformat_minor":4,"nbformat":4,"cells":[{"cell_type":"code","source":"# This Python 3 environment comes with many helpful analytics libraries installed\n# It is defined by the kaggle/python Docker image: https://github.com/kaggle/docker-python\n# For example, here's several helpful packages to load\n\nimport numpy as np # linear algebra\nimport pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)\n\n# Input data files are available in the read-only \"../input/\" directory\n# For example, running this (by clicking run or pressing Shift+Enter) will list all files under the input directory\n\nimport os\nfor dirname, _, filenames in os.walk('/kaggle/input'):\n    for filename in filenames:\n        print(os.path.join(dirname, filename))\n\n# You can write up to 20GB to the current directory (/kaggle/working/) that gets preserved as output when you create a version using \"Save & Run All\" \n# You can also write temporary files to /kaggle/temp/, but they won't be saved outside of the current session","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","execution":{"iopub.status.busy":"2022-07-10T07:58:39.359879Z","iopub.execute_input":"2022-07-10T07:58:39.360302Z","iopub.status.idle":"2022-07-10T07:58:39.370444Z","shell.execute_reply.started":"2022-07-10T07:58:39.360269Z","shell.execute_reply":"2022-07-10T07:58:39.369382Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df = pd.DataFrame()\ndf = pd.read_csv('/kaggle/input/elo-merchant-category-recommendation/new_merchant_transactions.csv')","metadata":{"execution":{"iopub.status.busy":"2022-07-10T07:58:42.415352Z","iopub.execute_input":"2022-07-10T07:58:42.416868Z","iopub.status.idle":"2022-07-10T07:58:49.703323Z","shell.execute_reply.started":"2022-07-10T07:58:42.416821Z","shell.execute_reply":"2022-07-10T07:58:49.702147Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df.head()","metadata":{"execution":{"iopub.status.busy":"2022-07-10T07:58:51.942622Z","iopub.execute_input":"2022-07-10T07:58:51.943100Z","iopub.status.idle":"2022-07-10T07:58:51.974466Z","shell.execute_reply.started":"2022-07-10T07:58:51.943057Z","shell.execute_reply":"2022-07-10T07:58:51.973296Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df['merchant_category_id'].nunique()","metadata":{"execution":{"iopub.status.busy":"2022-07-10T08:10:31.473668Z","iopub.execute_input":"2022-07-10T08:10:31.474089Z","iopub.status.idle":"2022-07-10T08:10:31.492955Z","shell.execute_reply.started":"2022-07-10T08:10:31.474055Z","shell.execute_reply":"2022-07-10T08:10:31.491771Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df.count()","metadata":{"execution":{"iopub.status.busy":"2022-07-10T08:22:50.416613Z","iopub.execute_input":"2022-07-10T08:22:50.417136Z","iopub.status.idle":"2022-07-10T08:22:51.743506Z","shell.execute_reply.started":"2022-07-10T08:22:50.417091Z","shell.execute_reply":"2022-07-10T08:22:51.742328Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"jsonStr = '[{\"mcc\":\"3860\"},{\"mcc\":\"3861\"},{\"mcc\":\"3620\"},{\"mcc\":\"3862\"},{\"mcc\":\"3621\"},{\"mcc\":\"3863\"},{\"mcc\":\"3622\"},{\"mcc\":\"3864\"},{\"mcc\":\"5800\"},{\"mcc\":\"3623\"},{\"mcc\":\"3865\"},{\"mcc\":\"5801\"},{\"mcc\":\"1444\"},{\"mcc\":\"8071\"},{\"mcc\":\"3613\"},{\"mcc\":\"3855\"},{\"mcc\":\"3614\"},{\"mcc\":\"3856\"},{\"mcc\":\"3615\"},{\"mcc\":\"3857\"},{\"mcc\":\"3616\"},{\"mcc\":\"3858\"},{\"mcc\":\"3617\"},{\"mcc\":\"3859\"},{\"mcc\":\"3618\"},{\"mcc\":\"3619\"},{\"mcc\":\"3870\"},{\"mcc\":\"3871\"},{\"mcc\":\"3630\"},{\"mcc\":\"3872\"},{\"mcc\":\"3631\"},{\"mcc\":\"3873\"},{\"mcc\":\"3632\"},{\"mcc\":\"3874\"},{\"mcc\":\"5810\"},{\"mcc\":\"3633\"},{\"mcc\":\"3875\"},{\"mcc\":\"4722\"},{\"mcc\":\"5811\"},{\"mcc\":\"3634\"},{\"mcc\":\"3876\"},{\"mcc\":\"5812\"},{\"mcc\":\"2541\"},{\"mcc\":\"3624\"},{\"mcc\":\"3866\"},{\"mcc\":\"5802\"},{\"mcc\":\"3625\"},{\"mcc\":\"3867\"},{\"mcc\":\"5803\"},{\"mcc\":\"3626\"},{\"mcc\":\"3868\"},{\"mcc\":\"5804\"},{\"mcc\":\"3627\"},{\"mcc\":\"3869\"},{\"mcc\":\"5805\"},{\"mcc\":\"3628\"},{\"mcc\":\"5806\"},{\"mcc\":\"3629\"},{\"mcc\":\"5807\"},{\"mcc\":\"5808\"},{\"mcc\":\"5809\"},{\"mcc\":\"3880\"},{\"mcc\":\"3881\"},{\"mcc\":\"3640\"},{\"mcc\":\"3882\"},{\"mcc\":\"3641\"},{\"mcc\":\"3883\"},{\"mcc\":\"3642\"},{\"mcc\":\"3884\"},{\"mcc\":\"5820\"},{\"mcc\":\"3643\"},{\"mcc\":\"3885\"},{\"mcc\":\"5821\"},{\"mcc\":\"3644\"},{\"mcc\":\"3886\"},{\"mcc\":\"5822\"},{\"mcc\":\"3645\"},{\"mcc\":\"3887\"},{\"mcc\":\"5823\"},{\"mcc\":\"3403\"},{\"mcc\":\"3402\"},{\"mcc\":\"8099\"},{\"mcc\":\"3401\"},{\"mcc\":\"3400\"},{\"mcc\":\"1463\"},{\"mcc\":\"2791\"},{\"mcc\":\"3635\"},{\"mcc\":\"3877\"},{\"mcc\":\"5813\"},{\"mcc\":\"3636\"},{\"mcc\":\"3878\"},{\"mcc\":\"5814\"},{\"mcc\":\"3637\"},{\"mcc\":\"3879\"},{\"mcc\":\"5815\"},{\"mcc\":\"3638\"},{\"mcc\":\"5816\"},{\"mcc\":\"3639\"},{\"mcc\":\"5817\"},{\"mcc\":\"5818\"},{\"mcc\":\"5819\"},{\"mcc\":\"3891\"},{\"mcc\":\"3650\"},{\"mcc\":\"3892\"},{\"mcc\":\"3651\"},{\"mcc\":\"3893\"},{\"mcc\":\"3652\"},{\"mcc\":\"3894\"},{\"mcc\":\"5830\"},{\"mcc\":\"3653\"},{\"mcc\":\"3895\"},{\"mcc\":\"5831\"},{\"mcc\":\"3654\"},{\"mcc\":\"3896\"},{\"mcc\":\"5832\"},{\"mcc\":\"3655\"},{\"mcc\":\"3897\"},{\"mcc\":\"5833\"},{\"mcc\":\"3656\"},{\"mcc\":\"3898\"},{\"mcc\":\"5834\"},{\"mcc\":\"3414\"},{\"mcc\":\"3413\"},{\"mcc\":\"3412\"},{\"mcc\":\"3411\"},{\"mcc\":\"3410\"},{\"mcc\":\"1471\"},{\"mcc\":\"3890\"},{\"mcc\":\"3409\"},{\"mcc\":\"3408\"},{\"mcc\":\"3407\"},{\"mcc\":\"3406\"},{\"mcc\":\"3405\"},{\"mcc\":\"3404\"},{\"mcc\":\"3646\"},{\"mcc\":\"3888\"},{\"mcc\":\"5824\"},{\"mcc\":\"3647\"},{\"mcc\":\"3889\"},{\"mcc\":\"5825\"},{\"mcc\":\"3648\"},{\"mcc\":\"5826\"},{\"mcc\":\"3649\"},{\"mcc\":\"5827\"},{\"mcc\":\"5828\"},{\"mcc\":\"5829\"},{\"mcc\":\"3660\"},{\"mcc\":\"3661\"},{\"mcc\":\"3662\"},{\"mcc\":\"5840\"},{\"mcc\":\"3663\"},{\"mcc\":\"5841\"},{\"mcc\":\"3664\"},{\"mcc\":\"4511\"},{\"mcc\":\"5842\"},{\"mcc\":\"3665\"},{\"mcc\":\"5843\"},{\"mcc\":\"3666\"},{\"mcc\":\"5844\"},{\"mcc\":\"3667\"},{\"mcc\":\"5845\"},{\"mcc\":\"3425\"},{\"mcc\":\"3424\"},{\"mcc\":\"3423\"},{\"mcc\":\"3422\"},{\"mcc\":\"3421\"},{\"mcc\":\"3420\"},{\"mcc\":\"3419\"},{\"mcc\":\"3418\"},{\"mcc\":\"3417\"},{\"mcc\":\"3416\"},{\"mcc\":\"3415\"},{\"mcc\":\"3657\"},{\"mcc\":\"3899\"},{\"mcc\":\"5835\"},{\"mcc\":\"3658\"},{\"mcc\":\"5836\"},{\"mcc\":\"3659\"},{\"mcc\":\"5837\"},{\"mcc\":\"5838\"},{\"mcc\":\"5839\"},{\"mcc\":\"3671\"},{\"mcc\":\"3672\"},{\"mcc\":\"5850\"},{\"mcc\":\"3673\"},{\"mcc\":\"5851\"},{\"mcc\":\"3674\"},{\"mcc\":\"5852\"},{\"mcc\":\"3675\"},{\"mcc\":\"5611\"},{\"mcc\":\"5853\"},{\"mcc\":\"3676\"},{\"mcc\":\"5854\"},{\"mcc\":\"3677\"},{\"mcc\":\"5855\"},{\"mcc\":\"3678\"},{\"mcc\":\"5856\"},{\"mcc\":\"3436\"},{\"mcc\":\"3435\"},{\"mcc\":\"3434\"},{\"mcc\":\"3433\"},{\"mcc\":\"3432\"},{\"mcc\":\"3431\"},{\"mcc\":\"3430\"},{\"mcc\":\"3670\"},{\"mcc\":\"3429\"},{\"mcc\":\"3428\"},{\"mcc\":\"3427\"},{\"mcc\":\"3426\"},{\"mcc\":\"3668\"},{\"mcc\":\"5846\"},{\"mcc\":\"3669\"},{\"mcc\":\"5847\"},{\"mcc\":\"5848\"},{\"mcc\":\"5849\"},{\"mcc\":\"3682\"},{\"mcc\":\"5860\"},{\"mcc\":\"3683\"},{\"mcc\":\"5861\"},{\"mcc\":\"3684\"},{\"mcc\":\"5862\"},{\"mcc\":\"3685\"},{\"mcc\":\"5621\"},{\"mcc\":\"5863\"},{\"mcc\":\"3686\"},{\"mcc\":\"5864\"},{\"mcc\":\"7801\"},{\"mcc\":\"3687\"},{\"mcc\":\"5865\"},{\"mcc\":\"3688\"},{\"mcc\":\"5866\"},{\"mcc\":\"3689\"},{\"mcc\":\"5867\"},{\"mcc\":\"7802\"},{\"mcc\":\"3205\"},{\"mcc\":\"3204\"},{\"mcc\":\"3203\"},{\"mcc\":\"3202\"},{\"mcc\":\"3201\"},{\"mcc\":\"3200\"},{\"mcc\":\"3442\"},{\"mcc\":\"3441\"},{\"mcc\":\"3680\"},{\"mcc\":\"3440\"},{\"mcc\":\"3681\"},{\"mcc\":\"3439\"},{\"mcc\":\"3438\"},{\"mcc\":\"3437\"},{\"mcc\":\"3679\"},{\"mcc\":\"5857\"},{\"mcc\":\"5858\"},{\"mcc\":\"5859\"},{\"mcc\":\"3693\"},{\"mcc\":\"5871\"},{\"mcc\":\"3694\"},{\"mcc\":\"5872\"},{\"mcc\":\"3695\"},{\"mcc\":\"4784\"},{\"mcc\":\"5631\"},{\"mcc\":\"5873\"},{\"mcc\":\"3696\"},{\"mcc\":\"5874\"},{\"mcc\":\"3697\"},{\"mcc\":\"5875\"},{\"mcc\":\"3698\"},{\"mcc\":\"5876\"},{\"mcc\":\"3699\"},{\"mcc\":\"5877\"},{\"mcc\":\"4789\"},{\"mcc\":\"5878\"},{\"mcc\":\"3216\"},{\"mcc\":\"3215\"},{\"mcc\":\"3214\"},{\"mcc\":\"3213\"},{\"mcc\":\"3212\"},{\"mcc\":\"3211\"},{\"mcc\":\"3690\"},{\"mcc\":\"3210\"},{\"mcc\":\"3691\"},{\"mcc\":\"3692\"},{\"mcc\":\"5870\"},{\"mcc\":\"3209\"},{\"mcc\":\"3208\"},{\"mcc\":\"3207\"},{\"mcc\":\"3206\"},{\"mcc\":\"5868\"},{\"mcc\":\"5869\"},{\"mcc\":\"5882\"},{\"mcc\":\"5641\"},{\"mcc\":\"5883\"},{\"mcc\":\"5884\"},{\"mcc\":\"5885\"},{\"mcc\":\"5886\"},{\"mcc\":\"5887\"},{\"mcc\":\"5888\"},{\"mcc\":\"8911\"},{\"mcc\":\"5889\"},{\"mcc\":\"3227\"},{\"mcc\":\"3226\"},{\"mcc\":\"3225\"},{\"mcc\":\"3224\"},{\"mcc\":\"3223\"},{\"mcc\":\"3222\"},{\"mcc\":\"3221\"},{\"mcc\":\"5880\"},{\"mcc\":\"3220\"},{\"mcc\":\"5881\"},{\"mcc\":\"3219\"},{\"mcc\":\"3218\"},{\"mcc\":\"3217\"},{\"mcc\":\"5879\"},{\"mcc\":\"3230\"},{\"mcc\":\"5651\"},{\"mcc\":\"5893\"},{\"mcc\":\"5894\"},{\"mcc\":\"5411\"},{\"mcc\":\"5895\"},{\"mcc\":\"7832\"},{\"mcc\":\"5896\"},{\"mcc\":\"5655\"},{\"mcc\":\"5897\"},{\"mcc\":\"5898\"},{\"mcc\":\"5899\"},{\"mcc\":\"3238\"},{\"mcc\":\"3237\"},{\"mcc\":\"3236\"},{\"mcc\":\"3235\"},{\"mcc\":\"3234\"},{\"mcc\":\"3233\"},{\"mcc\":\"5890\"},{\"mcc\":\"3232\"},{\"mcc\":\"5891\"},{\"mcc\":\"3231\"},{\"mcc\":\"5892\"},{\"mcc\":\"3229\"},{\"mcc\":\"3228\"},{\"mcc\":\"7829\"},{\"mcc\":\"3241\"},{\"mcc\":\"7841\"},{\"mcc\":\"8931\"},{\"mcc\":\"3240\"},{\"mcc\":\"5422\"},{\"mcc\":\"6513\"},{\"mcc\":\"3007\"},{\"mcc\":\"3249\"},{\"mcc\":\"3006\"},{\"mcc\":\"3248\"},{\"mcc\":\"3005\"},{\"mcc\":\"3247\"},{\"mcc\":\"3004\"},{\"mcc\":\"3246\"},{\"mcc\":\"3003\"},{\"mcc\":\"3245\"},{\"mcc\":\"3002\"},{\"mcc\":\"3244\"},{\"mcc\":\"3001\"},{\"mcc\":\"3243\"},{\"mcc\":\"3000\"},{\"mcc\":\"3242\"},{\"mcc\":\"5661\"},{\"mcc\":\"3239\"},{\"mcc\":\"3010\"},{\"mcc\":\"3252\"},{\"mcc\":\"3251\"},{\"mcc\":\"3250\"},{\"mcc\":\"3018\"},{\"mcc\":\"3017\"},{\"mcc\":\"3259\"},{\"mcc\":\"3016\"},{\"mcc\":\"3258\"},{\"mcc\":\"3015\"},{\"mcc\":\"3257\"},{\"mcc\":\"3014\"},{\"mcc\":\"3256\"},{\"mcc\":\"3013\"},{\"mcc\":\"3255\"},{\"mcc\":\"3012\"},{\"mcc\":\"3254\"},{\"mcc\":\"4582\"},{\"mcc\":\"3011\"},{\"mcc\":\"3253\"},{\"mcc\":\"3009\"},{\"mcc\":\"3008\"},{\"mcc\":\"3021\"},{\"mcc\":\"3263\"},{\"mcc\":\"4111\"},{\"mcc\":\"5200\"},{\"mcc\":\"6532\"},{\"mcc\":\"3020\"},{\"mcc\":\"3262\"},{\"mcc\":\"4112\"},{\"mcc\":\"3261\"},{\"mcc\":\"7623\"},{\"mcc\":\"3260\"},{\"mcc\":\"6533\"},{\"mcc\":\"7622\"},{\"mcc\":\"6536\"},{\"mcc\":\"6537\"},{\"mcc\":\"3029\"},{\"mcc\":\"3028\"},{\"mcc\":\"3027\"},{\"mcc\":\"3269\"},{\"mcc\":\"3026\"},{\"mcc\":\"3268\"},{\"mcc\":\"3025\"},{\"mcc\":\"3267\"},{\"mcc\":\"3024\"},{\"mcc\":\"3266\"},{\"mcc\":\"5681\"},{\"mcc\":\"3023\"},{\"mcc\":\"3265\"},{\"mcc\":\"3022\"},{\"mcc\":\"3264\"},{\"mcc\":\"5441\"},{\"mcc\":\"3032\"},{\"mcc\":\"3274\"},{\"mcc\":\"5211\"},{\"mcc\":\"3031\"},{\"mcc\":\"3273\"},{\"mcc\":\"6300\"},{\"mcc\":\"7631\"},{\"mcc\":\"3030\"},{\"mcc\":\"3272\"},{\"mcc\":\"5697\"},{\"mcc\":\"3271\"},{\"mcc\":\"5698\"},{\"mcc\":\"3270\"},{\"mcc\":\"5699\"},{\"mcc\":\"3039\"},{\"mcc\":\"3038\"},{\"mcc\":\"3037\"},{\"mcc\":\"3279\"},{\"mcc\":\"3036\"},{\"mcc\":\"3278\"},{\"mcc\":\"5691\"},{\"mcc\":\"3035\"},{\"mcc\":\"3277\"},{\"mcc\":\"3034\"},{\"mcc\":\"3276\"},{\"mcc\":\"5451\"},{\"mcc\":\"3033\"},{\"mcc\":\"3275\"},{\"mcc\":\"4121\"},{\"mcc\":\"6540\"},{\"mcc\":\"4119\"},{\"mcc\":\"7629\"},{\"mcc\":\"3043\"},{\"mcc\":\"3285\"},{\"mcc\":\"3042\"},{\"mcc\":\"3284\"},{\"mcc\":\"8734\"},{\"mcc\":\"3041\"},{\"mcc\":\"3283\"},{\"mcc\":\"3040\"},{\"mcc\":\"3282\"},{\"mcc\":\"3281\"},{\"mcc\":\"3280\"},{\"mcc\":\"3049\"},{\"mcc\":\"3048\"},{\"mcc\":\"3047\"},{\"mcc\":\"3289\"},{\"mcc\":\"3046\"},{\"mcc\":\"3288\"},{\"mcc\":\"3045\"},{\"mcc\":\"3287\"},{\"mcc\":\"4131\"},{\"mcc\":\"5462\"},{\"mcc\":\"7641\"},{\"mcc\":\"3044\"},{\"mcc\":\"3286\"},{\"mcc\":\"3054\"},{\"mcc\":\"3296\"},{\"mcc\":\"3053\"},{\"mcc\":\"3295\"},{\"mcc\":\"3052\"},{\"mcc\":\"3294\"},{\"mcc\":\"3051\"},{\"mcc\":\"3293\"},{\"mcc\":\"3050\"},{\"mcc\":\"3292\"},{\"mcc\":\"3291\"},{\"mcc\":\"3290\"},{\"mcc\":\"3059\"},{\"mcc\":\"3058\"},{\"mcc\":\"3057\"},{\"mcc\":\"3299\"},{\"mcc\":\"3056\"},{\"mcc\":\"3298\"},{\"mcc\":\"5231\"},{\"mcc\":\"3055\"},{\"mcc\":\"3297\"},{\"mcc\":\"3065\"},{\"mcc\":\"3064\"},{\"mcc\":\"3063\"},{\"mcc\":\"3062\"},{\"mcc\":\"3061\"},{\"mcc\":\"3060\"},{\"mcc\":\"8999\"},{\"mcc\":\"3069\"},{\"mcc\":\"3068\"},{\"mcc\":\"3067\"},{\"mcc\":\"3066\"},{\"mcc\":\"3076\"},{\"mcc\":\"5013\"},{\"mcc\":\"3075\"},{\"mcc\":\"3074\"},{\"mcc\":\"5499\"},{\"mcc\":\"3073\"},{\"mcc\":\"3072\"},{\"mcc\":\"3071\"},{\"mcc\":\"3070\"},{\"mcc\":\"5251\"},{\"mcc\":\"3079\"},{\"mcc\":\"3078\"},{\"mcc\":\"3077\"},{\"mcc\":\"3087\"},{\"mcc\":\"3086\"},{\"mcc\":\"3085\"},{\"mcc\":\"3084\"},{\"mcc\":\"3083\"},{\"mcc\":\"3082\"},{\"mcc\":\"3081\"},{\"mcc\":\"3080\"},{\"mcc\":\"5261\"},{\"mcc\":\"5021\"},{\"mcc\":\"3089\"},{\"mcc\":\"3088\"},{\"mcc\":\"3098\"},{\"mcc\":\"3097\"},{\"mcc\":\"3096\"},{\"mcc\":\"7216\"},{\"mcc\":\"3095\"},{\"mcc\":\"7699\"},{\"mcc\":\"3094\"},{\"mcc\":\"5039\"},{\"mcc\":\"3093\"},{\"mcc\":\"7217\"},{\"mcc\":\"3092\"},{\"mcc\":\"3091\"},{\"mcc\":\"5271\"},{\"mcc\":\"7692\"},{\"mcc\":\"7210\"},{\"mcc\":\"3099\"},{\"mcc\":\"7211\"},{\"mcc\":\"3090\"},{\"mcc\":\"5046\"},{\"mcc\":\"5047\"},{\"mcc\":\"9405\"},{\"mcc\":\"9402\"},{\"mcc\":\"9406\"},{\"mcc\":\"7221\"},{\"mcc\":\"5044\"},{\"mcc\":\"5045\"},{\"mcc\":\"5051\"},{\"mcc\":\"7230\"},{\"mcc\":\"7231\"},{\"mcc\":\"5065\"},{\"mcc\":\"5072\"},{\"mcc\":\"5074\"},{\"mcc\":\"7251\"},{\"mcc\":\"7012\"},{\"mcc\":\"7011\"},{\"mcc\":\"7261\"},{\"mcc\":\"8351\"},{\"mcc\":\"5085\"},{\"mcc\":\"8111\"},{\"mcc\":\"1711\"},{\"mcc\":\"1731\"},{\"mcc\":\"5094\"},{\"mcc\":\"7032\"},{\"mcc\":\"7273\"},{\"mcc\":\"7276\"},{\"mcc\":\"7033\"},{\"mcc\":\"5099\"},{\"mcc\":\"7278\"},{\"mcc\":\"9211\"},{\"mcc\":\"7277\"},{\"mcc\":\"3907\"},{\"mcc\":\"3908\"},{\"mcc\":\"3909\"},{\"mcc\":\"3900\"},{\"mcc\":\"3901\"},{\"mcc\":\"3902\"},{\"mcc\":\"3903\"},{\"mcc\":\"3904\"},{\"mcc\":\"3905\"},{\"mcc\":\"3906\"},{\"mcc\":\"3920\"},{\"mcc\":\"1740\"},{\"mcc\":\"9222\"},{\"mcc\":\"3918\"},{\"mcc\":\"3919\"},{\"mcc\":\"3910\"},{\"mcc\":\"3911\"},{\"mcc\":\"3912\"},{\"mcc\":\"3913\"},{\"mcc\":\"3914\"},{\"mcc\":\"3915\"},{\"mcc\":\"3916\"},{\"mcc\":\"3917\"},{\"mcc\":\"3930\"},{\"mcc\":\"3931\"},{\"mcc\":\"2842\"},{\"mcc\":\"7296\"},{\"mcc\":\"1750\"},{\"mcc\":\"7298\"},{\"mcc\":\"7297\"},{\"mcc\":\"7299\"},{\"mcc\":\"3929\"},{\"mcc\":\"3921\"},{\"mcc\":\"3922\"},{\"mcc\":\"3923\"},{\"mcc\":\"3924\"},{\"mcc\":\"3925\"},{\"mcc\":\"3926\"},{\"mcc\":\"3927\"},{\"mcc\":\"3928\"},{\"mcc\":\"3940\"},{\"mcc\":\"3941\"},{\"mcc\":\"3700\"},{\"mcc\":\"3942\"},{\"mcc\":\"1520\"},{\"mcc\":\"1761\"},{\"mcc\":\"8398\"},{\"mcc\":\"3932\"},{\"mcc\":\"3933\"},{\"mcc\":\"3934\"},{\"mcc\":\"3935\"},{\"mcc\":\"3936\"},{\"mcc\":\"3937\"},{\"mcc\":\"3938\"},{\"mcc\":\"3939\"},{\"mcc\":\"3950\"},{\"mcc\":\"3951\"},{\"mcc\":\"3710\"},{\"mcc\":\"3952\"},{\"mcc\":\"3711\"},{\"mcc\":\"3953\"},{\"mcc\":\"1771\"},{\"mcc\":\"3709\"},{\"mcc\":\"3701\"},{\"mcc\":\"3943\"},{\"mcc\":\"3702\"},{\"mcc\":\"3944\"},{\"mcc\":\"3703\"},{\"mcc\":\"3945\"},{\"mcc\":\"3704\"},{\"mcc\":\"3946\"},{\"mcc\":\"3705\"},{\"mcc\":\"3947\"},{\"mcc\":\"3706\"},{\"mcc\":\"3948\"},{\"mcc\":\"3707\"},{\"mcc\":\"3949\"},{\"mcc\":\"3708\"},{\"mcc\":\"3960\"},{\"mcc\":\"3961\"},{\"mcc\":\"3720\"},{\"mcc\":\"3962\"},{\"mcc\":\"3721\"},{\"mcc\":\"3963\"},{\"mcc\":\"3722\"},{\"mcc\":\"3964\"},{\"mcc\":\"5900\"},{\"mcc\":\"3712\"},{\"mcc\":\"3954\"},{\"mcc\":\"3713\"},{\"mcc\":\"3955\"},{\"mcc\":\"3714\"},{\"mcc\":\"3956\"},{\"mcc\":\"3715\"},{\"mcc\":\"3957\"},{\"mcc\":\"3716\"},{\"mcc\":\"3958\"},{\"mcc\":\"3717\"},{\"mcc\":\"3959\"},{\"mcc\":\"3718\"},{\"mcc\":\"3719\"},{\"mcc\":\"3970\"},{\"mcc\":\"3971\"},{\"mcc\":\"3730\"},{\"mcc\":\"3972\"},{\"mcc\":\"3731\"},{\"mcc\":\"3973\"},{\"mcc\":\"3732\"},{\"mcc\":\"3974\"},{\"mcc\":\"4821\"},{\"mcc\":\"5910\"},{\"mcc\":\"3733\"},{\"mcc\":\"3975\"},{\"mcc\":\"5911\"},{\"mcc\":\"5909\"},{\"mcc\":\"3723\"},{\"mcc\":\"3965\"},{\"mcc\":\"4812\"},{\"mcc\":\"5901\"},{\"mcc\":\"3724\"},{\"mcc\":\"3966\"},{\"mcc\":\"5902\"},{\"mcc\":\"3725\"},{\"mcc\":\"3967\"},{\"mcc\":\"4814\"},{\"mcc\":\"5903\"},{\"mcc\":\"3726\"},{\"mcc\":\"3968\"},{\"mcc\":\"5904\"},{\"mcc\":\"3727\"},{\"mcc\":\"3969\"},{\"mcc\":\"4816\"},{\"mcc\":\"5905\"},{\"mcc\":\"3728\"},{\"mcc\":\"5906\"},{\"mcc\":\"3729\"},{\"mcc\":\"5907\"},{\"mcc\":\"5908\"},{\"mcc\":\"3980\"},{\"mcc\":\"3981\"},{\"mcc\":\"3740\"},{\"mcc\":\"3982\"},{\"mcc\":\"3741\"},{\"mcc\":\"3983\"},{\"mcc\":\"3742\"},{\"mcc\":\"3984\"},{\"mcc\":\"5920\"},{\"mcc\":\"3743\"},{\"mcc\":\"3985\"},{\"mcc\":\"5921\"},{\"mcc\":\"3744\"},{\"mcc\":\"3986\"},{\"mcc\":\"5922\"},{\"mcc\":\"3502\"},{\"mcc\":\"3501\"},{\"mcc\":\"1799\"},{\"mcc\":\"3734\"},{\"mcc\":\"3976\"},{\"mcc\":\"5912\"},{\"mcc\":\"3735\"},{\"mcc\":\"3977\"},{\"mcc\":\"5913\"},{\"mcc\":\"3736\"},{\"mcc\":\"3978\"},{\"mcc\":\"5914\"},{\"mcc\":\"3737\"},{\"mcc\":\"3979\"},{\"mcc\":\"5915\"},{\"mcc\":\"3738\"},{\"mcc\":\"5916\"},{\"mcc\":\"3739\"},{\"mcc\":\"5917\"},{\"mcc\":\"4829\"},{\"mcc\":\"5918\"},{\"mcc\":\"5919\"},{\"mcc\":\"3990\"},{\"mcc\":\"3991\"},{\"mcc\":\"3750\"},{\"mcc\":\"3992\"},{\"mcc\":\"3751\"},{\"mcc\":\"3993\"},{\"mcc\":\"3752\"},{\"mcc\":\"3994\"},{\"mcc\":\"5930\"},{\"mcc\":\"3753\"},{\"mcc\":\"3995\"},{\"mcc\":\"5931\"},{\"mcc\":\"3754\"},{\"mcc\":\"3996\"},{\"mcc\":\"5932\"},{\"mcc\":\"3755\"},{\"mcc\":\"3997\"},{\"mcc\":\"5933\"},{\"mcc\":\"3513\"},{\"mcc\":\"3512\"},{\"mcc\":\"3511\"},{\"mcc\":\"3510\"},{\"mcc\":\"3509\"},{\"mcc\":\"3508\"},{\"mcc\":\"3507\"},{\"mcc\":\"3506\"},{\"mcc\":\"3505\"},{\"mcc\":\"3504\"},{\"mcc\":\"3503\"},{\"mcc\":\"3745\"},{\"mcc\":\"3987\"},{\"mcc\":\"5923\"},{\"mcc\":\"3746\"},{\"mcc\":\"3988\"},{\"mcc\":\"5924\"},{\"mcc\":\"3747\"},{\"mcc\":\"3989\"},{\"mcc\":\"5925\"},{\"mcc\":\"3748\"},{\"mcc\":\"5926\"},{\"mcc\":\"3749\"},{\"mcc\":\"5927\"},{\"mcc\":\"5928\"},{\"mcc\":\"5929\"},{\"mcc\":\"3760\"},{\"mcc\":\"3761\"},{\"mcc\":\"3762\"},{\"mcc\":\"5940\"},{\"mcc\":\"3763\"},{\"mcc\":\"5941\"},{\"mcc\":\"3764\"},{\"mcc\":\"5942\"},{\"mcc\":\"3765\"},{\"mcc\":\"5943\"},{\"mcc\":\"3766\"},{\"mcc\":\"5944\"},{\"mcc\":\"3524\"},{\"mcc\":\"3523\"},{\"mcc\":\"3522\"},{\"mcc\":\"3521\"},{\"mcc\":\"3520\"},{\"mcc\":\"3519\"},{\"mcc\":\"3518\"},{\"mcc\":\"3517\"},{\"mcc\":\"3516\"},{\"mcc\":\"3515\"},{\"mcc\":\"3514\"},{\"mcc\":\"3756\"},{\"mcc\":\"3998\"},{\"mcc\":\"5934\"},{\"mcc\":\"3757\"},{\"mcc\":\"3999\"},{\"mcc\":\"5935\"},{\"mcc\":\"3758\"},{\"mcc\":\"5936\"},{\"mcc\":\"3759\"},{\"mcc\":\"5937\"},{\"mcc\":\"5938\"},{\"mcc\":\"5939\"},{\"mcc\":\"3770\"},{\"mcc\":\"3771\"},{\"mcc\":\"3772\"},{\"mcc\":\"5950\"},{\"mcc\":\"3773\"},{\"mcc\":\"5951\"},{\"mcc\":\"3774\"},{\"mcc\":\"5952\"},{\"mcc\":\"3775\"},{\"mcc\":\"5953\"},{\"mcc\":\"3776\"},{\"mcc\":\"5712\"},{\"mcc\":\"5954\"},{\"mcc\":\"3777\"},{\"mcc\":\"5713\"},{\"mcc\":\"5955\"},{\"mcc\":\"3535\"},{\"mcc\":\"3534\"},{\"mcc\":\"3533\"},{\"mcc\":\"3532\"},{\"mcc\":\"3531\"},{\"mcc\":\"3530\"},{\"mcc\":\"3529\"},{\"mcc\":\"3528\"},{\"mcc\":\"3527\"},{\"mcc\":\"3526\"},{\"mcc\":\"3525\"},{\"mcc\":\"3767\"},{\"mcc\":\"5945\"},{\"mcc\":\"3768\"},{\"mcc\":\"5946\"},{\"mcc\":\"3769\"},{\"mcc\":\"5947\"},{\"mcc\":\"5948\"},{\"mcc\":\"5949\"},{\"mcc\":\"3781\"},{\"mcc\":\"3782\"},{\"mcc\":\"5960\"},{\"mcc\":\"3783\"},{\"mcc\":\"5961\"},{\"mcc\":\"3784\"},{\"mcc\":\"5962\"},{\"mcc\":\"3785\"},{\"mcc\":\"5963\"},{\"mcc\":\"3786\"},{\"mcc\":\"5722\"},{\"mcc\":\"5964\"},{\"mcc\":\"3787\"},{\"mcc\":\"5965\"},{\"mcc\":\"3788\"},{\"mcc\":\"5966\"},{\"mcc\":\"3546\"},{\"mcc\":\"3545\"},{\"mcc\":\"3544\"},{\"mcc\":\"3301\"},{\"mcc\":\"3543\"},{\"mcc\":\"3542\"},{\"mcc\":\"3541\"},{\"mcc\":\"3540\"},{\"mcc\":\"3780\"},{\"mcc\":\"3539\"},{\"mcc\":\"3538\"},{\"mcc\":\"3537\"},{\"mcc\":\"3536\"},{\"mcc\":\"3778\"},{\"mcc\":\"5714\"},{\"mcc\":\"5956\"},{\"mcc\":\"3779\"},{\"mcc\":\"5957\"},{\"mcc\":\"5958\"},{\"mcc\":\"5959\"},{\"mcc\":\"5718\"},{\"mcc\":\"5719\"},{\"mcc\":\"3792\"},{\"mcc\":\"5970\"},{\"mcc\":\"3793\"},{\"mcc\":\"5971\"},{\"mcc\":\"3794\"},{\"mcc\":\"5972\"},{\"mcc\":\"3795\"},{\"mcc\":\"5973\"},{\"mcc\":\"3796\"},{\"mcc\":\"5732\"},{\"mcc\":\"5974\"},{\"mcc\":\"7911\"},{\"mcc\":\"3797\"},{\"mcc\":\"5733\"},{\"mcc\":\"5975\"},{\"mcc\":\"3798\"},{\"mcc\":\"5734\"},{\"mcc\":\"5976\"},{\"mcc\":\"3799\"},{\"mcc\":\"5735\"},{\"mcc\":\"5977\"},{\"mcc\":\"3557\"},{\"mcc\":\"3556\"},{\"mcc\":\"3555\"},{\"mcc\":\"3554\"},{\"mcc\":\"3553\"},{\"mcc\":\"3552\"},{\"mcc\":\"3551\"},{\"mcc\":\"3790\"},{\"mcc\":\"3550\"},{\"mcc\":\"3791\"},{\"mcc\":\"3549\"},{\"mcc\":\"3548\"},{\"mcc\":\"3547\"},{\"mcc\":\"3789\"},{\"mcc\":\"5967\"},{\"mcc\":\"5968\"},{\"mcc\":\"5969\"},{\"mcc\":\"3560\"},{\"mcc\":\"5981\"},{\"mcc\":\"5740\"},{\"mcc\":\"5982\"},{\"mcc\":\"5741\"},{\"mcc\":\"5983\"},{\"mcc\":\"4411\"},{\"mcc\":\"5742\"},{\"mcc\":\"5984\"},{\"mcc\":\"5743\"},{\"mcc\":\"5985\"},{\"mcc\":\"7922\"},{\"mcc\":\"5744\"},{\"mcc\":\"5986\"},{\"mcc\":\"5745\"},{\"mcc\":\"5987\"},{\"mcc\":\"4899\"},{\"mcc\":\"5746\"},{\"mcc\":\"5988\"},{\"mcc\":\"3568\"},{\"mcc\":\"3567\"},{\"mcc\":\"3566\"},{\"mcc\":\"3565\"},{\"mcc\":\"3564\"},{\"mcc\":\"3563\"},{\"mcc\":\"3562\"},{\"mcc\":\"3561\"},{\"mcc\":\"5980\"},{\"mcc\":\"3559\"},{\"mcc\":\"3558\"},{\"mcc\":\"5736\"},{\"mcc\":\"5978\"},{\"mcc\":\"5737\"},{\"mcc\":\"5979\"},{\"mcc\":\"5738\"},{\"mcc\":\"5739\"},{\"mcc\":\"3571\"},{\"mcc\":\"5750\"},{\"mcc\":\"5992\"},{\"mcc\":\"3570\"},{\"mcc\":\"5751\"},{\"mcc\":\"5993\"},{\"mcc\":\"5752\"},{\"mcc\":\"5994\"},{\"mcc\":\"5511\"},{\"mcc\":\"5753\"},{\"mcc\":\"5995\"},{\"mcc\":\"5754\"},{\"mcc\":\"5996\"},{\"mcc\":\"7933\"},{\"mcc\":\"5755\"},{\"mcc\":\"5997\"},{\"mcc\":\"7932\"},{\"mcc\":\"5756\"},{\"mcc\":\"5998\"},{\"mcc\":\"5757\"},{\"mcc\":\"5999\"},{\"mcc\":\"3579\"},{\"mcc\":\"3578\"},{\"mcc\":\"3577\"},{\"mcc\":\"3576\"},{\"mcc\":\"3575\"},{\"mcc\":\"3574\"},{\"mcc\":\"3573\"},{\"mcc\":\"5990\"},{\"mcc\":\"3572\"},{\"mcc\":\"5991\"},{\"mcc\":\"3569\"},{\"mcc\":\"5747\"},{\"mcc\":\"5989\"},{\"mcc\":\"5748\"},{\"mcc\":\"5749\"},{\"mcc\":\"7929\"},{\"mcc\":\"3582\"},{\"mcc\":\"5761\"},{\"mcc\":\"3581\"},{\"mcc\":\"5762\"},{\"mcc\":\"3580\"},{\"mcc\":\"5521\"},{\"mcc\":\"5763\"},{\"mcc\":\"5764\"},{\"mcc\":\"7941\"},{\"mcc\":\"5765\"},{\"mcc\":\"5766\"},{\"mcc\":\"5767\"},{\"mcc\":\"5768\"},{\"mcc\":\"3106\"},{\"mcc\":\"3105\"},{\"mcc\":\"3589\"},{\"mcc\":\"3104\"},{\"mcc\":\"3588\"},{\"mcc\":\"3103\"},{\"mcc\":\"3587\"},{\"mcc\":\"3102\"},{\"mcc\":\"3586\"},{\"mcc\":\"3101\"},{\"mcc\":\"3585\"},{\"mcc\":\"3100\"},{\"mcc\":\"3584\"},{\"mcc\":\"3583\"},{\"mcc\":\"5760\"},{\"mcc\":\"5758\"},{\"mcc\":\"5759\"},{\"mcc\":\"3351\"},{\"mcc\":\"3593\"},{\"mcc\":\"5772\"},{\"mcc\":\"3592\"},{\"mcc\":\"5531\"},{\"mcc\":\"5773\"},{\"mcc\":\"3591\"},{\"mcc\":\"5532\"},{\"mcc\":\"5774\"},{\"mcc\":\"3590\"},{\"mcc\":\"5533\"},{\"mcc\":\"5775\"},{\"mcc\":\"5776\"},{\"mcc\":\"5777\"},{\"mcc\":\"5778\"},{\"mcc\":\"5779\"},{\"mcc\":\"3117\"},{\"mcc\":\"3359\"},{\"mcc\":\"3116\"},{\"mcc\":\"3358\"},{\"mcc\":\"3115\"},{\"mcc\":\"3357\"},{\"mcc\":\"3599\"},{\"mcc\":\"3114\"},{\"mcc\":\"3356\"},{\"mcc\":\"3598\"},{\"mcc\":\"3113\"},{\"mcc\":\"3355\"},{\"mcc\":\"3597\"},{\"mcc\":\"3112\"},{\"mcc\":\"3354\"},{\"mcc\":\"3596\"},{\"mcc\":\"3111\"},{\"mcc\":\"3353\"},{\"mcc\":\"3595\"},{\"mcc\":\"5770\"},{\"mcc\":\"3110\"},{\"mcc\":\"3352\"},{\"mcc\":\"3594\"},{\"mcc\":\"5771\"},{\"mcc\":\"742\"},{\"mcc\":\"3109\"},{\"mcc\":\"3108\"},{\"mcc\":\"3107\"},{\"mcc\":\"5769\"},{\"mcc\":\"3120\"},{\"mcc\":\"3362\"},{\"mcc\":\"5541\"},{\"mcc\":\"5783\"},{\"mcc\":\"3361\"},{\"mcc\":\"5300\"},{\"mcc\":\"5542\"},{\"mcc\":\"5784\"},{\"mcc\":\"3360\"},{\"mcc\":\"5543\"},{\"mcc\":\"5785\"},{\"mcc\":\"5786\"},{\"mcc\":\"4214\"},{\"mcc\":\"5787\"},{\"mcc\":\"4215\"},{\"mcc\":\"4457\"},{\"mcc\":\"5788\"},{\"mcc\":\"5789\"},{\"mcc\":\"3128\"},{\"mcc\":\"3127\"},{\"mcc\":\"3369\"},{\"mcc\":\"3126\"},{\"mcc\":\"3368\"},{\"mcc\":\"3125\"},{\"mcc\":\"3367\"},{\"mcc\":\"3124\"},{\"mcc\":\"3366\"},{\"mcc\":\"3123\"},{\"mcc\":\"3365\"},{\"mcc\":\"5780\"},{\"mcc\":\"3122\"},{\"mcc\":\"3364\"},{\"mcc\":\"5781\"},{\"mcc\":\"3121\"},{\"mcc\":\"3363\"},{\"mcc\":\"5782\"},{\"mcc\":\"3119\"},{\"mcc\":\"3118\"},{\"mcc\":\"3131\"},{\"mcc\":\"3373\"},{\"mcc\":\"5310\"},{\"mcc\":\"5794\"},{\"mcc\":\"3130\"},{\"mcc\":\"3372\"},{\"mcc\":\"5311\"},{\"mcc\":\"5795\"},{\"mcc\":\"3371\"},{\"mcc\":\"5796\"},{\"mcc\":\"3370\"},{\"mcc\":\"5313\"},{\"mcc\":\"5797\"},{\"mcc\":\"4225\"},{\"mcc\":\"5314\"},{\"mcc\":\"5798\"},{\"mcc\":\"4468\"},{\"mcc\":\"5799\"},{\"mcc\":\"3139\"},{\"mcc\":\"3138\"},{\"mcc\":\"3137\"},{\"mcc\":\"3379\"},{\"mcc\":\"3136\"},{\"mcc\":\"3378\"},{\"mcc\":\"3377\"},{\"mcc\":\"5790\"},{\"mcc\":\"3134\"},{\"mcc\":\"3376\"},{\"mcc\":\"5791\"},{\"mcc\":\"3133\"},{\"mcc\":\"3375\"},{\"mcc\":\"5792\"},{\"mcc\":\"763\"},{\"mcc\":\"3132\"},{\"mcc\":\"3374\"},{\"mcc\":\"5551\"},{\"mcc\":\"5793\"},{\"mcc\":\"3129\"},{\"mcc\":\"5309\"},{\"mcc\":\"3142\"},{\"mcc\":\"3384\"},{\"mcc\":\"3141\"},{\"mcc\":\"3383\"},{\"mcc\":\"3140\"},{\"mcc\":\"3382\"},{\"mcc\":\"3381\"},{\"mcc\":\"3380\"},{\"mcc\":\"3149\"},{\"mcc\":\"3148\"},{\"mcc\":\"3147\"},{\"mcc\":\"3389\"},{\"mcc\":\"3146\"},{\"mcc\":\"3388\"},{\"mcc\":\"3145\"},{\"mcc\":\"3387\"},{\"mcc\":\"3144\"},{\"mcc\":\"3386\"},{\"mcc\":\"5561\"},{\"mcc\":\"3143\"},{\"mcc\":\"3385\"},{\"mcc\":\"3153\"},{\"mcc\":\"3395\"},{\"mcc\":\"7995\"},{\"mcc\":\"3152\"},{\"mcc\":\"3394\"},{\"mcc\":\"7994\"},{\"mcc\":\"3151\"},{\"mcc\":\"3393\"},{\"mcc\":\"7513\"},{\"mcc\":\"7997\"},{\"mcc\":\"3150\"},{\"mcc\":\"3392\"},{\"mcc\":\"7512\"},{\"mcc\":\"7996\"},{\"mcc\":\"3391\"},{\"mcc\":\"7999\"},{\"mcc\":\"3390\"},{\"mcc\":\"7998\"},{\"mcc\":\"780\"},{\"mcc\":\"3159\"},{\"mcc\":\"3158\"},{\"mcc\":\"3157\"},{\"mcc\":\"3399\"},{\"mcc\":\"7991\"},{\"mcc\":\"3156\"},{\"mcc\":\"3398\"},{\"mcc\":\"5571\"},{\"mcc\":\"3155\"},{\"mcc\":\"3397\"},{\"mcc\":\"7993\"},{\"mcc\":\"3154\"},{\"mcc\":\"3396\"},{\"mcc\":\"5331\"},{\"mcc\":\"7992\"},{\"mcc\":\"3164\"},{\"mcc\":\"4012\"},{\"mcc\":\"3163\"},{\"mcc\":\"3162\"},{\"mcc\":\"3161\"},{\"mcc\":\"7523\"},{\"mcc\":\"3160\"},{\"mcc\":\"3169\"},{\"mcc\":\"3168\"},{\"mcc\":\"3167\"},{\"mcc\":\"3166\"},{\"mcc\":\"3165\"},{\"mcc\":\"4011\"},{\"mcc\":\"7519\"},{\"mcc\":\"3175\"},{\"mcc\":\"3174\"},{\"mcc\":\"3173\"},{\"mcc\":\"5598\"},{\"mcc\":\"7535\"},{\"mcc\":\"3172\"},{\"mcc\":\"5599\"},{\"mcc\":\"7534\"},{\"mcc\":\"3171\"},{\"mcc\":\"3170\"},{\"mcc\":\"7539\"},{\"mcc\":\"7538\"},{\"mcc\":\"3179\"},{\"mcc\":\"5592\"},{\"mcc\":\"9950\"},{\"mcc\":\"3178\"},{\"mcc\":\"3177\"},{\"mcc\":\"7531\"},{\"mcc\":\"3176\"},{\"mcc\":\"5111\"},{\"mcc\":\"3186\"},{\"mcc\":\"3185\"},{\"mcc\":\"3184\"},{\"mcc\":\"3183\"},{\"mcc\":\"3182\"},{\"mcc\":\"3181\"},{\"mcc\":\"3180\"},{\"mcc\":\"7549\"},{\"mcc\":\"3189\"},{\"mcc\":\"3188\"},{\"mcc\":\"6211\"},{\"mcc\":\"7542\"},{\"mcc\":\"3187\"},{\"mcc\":\"5122\"},{\"mcc\":\"3197\"},{\"mcc\":\"3196\"},{\"mcc\":\"3195\"},{\"mcc\":\"3194\"},{\"mcc\":\"5137\"},{\"mcc\":\"3193\"},{\"mcc\":\"3192\"},{\"mcc\":\"5139\"},{\"mcc\":\"3191\"},{\"mcc\":\"3190\"},{\"mcc\":\"8641\"},{\"mcc\":\"5131\"},{\"mcc\":\"3199\"},{\"mcc\":\"7311\"},{\"mcc\":\"3198\"},{\"mcc\":\"7321\"},{\"mcc\":\"8651\"},{\"mcc\":\"10\"},{\"mcc\":\"11\"},{\"mcc\":\"12\"},{\"mcc\":\"13\"},{\"mcc\":\"14\"},{\"mcc\":\"15\"},{\"mcc\":\"16\"},{\"mcc\":\"17\"},{\"mcc\":\"5399\"},{\"mcc\":\"19\"},{\"mcc\":\"7339\"},{\"mcc\":\"7338\"},{\"mcc\":\"9753\"},{\"mcc\":\"7333\"},{\"mcc\":\"8661\"},{\"mcc\":\"21\"},{\"mcc\":\"22\"},{\"mcc\":\"24\"},{\"mcc\":\"25\"},{\"mcc\":\"26\"},{\"mcc\":\"27\"},{\"mcc\":\"5169\"},{\"mcc\":\"7349\"},{\"mcc\":\"6011\"},{\"mcc\":\"7342\"},{\"mcc\":\"6010\"},{\"mcc\":\"8675\"},{\"mcc\":\"6012\"},{\"mcc\":\"30\"},{\"mcc\":\"35\"},{\"mcc\":\"5172\"},{\"mcc\":\"41\"},{\"mcc\":\"8699\"},{\"mcc\":\"7361\"},{\"mcc\":\"8211\"},{\"mcc\":\"52\"},{\"mcc\":\"7379\"},{\"mcc\":\"5192\"},{\"mcc\":\"5193\"},{\"mcc\":\"8220\"},{\"mcc\":\"7372\"},{\"mcc\":\"7375\"},{\"mcc\":\"5198\"},{\"mcc\":\"5199\"},{\"mcc\":\"9311\"},{\"mcc\":\"60\"},{\"mcc\":\"6051\"},{\"mcc\":\"6050\"},{\"mcc\":\"71\"},{\"mcc\":\"74\"},{\"mcc\":\"8249\"},{\"mcc\":\"7393\"},{\"mcc\":\"8241\"},{\"mcc\":\"7392\"},{\"mcc\":\"7395\"},{\"mcc\":\"7394\"},{\"mcc\":\"7399\"},{\"mcc\":\"8244\"},{\"mcc\":\"8011\"},{\"mcc\":\"3810\"},{\"mcc\":\"8021\"},{\"mcc\":\"3808\"},{\"mcc\":\"3809\"},{\"mcc\":\"3800\"},{\"mcc\":\"3801\"},{\"mcc\":\"3802\"},{\"mcc\":\"3803\"},{\"mcc\":\"3804\"},{\"mcc\":\"3805\"},{\"mcc\":\"3806\"},{\"mcc\":\"3807\"},{\"mcc\":\"3820\"},{\"mcc\":\"3821\"},{\"mcc\":\"8031\"},{\"mcc\":\"3819\"},{\"mcc\":\"3811\"},{\"mcc\":\"4900\"},{\"mcc\":\"3812\"},{\"mcc\":\"3813\"},{\"mcc\":\"3814\"},{\"mcc\":\"3815\"},{\"mcc\":\"3816\"},{\"mcc\":\"3817\"},{\"mcc\":\"3818\"},{\"mcc\":\"8049\"},{\"mcc\":\"3830\"},{\"mcc\":\"3831\"},{\"mcc\":\"3832\"},{\"mcc\":\"8043\"},{\"mcc\":\"2741\"},{\"mcc\":\"8041\"},{\"mcc\":\"8042\"},{\"mcc\":\"1407\"},{\"mcc\":\"3822\"},{\"mcc\":\"3823\"},{\"mcc\":\"3824\"},{\"mcc\":\"3825\"},{\"mcc\":\"3826\"},{\"mcc\":\"3827\"},{\"mcc\":\"3828\"},{\"mcc\":\"3829\"},{\"mcc\":\"3840\"},{\"mcc\":\"3841\"},{\"mcc\":\"3842\"},{\"mcc\":\"3843\"},{\"mcc\":\"3601\"},{\"mcc\":\"3600\"},{\"mcc\":\"1421\"},{\"mcc\":\"8299\"},{\"mcc\":\"8050\"},{\"mcc\":\"3833\"},{\"mcc\":\"3834\"},{\"mcc\":\"3835\"},{\"mcc\":\"3836\"},{\"mcc\":\"3837\"},{\"mcc\":\"3838\"},{\"mcc\":\"3839\"},{\"mcc\":\"3850\"},{\"mcc\":\"3851\"},{\"mcc\":\"3852\"},{\"mcc\":\"3853\"},{\"mcc\":\"3854\"},{\"mcc\":\"3612\"},{\"mcc\":\"3611\"},{\"mcc\":\"3610\"},{\"mcc\":\"9399\"},{\"mcc\":\"3609\"},{\"mcc\":\"3608\"},{\"mcc\":\"3607\"},{\"mcc\":\"3606\"},{\"mcc\":\"3605\"},{\"mcc\":\"3604\"},{\"mcc\":\"8062\"},{\"mcc\":\"3603\"},{\"mcc\":\"3602\"},{\"mcc\":\"3844\"},{\"mcc\":\"3845\"},{\"mcc\":\"3846\"},{\"mcc\":\"3847\"},{\"mcc\":\"3848\"},{\"mcc\":\"3849\"}]'","metadata":{"execution":{"iopub.status.busy":"2022-07-10T08:03:49.636581Z","iopub.execute_input":"2022-07-10T08:03:49.637871Z","iopub.status.idle":"2022-07-10T08:03:49.672039Z","shell.execute_reply.started":"2022-07-10T08:03:49.637779Z","shell.execute_reply":"2022-07-10T08:03:49.669392Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"import json\naList = json.loads(jsonStr)","metadata":{"execution":{"iopub.status.busy":"2022-07-10T08:04:52.467408Z","iopub.execute_input":"2022-07-10T08:04:52.467904Z","iopub.status.idle":"2022-07-10T08:04:52.475903Z","shell.execute_reply.started":"2022-07-10T08:04:52.467865Z","shell.execute_reply":"2022-07-10T08:04:52.474396Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#list of merchant category codes in doconomy api\nmcc_list = []\nfor i in aList:\n    for key, val in i.items():\n        mcc_list.append(val)","metadata":{"execution":{"iopub.status.busy":"2022-07-10T08:18:59.551229Z","iopub.execute_input":"2022-07-10T08:18:59.551789Z","iopub.status.idle":"2022-07-10T08:18:59.559518Z","shell.execute_reply.started":"2022-07-10T08:18:59.551743Z","shell.execute_reply":"2022-07-10T08:18:59.557861Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#generate a list (of length 1963031) by selecting random numbers from mcc_list\nimport random\nmcc_rand_list = []\nfor i in range(0, 1963031):\n    mcc_rand_list.append(random.choice(mcc_list))","metadata":{"execution":{"iopub.status.busy":"2022-07-10T08:26:54.576107Z","iopub.execute_input":"2022-07-10T08:26:54.576558Z","iopub.status.idle":"2022-07-10T08:26:57.244917Z","shell.execute_reply.started":"2022-07-10T08:26:54.576507Z","shell.execute_reply":"2022-07-10T08:26:57.243583Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df['merchant_category_id'] = mcc_rand_list","metadata":{"execution":{"iopub.status.busy":"2022-07-10T08:29:51.266123Z","iopub.execute_input":"2022-07-10T08:29:51.266564Z","iopub.status.idle":"2022-07-10T08:29:51.387746Z","shell.execute_reply.started":"2022-07-10T08:29:51.266501Z","shell.execute_reply":"2022-07-10T08:29:51.386744Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df['merchant_category_id'].unique()","metadata":{"execution":{"iopub.status.busy":"2022-07-10T08:31:01.883977Z","iopub.execute_input":"2022-07-10T08:31:01.885091Z","iopub.status.idle":"2022-07-10T08:31:02.034409Z","shell.execute_reply.started":"2022-07-10T08:31:01.885052Z","shell.execute_reply":"2022-07-10T08:31:02.033262Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"#similarly for currencies\ncurr = [{\"currencyCode\":\"AUD\"},{\"currencyCode\":\"CAD\"},{\"currencyCode\":\"CHF\"},{\"currencyCode\":\"DKK\"},{\"currencyCode\":\"EUR\"},{\"currencyCode\":\"GBP\"},{\"currencyCode\":\"NOK\"},{\"currencyCode\":\"NZD\"},{\"currencyCode\":\"PLN\"},{\"currencyCode\":\"RUB\"},{\"currencyCode\":\"SEK\"},{\"currencyCode\":\"USD\"}]\ncurr_list = []\nfor i in curr:\n    for key, val in i.items():\n        curr_list.append(val)","metadata":{"execution":{"iopub.status.busy":"2022-07-10T08:35:41.247363Z","iopub.execute_input":"2022-07-10T08:35:41.247787Z","iopub.status.idle":"2022-07-10T08:35:41.255855Z","shell.execute_reply.started":"2022-07-10T08:35:41.247741Z","shell.execute_reply":"2022-07-10T08:35:41.254392Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"curr_rand_list = []\nfor i in range(0, 1963031):\n    curr_rand_list.append(random.choice(curr_list))","metadata":{"execution":{"iopub.status.busy":"2022-07-10T08:38:05.842691Z","iopub.execute_input":"2022-07-10T08:38:05.843108Z","iopub.status.idle":"2022-07-10T08:38:08.321274Z","shell.execute_reply.started":"2022-07-10T08:38:05.843077Z","shell.execute_reply":"2022-07-10T08:38:08.320050Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df['currency'] = curr_rand_list","metadata":{"execution":{"iopub.status.busy":"2022-07-10T08:43:14.645246Z","iopub.execute_input":"2022-07-10T08:43:14.645678Z","iopub.status.idle":"2022-07-10T08:43:14.737233Z","shell.execute_reply.started":"2022-07-10T08:43:14.645643Z","shell.execute_reply":"2022-07-10T08:43:14.736070Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df['currency'].unique()","metadata":{"execution":{"iopub.status.busy":"2022-07-10T08:43:27.977251Z","iopub.execute_input":"2022-07-10T08:43:27.977995Z","iopub.status.idle":"2022-07-10T08:43:28.126908Z","shell.execute_reply.started":"2022-07-10T08:43:27.977950Z","shell.execute_reply":"2022-07-10T08:43:28.125669Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"amt_rand_list = []\nfor i in range(0, 1963031):\n    amt_rand_list.append(random.randint(100, 1000))","metadata":{"execution":{"iopub.status.busy":"2022-07-10T09:20:16.381642Z","iopub.execute_input":"2022-07-10T09:20:16.382119Z","iopub.status.idle":"2022-07-10T09:20:20.207986Z","shell.execute_reply.started":"2022-07-10T09:20:16.382085Z","shell.execute_reply":"2022-07-10T09:20:20.206798Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df['purchase_amount'] = amt_rand_list","metadata":{"execution":{"iopub.status.busy":"2022-07-10T09:31:31.798140Z","iopub.execute_input":"2022-07-10T09:31:31.798564Z","iopub.status.idle":"2022-07-10T09:31:32.592487Z","shell.execute_reply.started":"2022-07-10T09:31:31.798514Z","shell.execute_reply":"2022-07-10T09:31:32.591051Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df.head()","metadata":{"execution":{"iopub.status.busy":"2022-07-10T09:31:34.796766Z","iopub.execute_input":"2022-07-10T09:31:34.797166Z","iopub.status.idle":"2022-07-10T09:31:34.816480Z","shell.execute_reply.started":"2022-07-10T09:31:34.797135Z","shell.execute_reply":"2022-07-10T09:31:34.815674Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df.drop(['authorized_flag', 'category_1', 'installments', 'category_3', 'month_lag', 'category_2'], axis=1, inplace=True)","metadata":{"execution":{"iopub.status.busy":"2022-07-10T09:34:06.638356Z","iopub.execute_input":"2022-07-10T09:34:06.638887Z","iopub.status.idle":"2022-07-10T09:34:06.800863Z","shell.execute_reply.started":"2022-07-10T09:34:06.638847Z","shell.execute_reply":"2022-07-10T09:34:06.799406Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df.head()","metadata":{"execution":{"iopub.status.busy":"2022-07-10T09:35:21.398326Z","iopub.execute_input":"2022-07-10T09:35:21.398850Z","iopub.status.idle":"2022-07-10T09:35:21.414815Z","shell.execute_reply.started":"2022-07-10T09:35:21.398802Z","shell.execute_reply":"2022-07-10T09:35:21.413618Z"},"trusted":true},"execution_count":null,"outputs":[]},{"cell_type":"code","source":"df.to_csv('final_dataset.csv', index = True)","metadata":{"execution":{"iopub.status.busy":"2022-07-10T09:59:52.378429Z","iopub.execute_input":"2022-07-10T09:59:52.378801Z","iopub.status.idle":"2022-07-10T10:00:04.932449Z","shell.execute_reply.started":"2022-07-10T09:59:52.378769Z","shell.execute_reply":"2022-07-10T10:00:04.931098Z"},"trusted":true},"execution_count":null,"outputs":[]}]}