analyze prescriber multi year hdf5.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import h5py\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "f5 = h5py.File(\"prescriber_5year.hdf5\", \"r\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['data', 'key', 'time']"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(f5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1130682, 1)"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f5['/key/values'].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[b'1003000126'],\n",
       "       [b'1003000142'],\n",
       "       [b'1003000167'],\n",
       "       ...,\n",
       "       [b''],\n",
       "       [b''],\n",
       "       [b'']], dtype='|S32')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f5['/key/values'][:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1130682, 1)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "key_array = f5[\"/key/values\"][...]\n",
    "key_array.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(5, 1)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f5['/time/values'].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[b'2013'],\n",
       "       [b'2014'],\n",
       "       [b'2015'],\n",
       "       [b'2016'],\n",
       "       [b'2017']], dtype='|S128')"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f5['/time/values'][:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(5, 1)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "time_array = f5[\"/time/values\"][...]\n",
    "time_array.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1130682, 5, 1167)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f5['/data/core_array'].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[[   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,  385, ...,    0,    0,    0]],\n",
       "\n",
       "       [[   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   1,    0, 1835, ...,    0,    0,    0]],\n",
       "\n",
       "       [[   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   2,    0,   38, ...,    0,    0,    0]],\n",
       "\n",
       "       ...,\n",
       "\n",
       "       [[   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0]],\n",
       "\n",
       "       [[   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0]],\n",
       "\n",
       "       [[   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0]]])"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f5['/data/core_array'][:]\n",
    "#f5['/data/core_array'][:,:,1:1167]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[[   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,  385, ...,    0,    0,    0]],\n",
       "\n",
       "       [[   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   0,    0,    0, ...,    0,    0,    0],\n",
       "        [   1,    0, 1835, ...,    0,    0,    0]]])"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f5['/data/core_array'][0:2]\n",
    "#f5['/data/core_array'][0:2,:,1:1167]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1, 1167)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f5['/data/column_labels'].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[b'is_excluded', b'total_claim_count', b'0 9 % SODIUM CHLORIDE',\n",
       "        b'ABACAVIR SULFATE', b'ABACAVIR SULFATE LAMIVUDINE',\n",
       "        b'ABACAVIR LAMIVUDINE ZIDOVUDINE', b'ABATACEPT',\n",
       "        b'ABATACEPT MALTOSE', b'ABIRATERONE ACETATE',\n",
       "        b'ACAMPROSATE CALCIUM', b'ACARBOSE', b'ACEBUTOLOL HCL',\n",
       "        b'ACETAMINOPHEN WITH CODEINE', b'ACETAZOLAMIDE', b'ACETIC ACID',\n",
       "        b'ACETYLCYSTEINE', b'ACITRETIN', b'ACLIDINIUM BROMIDE',\n",
       "        b'ACYCLOVIR', b'ADALIMUMAB', b'ADAPALENE', b'ADEFOVIR DIPIVOXIL',\n",
       "        b'ALBUTEROL SULFATE', b'ALCAFTADINE',\n",
       "        b'ALCLOMETASONE DIPROPIONATE', b'ALCOHOL ANTISEPTIC PADS',\n",
       "        b'ALENDRONATE SODIUM', b'ALENDRONATE SODIUM VITAMIN D3',\n",
       "        b'ALFUZOSIN HCL', b'ALISKIREN HEMIFUMARATE',\n",
       "        b'ALISKIREN HYDROCHLOROTHIAZIDE', b'ALLOPURINOL',\n",
       "        b'ALOSETRON HCL', b'ALPHA-1-PROTEINASE INHIBITOR', b'ALPRAZOLAM',\n",
       "        b'AMANTADINE HCL', b'AMBRISENTAN', b'AMIKACIN SULFATE',\n",
       "        b'AMILORIDE HCL', b'AMILORIDE HYDROCHLOROTHIAZIDE',\n",
       "        b'AMINOCAPROIC ACID', b'AMIODARONE HCL', b'AMITRIPTYLINE HCL',\n",
       "        b'AMLODIPINE BES OLMESARTAN MED', b'AMLODIPINE BESYLATE',\n",
       "        b'AMLODIPINE BESYLATE BENAZEPRIL', b'AMLODIPINE ATORVASTATIN',\n",
       "        b'AMLODIPINE VALSARTAN HCTHIAZID', b'AMMONIUM LACTATE',\n",
       "        b'AMOXAPINE', b'AMOXICILLIN', b'AMOXICILLIN POTASSIUM CLAV',\n",
       "        b'AMPICILLIN SODIUM', b'AMPICILLIN SODIUM SULBACTAM NA',\n",
       "        b'AMPICILLIN TRIHYDRATE', b'ANAGRELIDE HCL', b'ANASTROZOLE',\n",
       "        b'APIXABAN', b'APOMORPHINE HCL', b'APRACLONIDINE HCL',\n",
       "        b'APREPITANT', b'ARFORMOTEROL TARTRATE', b'ARIPIPRAZOLE',\n",
       "        b'ARMODAFINIL', b'ASENAPINE MALEATE', b'ASPIRIN DIPYRIDAMOLE',\n",
       "        b'ATAZANAVIR SULFATE', b'ATENOLOL', b'ATENOLOL CHLORTHALIDONE',\n",
       "        b'ATOMOXETINE HCL', b'ATORVASTATIN CALCIUM', b'ATOVAQUONE',\n",
       "        b'ATOVAQUONE PROGUANIL HCL', b'ATROPINE SULFATE', b'AURANOFIN',\n",
       "        b'AXITINIB', b'AZACITIDINE', b'AZATHIOPRINE', b'AZELAIC ACID',\n",
       "        b'AZELASTINE HCL', b'AZELASTINE FLUTICASONE',\n",
       "        b'AZILSARTAN MED CHLORTHALIDONE', b'AZILSARTAN MEDOXOMIL',\n",
       "        b'AZITHROMYCIN', b'AZTREONAM', b'BACITRACIN',\n",
       "        b'BACITRACIN POLYMYXIN B SULFATE', b'BACLOFEN',\n",
       "        b'BALSALAZIDE DISODIUM', b'BECLOMETHASONE DIPROPIONATE',\n",
       "        b'BELIMUMAB', b'BENAZEPRIL HCL',\n",
       "        b'BENAZEPRIL HYDROCHLOROTHIAZIDE', b'BENZONATATE',\n",
       "        b'BENZTROPINE MESYLATE', b'BEPOTASTINE BESILATE',\n",
       "        b'BESIFLOXACIN HCL', b'BETAMETHASONE DIPROPIONATE',\n",
       "        b'BETAMETHASONE VALERATE', b'BETAMETHASONE PROPYLENE GLYC',\n",
       "        b'BETAXOLOL HCL', b'BETHANECHOL CHLORIDE', b'BEVACIZUMAB',\n",
       "        b'BEXAROTENE', b'BICALUTAMIDE', b'BIMATOPROST',\n",
       "        b'BISOPROLOL FUMARATE', b'BORTEZOMIB', b'BOSENTAN',\n",
       "        b'BRIMONIDINE TARTRATE', b'BRIMONIDINE TARTRATE TIMOLOL',\n",
       "        b'BRINZOLAMIDE', b'BROMFENAC SODIUM', b'BROMOCRIPTINE MESYLATE',\n",
       "        b'BUDESONIDE', b'BUDESONIDE FORMOTEROL FUMARATE', b'BUMETANIDE',\n",
       "        b'BUPIVACAINE HCL PF', b'BUPRENORPHINE', b'BUPRENORPHINE HCL',\n",
       "        b'BUPRENORPHINE HCL NALOXONE HCL', b'BUPROPION HBR',\n",
       "        b'BUPROPION HCL', b'BUSPIRONE HCL',\n",
       "        b'BUTALB ACETAMINOPHEN CAFFEINE',\n",
       "        b'BUTALBIT ACETAMIN CAFF CODEINE',\n",
       "        b'BUTALBITAL ASPIRIN CAFFEINE', b'BUTENAFINE HCL',\n",
       "        b'BUTORPHANOL TARTRATE', b'C1 ESTERASE INHIBITOR',\n",
       "        b'CABERGOLINE', b'CALCIPOTRIENE', b'CALCIPOTRIENE BETAMETHASONE',\n",
       "        b'CALCITRIOL', b'CALCIUM ACETATE', b'CANAGLIFLOZIN',\n",
       "        b'CANDESARTAN CILEXETIL', b'CANDESARTAN HYDROCHLOROTHIAZID',\n",
       "        b'CAPTOPRIL', b'CAPTOPRIL HYDROCHLOROTHIAZIDE', b'CARBAMAZEPINE',\n",
       "        b'CARBIDOPA', b'CARBIDOPA LEVODOPA',\n",
       "        b'CARBIDOPA LEVODOPA ENTACAPONE', b'CARBINOXAMINE MALEATE',\n",
       "        b'CARBOPLATIN', b'CARISOPRODOL', b'CARTEOLOL HCL', b'CARVEDILOL',\n",
       "        b'CARVEDILOL PHOSPHATE', b'CEFAZOLIN SODIUM', b'CEFDINIR',\n",
       "        b'CEFEPIME HCL', b'CEFIXIME', b'CEFPODOXIME PROXETIL',\n",
       "        b'CEFPROZIL', b'CEFTAROLINE FOSAMIL ACETATE',\n",
       "        b'CEFTRIAXONE SODIUM', b'CEFUROXIME AXETIL', b'CELECOXIB',\n",
       "        b'CEPHALEXIN', b'CERTOLIZUMAB PEGOL', b'CETIRIZINE HCL',\n",
       "        b'CEVIMELINE HCL', b'CHENODIOL', b'CHLORAMBUCIL',\n",
       "        b'CHLORDIAZEPOXIDE HCL', b'CHLORHEXIDINE GLUCONATE',\n",
       "        b'CHLOROQUINE PHOSPHATE', b'CHLOROTHIAZIDE',\n",
       "        b'CHLORPROMAZINE HCL', b'CHLORTHALIDONE', b'CHLORZOXAZONE',\n",
       "        b'CHOLESTYRAMINE (WITH SUGAR)', b'CHOLESTYRAMINE ASPARTAME',\n",
       "        b'CICLESONIDE', b'CICLOPIROX', b'CICLOPIROX OLAMINE',\n",
       "        b'CILOSTAZOL', b'CIMETIDINE', b'CINACALCET HCL',\n",
       "        b'CIPROFLOXACIN HCL', b'CIPROFLOXACIN HCL DEXAMETH',\n",
       "        b'CIPROFLOXACIN CIPROFLOXA HCL', b'CISPLATIN',\n",
       "        b'CITALOPRAM HYDROBROMIDE', b'CITRIC ACID SODIUM CITRATE',\n",
       "        b'CLARITHROMYCIN', b'CLEMASTINE FUMARATE', b'CLINDAMYCIN HCL',\n",
       "        b'CLINDAMYCIN PHOS BENZOYL PEROX', b'CLINDAMYCIN PHOSPHATE',\n",
       "        b'CLOBAZAM', b'CLOBETASOL PROPIONATE',\n",
       "        b'CLOBETASOL PROPIONATE EMOLL', b'CLOCORTOLONE PIVALATE',\n",
       "        b'CLOMIPRAMINE HCL', b'CLONAZEPAM', b'CLONIDINE',\n",
       "        b'CLONIDINE HCL', b'CLOPIDOGREL BISULFATE',\n",
       "        b'CLORAZEPATE DIPOTASSIUM', b'CLOTRIMAZOLE',\n",
       "        b'CLOTRIMAZOLE BETAMETHASONE DIP', b'CLOZAPINE',\n",
       "        b'CODEINE SULFATE', b'CODEINE BUTALBITAL ASA CAFFEIN',\n",
       "        b'COLCHICINE', b'COLESEVELAM HCL', b'COLESTIPOL HCL',\n",
       "        b'COLISTIN (COLISTIMETHATE NA)',\n",
       "        b'COLLAGENASE CLOSTRIDIUM HIST ', b'CORTICOTROPIN',\n",
       "        b'CRIZOTINIB', b'CROMOLYN SODIUM', b'CROTAMITON',\n",
       "        b'CYCLOBENZAPRINE HCL', b'CYCLOPENTOLATE HCL',\n",
       "        b'CYCLOPHOSPHAMIDE', b'CYCLOSPORINE', b'CYPROHEPTADINE HCL',\n",
       "        b'DABIGATRAN ETEXILATE MESYLATE', b'DALFAMPRIDINE', b'DANAZOL',\n",
       "        b'DANTROLENE SODIUM', b'DAPSONE', b'DAPTOMYCIN',\n",
       "        b'DARBEPOETIN ALFA IN POLYSORBAT', b'DARIFENACIN HYDROBROMIDE',\n",
       "        b'DARUNAVIR ETHANOLATE', b'DASATINIB', b'DEFERASIROX',\n",
       "        b'DEGARELIX ACETATE', b'DEMECLOCYCLINE HCL', b'DENOSUMAB',\n",
       "        b'DESIPRAMINE HCL', b'DESLORATADINE',\n",
       "        b'DESLORATADINE PSEUDOEPHEDRINE',\n",
       "        b'DESMOPRESSIN (NONREFRIGERATED)', b'DESMOPRESSIN ACETATE',\n",
       "        b'DESOG-E ESTRADIOL E ESTRADIOL',\n",
       "        b'DESOGESTREL-ETHINYL ESTRADIOL', b'DESONIDE', b'DESOXIMETASONE',\n",
       "        b'DESVENLAFAXINE', b'DESVENLAFAXINE SUCCINATE', b'DEXAMETHASONE',\n",
       "        b'DEXAMETHASONE SOD PHOSPHATE', b'DEXLANSOPRAZOLE',\n",
       "        b'DEXMETHYLPHENIDATE HCL', b'DEXTROAMPHETAMINE SULFATE',\n",
       "        b'DEXTROAMPHETAMINE AMPHETAMINE',\n",
       "        b'DEXTROMETHORPHAN HBR QUINIDINE',\n",
       "        b'DEXTROSE 5 % AND 0 9 % NACL', b'DEXTROSE 5 % IN WATER',\n",
       "        b'DEXTROSE 70 % IN WATER', b'DIAZEPAM', b'DICLOFENAC EPOLAMINE',\n",
       "        b'DICLOFENAC POTASSIUM', b'DICLOFENAC SODIUM',\n",
       "        b'DICLOFENAC SODIUM MISOPROSTOL', b'DICLOXACILLIN SODIUM',\n",
       "        b'DICYCLOMINE HCL', b'DIDANOSINE', b'DIFLORASONE DIACETATE',\n",
       "        b'DIFLORASONE DIACETATE EMOLL', b'DIFLUNISAL', b'DIFLUPREDNATE',\n",
       "        b'DIGOXIN', b'DILTIAZEM HCL', b'DIMETHYL FUMARATE',\n",
       "        b'DIPHENHYDRAMINE HCL', b'DIPHENOXYLATE HCL ATROPINE',\n",
       "        b'DIPYRIDAMOLE', b'DISOPYRAMIDE PHOSPHATE', b'DISULFIRAM',\n",
       "        b'DIVALPROEX SODIUM', b'DOCETAXEL', b'DOFETILIDE',\n",
       "        b'DOLUTEGRAVIR SODIUM', b'DONEPEZIL HCL', b'DORZOLAMIDE HCL',\n",
       "        b'DORZOLAMIDE HCL TIMOLOL MALEAT', b'DORZOLAMIDE TIMOLOL PF',\n",
       "        b'DOXAZOSIN MESYLATE', b'DOXEPIN HCL', b'DOXERCALCIFEROL',\n",
       "        b'DOXYCYCLINE HYCLATE', b'DOXYCYCLINE MONOHYDRATE',\n",
       "        b'DRONABINOL', b'DRONEDARONE HCL', b'DULOXETINE HCL',\n",
       "        b'DUTASTERIDE', b'DUTASTERIDE TAMSULOSIN HCL',\n",
       "        b'ECHOTHIOPHATE IODIDE', b'ECONAZOLE NITRATE', b'EFAVIRENZ',\n",
       "        b'ELETRIPTAN HBR', b'ELTROMBOPAG OLAMINE', b'EMTRICITABINE',\n",
       "        b'ENALAPRIL MALEATE', b'ENALAPRIL HYDROCHLOROTHIAZIDE',\n",
       "        b'ENFUVIRTIDE', b'ENOXAPARIN SODIUM', b'ENTACAPONE',\n",
       "        b'ENTECAVIR', b'ENZALUTAMIDE', b'EPINASTINE HCL', b'EPINEPHRINE',\n",
       "        b'EPLERENONE', b'EPOETIN ALFA', b'ERGOCALCIFEROL (VITAMIN D2)',\n",
       "        b'ERGOLOID MESYLATES', b'ERLOTINIB HCL', b'ERTAPENEM SODIUM',\n",
       "        b'ERYTHROMYCIN BASE', b'ERYTHROMYCIN BASE ETHANOL',\n",
       "        b'ERYTHROMYCIN ETHYLSUCCINATE', b'ERYTHROMYCIN STEARATE',\n",
       "        b'ERYTHROMYCIN BENZOYL PEROXIDE', b'ESCITALOPRAM OXALATE',\n",
       "        b'ESOMEPRAZOLE MAGNESIUM', b'ESTAZOLAM', b'ESTRADIOL',\n",
       "        b'ESTRADIOL NORETHINDRONE ACET', b'ESZOPICLONE', b'ETANERCEPT',\n",
       "        b'ETHACRYNIC ACID', b'ETHAMBUTOL HCL',\n",
       "        b'ETHINYL ESTRADIOL DROSPIRENONE', b'ETHOSUXIMIDE',\n",
       "        b'ETHYNODIOL D-ETHINYL ESTRADIOL', b'ETODOLAC',\n",
       "        b'ETONOGESTREL ETHINYL ESTRADIOL', b'ETRAVIRINE', b'EVEROLIMUS',\n",
       "        b'EXEMESTANE', b'EXENATIDE', b'EXENATIDE MICROSPHERES',\n",
       "        b'EZETIMIBE', b'EZETIMIBE SIMVASTATIN', b'FAMCICLOVIR',\n",
       "        b'FAMOTIDINE', b'FAT EMULSIONS', b'FEBUXOSTAT', b'FELBAMATE',\n",
       "        b'FELODIPINE', b'FENOFIBRATE', b'FENOFIBRATE NANOCRYSTALLIZED',\n",
       "        b'FENOFIBRIC ACID', b'FENOFIBRIC ACID (CHOLINE)', b'FENTANYL',\n",
       "        b'FENTANYL CITRATE', b'FESOTERODINE FUMARATE', b'FILGRASTIM',\n",
       "        b'FINASTERIDE', b'FINGOLIMOD HCL', b'FLAVOXATE HCL',\n",
       "        b'FLECAINIDE ACETATE', b'FLUCONAZOLE',\n",
       "        b'FLUDROCORTISONE ACETATE', b'FLUNISOLIDE',\n",
       "        b'FLUOCINOLONE ACETONIDE', b'FLUOCINOLONE ACETONIDE OIL',\n",
       "        b'FLUOCINOLONE SHOWER CAP', b'FLUOCINONIDE',\n",
       "        b'FLUOCINONIDE EMOLLIENT BASE', b'FLUOROMETHOLONE',\n",
       "        b'FLUOROURACIL', b'FLUOXETINE HCL', b'FLUPHENAZINE DECANOATE',\n",
       "        b'FLUPHENAZINE HCL', b'FLURAZEPAM HCL', b'FLURBIPROFEN',\n",
       "        b'FLURBIPROFEN SODIUM', b'FLUTAMIDE', b'FLUTICASONE FUROATE',\n",
       "        b'FLUTICASONE PROPIONATE', b'FLUTICASONE SALMETEROL',\n",
       "        b'FLUVASTATIN SODIUM', b'FLUVOXAMINE MALEATE', b'FOLIC ACID',\n",
       "        b'FONDAPARINUX SODIUM', b'FORMOTEROL FUMARATE',\n",
       "        b'FOSAMPRENAVIR CALCIUM', b'FOSAPREPITANT DIMEGLUMINE',\n",
       "        b'FOSFOMYCIN TROMETHAMINE', b'FOSINOPRIL SODIUM',\n",
       "        b'FOSINOPRIL HYDROCHLOROTHIAZIDE', b'FROVATRIPTAN SUCCINATE',\n",
       "        b'FULVESTRANT', b'FUROSEMIDE', b'GABAPENTIN',\n",
       "        b'GABAPENTIN ENACARBIL', b'GALANTAMINE HBR', b'GANCICLOVIR',\n",
       "        b'GATIFLOXACIN', b'GEMCITABINE HCL', b'GEMFIBROZIL',\n",
       "        b'GENTAMICIN SULFATE', b'GLATIRAMER ACETATE', b'GLIMEPIRIDE',\n",
       "        b'GLIPIZIDE', b'GLIPIZIDE METFORMIN HCL', b'GLYBURIDE',\n",
       "        b'GLYBURIDE METFORMIN HCL', b'GLYCEROL PHENYLBUTYRATE',\n",
       "        b'GLYCOPYRROLATE', b'GOLIMUMAB', b'GOSERELIN ACETATE',\n",
       "        b'GRANISETRON', b'GRANISETRON HCL',\n",
       "        b'GRISEOFULVIN ULTRAMICROSIZE', b'GUANFACINE HCL',\n",
       "        b'HALCINONIDE', b'HALOBETASOL PROPIONATE', b'HALOPERIDOL',\n",
       "        b'HALOPERIDOL DECANOATE', b'HALOPERIDOL LACTATE',\n",
       "        b'HEPATITIS A VIRUS VACCINE PF', b'HYDRALAZINE HCL',\n",
       "        b'HYDROCHLOROTHIAZIDE', b'HYDROCODONE BIT HOMATROP ME-BR',\n",
       "        b'HYDROCODONE ACETAMINOPHEN', b'HYDROCODONE IBUPROFEN',\n",
       "        b'HYDROCORTISONE', b'HYDROCORTISONE ACETATE',\n",
       "        b'HYDROCORTISONE BUTYRATE', b'HYDROCORTISONE VALERATE',\n",
       "        b'HYDROCORTISONE PRAMOXINE', b'HYDROMORPHONE HCL',\n",
       "        b'HYDROMORPHONE HCL PF', b'HYDROXYCHLOROQUINE SULFATE',\n",
       "        b'HYDROXYPROPYL CELLULOSE', b'HYDROXYUREA', b'HYDROXYZINE HCL',\n",
       "        b'HYDROXYZINE PAMOATE', b'HYOSCYAMINE SULFATE',\n",
       "        b'IBANDRONATE SODIUM', b'IBUPROFEN', b'IBUPROFEN FAMOTIDINE',\n",
       "        b'ICATIBANT ACETATE', b'ICOSAPENT ETHYL', b'ILOPERIDONE',\n",
       "        b'IMATINIB MESYLATE', b'IMIPENEM CILASTATIN SODIUM',\n",
       "        b'IMIPRAMINE HCL', b'IMIPRAMINE PAMOATE', b'IMIQUIMOD',\n",
       "        b'INDACATEROL MALEATE', b'INDAPAMIDE', b'INDOMETHACIN',\n",
       "        b'INFLIXIMAB', b'INGENOL MEBUTATE', b'INSULIN ASPART',\n",
       "        b'INSULIN DETEMIR', b'INSULIN GLULISINE', b'INSULIN LISPRO',\n",
       "        b'INTERFERON BETA-1A', b'INTERFERON BETA-1A ALBUMIN',\n",
       "        b'INTERFERON BETA-1B', b'IPRATROPIUM BROMIDE',\n",
       "        b'IPRATROPIUM ALBUTEROL SULFATE', b'IRBESARTAN',\n",
       "        b'IRBESARTAN HYDROCHLOROTHIAZIDE', b'IRINOTECAN HCL',\n",
       "        b'ISOCARBOXAZID', b'ISONIAZID', b'ISOSORBIDE DINITRATE',\n",
       "        b'ISOSORBIDE MONONITRATE', b'ISRADIPINE', b'ITRACONAZOLE',\n",
       "        b'IVERMECTIN', b'KETOCONAZOLE', b'KETOPROFEN',\n",
       "        b'KETOROLAC TROMETHAMINE', b'LABETALOL HCL', b'LACOSAMIDE',\n",
       "        b'LACTULOSE', b'LAMIVUDINE', b'LAMIVUDINE ZIDOVUDINE',\n",
       "        b'LAMOTRIGINE', b'LANREOTIDE ACETATE', b'LANSOPRAZOLE',\n",
       "        b'LANTHANUM CARBONATE', b'LAPATINIB DITOSYLATE', b'LATANOPROST',\n",
       "        b'LEFLUNOMIDE', b'LENALIDOMIDE', b'LETROZOLE',\n",
       "        b'LEUCOVORIN CALCIUM', b'LEUPROLIDE ACETATE',\n",
       "        b'LEVALBUTEROL HCL', b'LEVALBUTEROL TARTRATE', b'LEVETIRACETAM',\n",
       "        b'LEVOBUNOLOL HCL', b'LEVOCARNITINE',\n",
       "        b'LEVOCARNITINE (WITH SUGAR)', b'LEVOCETIRIZINE DIHYDROCHLORIDE',\n",
       "        b'LEVOFLOXACIN', b'LEVOTHYROXINE SODIUM', b'LIDOCAINE',\n",
       "        b'LIDOCAINE HCL', b'LIDOCAINE HCL PF', b'LIDOCAINE PRILOCAINE',\n",
       "        b'LINACLOTIDE', b'LINAGLIPTIN', b'LINAGLIPTIN METFORMIN HCL',\n",
       "        b'LINEZOLID', b'LIOTHYRONINE SODIUM', b'LIPASE PROTEASE AMYLASE',\n",
       "        b'LIRAGLUTIDE', b'LISDEXAMFETAMINE DIMESYLATE', b'LISINOPRIL',\n",
       "        b'LISINOPRIL HYDROCHLOROTHIAZIDE', b'LITHIUM CARBONATE',\n",
       "        b'LITHIUM CITRATE', b'LOPERAMIDE HCL', b'LOPINAVIR RITONAVIR',\n",
       "        b'LORAZEPAM', b'LOSARTAN POTASSIUM',\n",
       "        b'LOSARTAN HYDROCHLOROTHIAZIDE', b'LOTEPREDNOL ETABONATE',\n",
       "        b'LOVASTATIN', b'LOXAPINE SUCCINATE', b'LUBIPROSTONE',\n",
       "        b'LURASIDONE HCL', b'MAGNESIUM SULFATE', b'MAPROTILINE HCL',\n",
       "        b'MARAVIROC', b'MECLIZINE HCL', b'MEDROXYPROGESTERONE ACETATE',\n",
       "        b'MEFLOQUINE HCL', b'MEGESTROL ACETATE', b'MELOXICAM',\n",
       "        b'MEMANTINE HCL', b'MEPERIDINE HCL', b'MEPERIDINE HCL PF',\n",
       "        b'MEPROBAMATE', b'MERCAPTOPURINE', b'MEROPENEM', b'MESALAMINE',\n",
       "        b'METAXALONE', b'METFORMIN HCL', b'METHADONE HCL',\n",
       "        b'METHAMPHETAMINE HCL', b'METHAZOLAMIDE',\n",
       "        b'METHENAMINE HIPPURATE', b'METHENAMINE MANDELATE',\n",
       "        b'METHIMAZOLE', b'METHOCARBAMOL', b'METHOTREXATE SODIUM',\n",
       "        b'METHOTREXATE SODIUM PF', b'METHSCOPOLAMINE BROMIDE',\n",
       "        b'METHSUXIMIDE', b'METHYCLOTHIAZIDE', b'METHYLDOPA',\n",
       "        b'METHYLNALTREXONE BROMIDE', b'METHYLPHENIDATE HCL',\n",
       "        b'METHYLPREDNISOLONE', b'METHYLPREDNISOLONE ACETATE',\n",
       "        b'METHYLPREDNISOLONE SOD SUCC',\n",
       "        b'METHYLPREDNISOLONE SOD SUCC PF', b'METOCLOPRAMIDE HCL',\n",
       "        b'METOLAZONE', b'METOPROLOL SUCCINATE', b'METOPROLOL TARTRATE',\n",
       "        b'METOPROLOL HYDROCHLOROTHIAZIDE', b'METRONIDAZOLE',\n",
       "        b'METRONIDAZOLE SODIUM CHLORIDE', b'MEXILETINE HCL',\n",
       "        b'MIDODRINE HCL', b'MIGLITOL', b'MILNACIPRAN HCL',\n",
       "        b'MILRINONE LACTATE', b'MINOCYCLINE HCL', b'MINOXIDIL',\n",
       "        b'MIRABEGRON', b'MIRTAZAPINE', b'MISOPROSTOL', b'MODAFINIL',\n",
       "        b'MOEXIPRIL HCL', b'MOEXIPRIL HYDROCHLOROTHIAZIDE',\n",
       "        b'MOMETASONE FUROATE', b'MOMETASONE FORMOTEROL',\n",
       "        b'MONTELUKAST SODIUM', b'MORPHINE SULFATE', b'MOXIFLOXACIN HCL',\n",
       "        b'MUPIROCIN', b'MUPIROCIN CALCIUM', b'MYCOPHENOLATE MOFETIL',\n",
       "        b'MYCOPHENOLATE SODIUM', b'NABUMETONE', b'NADOLOL',\n",
       "        b'NAFCILLIN SODIUM', b'NAFTIFINE HCL', b'NALTREXONE HCL',\n",
       "        b'NALTREXONE MICROSPHERES', b'NAPROXEN', b'NAPROXEN SODIUM',\n",
       "        b'NAPROXEN ESOMEPRAZOLE MAG', b'NARATRIPTAN HCL', b'NATALIZUMAB',\n",
       "        b'NATEGLINIDE', b'NEBIVOLOL HCL', b'NEFAZODONE HCL',\n",
       "        b'NELFINAVIR MESYLATE', b'NEOMYCIN SULFATE', b'NEPAFENAC',\n",
       "        b'NEVIRAPINE', b'NIACIN', b'NICARDIPINE HCL', b'NICOTINE',\n",
       "        b'NIFEDIPINE', b'NILOTINIB HCL', b'NILUTAMIDE', b'NISOLDIPINE',\n",
       "        b'NITROFURANTOIN', b'NITROFURANTOIN MACROCRYSTAL',\n",
       "        b'NITROFURANTOIN MONOHYD M-CRYST', b'NITROGLYCERIN',\n",
       "        b'NIZATIDINE', b'NORELGESTROMIN ETHIN ESTRADIOL',\n",
       "        b'NORETH-ETHINYL ESTRADIOL IRON', b'NORETHINDRONE',\n",
       "        b'NORETHINDRONE ACETATE', b'NORETHINDRONE-ETHINYL ESTRAD',\n",
       "        b'NORGESTIMATE-ETHINYL ESTRADIOL',\n",
       "        b'NORGESTREL-ETHINYL ESTRADIOL', b'NORTRIPTYLINE HCL',\n",
       "        b'NYSTATIN', b'NYSTATIN TRIAMCIN', b'OCTREOTIDE ACETATE',\n",
       "        b'OFLOXACIN', b'OLANZAPINE', b'OLANZAPINE PAMOATE',\n",
       "        b'OLANZAPINE FLUOXETINE HCL', b'OLMESARTAN MEDOXOMIL',\n",
       "        b'OLMESARTAN AMLODIPIN HCTHIAZID',\n",
       "        b'OLMESARTAN HYDROCHLOROTHIAZIDE', b'OLOPATADINE HCL',\n",
       "        b'OLSALAZINE SODIUM', b'OMALIZUMAB',\n",
       "        b'OMEGA-3 ACID ETHYL ESTERS', b'OMEPRAZOLE',\n",
       "        b'OMEPRAZOLE MAGNESIUM', b'OMEPRAZOLE SODIUM BICARBONATE',\n",
       "        b'ONABOTULINUMTOXINA', b'ONDANSETRON', b'ONDANSETRON HCL',\n",
       "        b'ONDANSETRON HCL PF', b'OPIUM TINCTURE',\n",
       "        b'ORPHENADRINE CITRATE', b'OSELTAMIVIR PHOSPHATE',\n",
       "        b'OXALIPLATIN', b'OXANDROLONE', b'OXAPROZIN', b'OXAZEPAM',\n",
       "        b'OXCARBAZEPINE', b'OXICONAZOLE NITRATE', b'OXYBUTYNIN',\n",
       "        b'OXYBUTYNIN CHLORIDE', b'OXYCODONE HCL',\n",
       "        b'OXYCODONE HCL ACETAMINOPHEN', b'OXYCODONE HCL ASPIRIN',\n",
       "        b'OXYMORPHONE HCL', b'PACLITAXEL', b'PACLITAXEL PROTEIN-BOUND',\n",
       "        b'PALIPERIDONE', b'PALIPERIDONE PALMITATE', b'PALONOSETRON HCL',\n",
       "        b'PANTOPRAZOLE SODIUM', b'PARENTERAL AMINO ACID 15% NO 1',\n",
       "        b'PARENTERAL AMINO ACID 20% NO 1', b'PARICALCITOL',\n",
       "        b'PAROXETINE HCL', b'PAROXETINE MESYLATE', b'PAZOPANIB HCL',\n",
       "        b'PEG3350 SOD SUL NACL ASB C KCL', b'PEGFILGRASTIM',\n",
       "        b'PEGINTERFERON ALFA-2A', b'PEMETREXED DISODIUM', b'PENCICLOVIR',\n",
       "        b'PENICILLIN V POTASSIUM', b'PENTAZOCINE HCL NALOXONE HCL',\n",
       "        b'PENTOSAN POLYSULFATE SODIUM', b'PENTOXIFYLLINE',\n",
       "        b'PERINDOPRIL ERBUMINE', b'PERMETHRIN', b'PERPHENAZINE',\n",
       "        b'PERPHENAZINE AMITRIPTYLINE HCL', b'PHENAZOPYRIDINE HCL',\n",
       "        b'PHENELZINE SULFATE', b'PHENOBARBITAL',\n",
       "        b'PHENYLEPHRINE HCL PROMETH HCL', b'PHENYTOIN',\n",
       "        b'PHENYTOIN SODIUM EXTENDED', b'PILOCARPINE HCL',\n",
       "        b'PIMECROLIMUS', b'PIMOZIDE', b'PINDOLOL', b'PIOGLITAZONE HCL',\n",
       "        b'PIOGLITAZONE HCL GLIMEPIRIDE',\n",
       "        b'PIOGLITAZONE HCL METFORMIN HCL',\n",
       "        b'PIPERACILLIN SODIUM TAZOBACTAM', b'PIROXICAM',\n",
       "        b'PITAVASTATIN CALCIUM', b'PODOFILOX',\n",
       "        b'POLYETHYLENE GLYCOL 3350', b'POLYMYXIN B SULF TRIMETHOPRIM',\n",
       "        b'POMALIDOMIDE', b'POSACONAZOLE',\n",
       "        b'POTASSIUM BICARBONATE CIT AC', b'POTASSIUM CHLORIDE',\n",
       "        b'POTASSIUM CITRATE', b'PRAMIPEXOLE DI-HCL',\n",
       "        b'PRAMLINTIDE ACETATE', b'PRASUGREL HCL', b'PRAVASTATIN SODIUM',\n",
       "        b'PRAZOSIN HCL', b'PREDNICARBATE', b'PREDNISOLONE',\n",
       "        b'PREDNISOLONE ACETATE', b'PREDNISOLONE SOD PHOSPHATE',\n",
       "        b'PREDNISONE', b'PREGABALIN', b'PRIMIDONE', b'PROBENECID',\n",
       "        b'PROCHLORPERAZINE MALEATE', b'PROMETHAZINE HCL',\n",
       "        b'PROPAFENONE HCL', b'PROPANTHELINE BROMIDE', b'PROPRANOLOL HCL',\n",
       "        b'PROPRANOLOL HYDROCHLOROTHIAZID', b'PROPYLTHIOURACIL',\n",
       "        b'PROTRIPTYLINE HCL', b'PSEUDOEPHEDRINE HCL ACRIVAS',\n",
       "        b'PYRIDOSTIGMINE BROMIDE', b'QUETIAPINE FUMARATE',\n",
       "        b'QUINAPRIL HCL', b'QUINAPRIL HYDROCHLOROTHIAZIDE',\n",
       "        b'QUINIDINE GLUCONATE', b'QUININE SULFATE',\n",
       "        b'RABEPRAZOLE SODIUM', b'RALOXIFENE HCL',\n",
       "        b'RALTEGRAVIR POTASSIUM', b'RAMELTEON', b'RAMIPRIL',\n",
       "        b'RANITIDINE HCL', b'RANOLAZINE', b'RASAGILINE MESYLATE',\n",
       "        b'REGORAFENIB', b'REPAGLINIDE', b'RIBAVIRIN', b'RIFABUTIN',\n",
       "        b'RIFAMPIN', b'RIFAXIMIN', b'RILPIVIRINE HCL', b'RILUZOLE',\n",
       "        b'RISEDRONATE SODIUM', b'RISPERIDONE',\n",
       "        b'RISPERIDONE MICROSPHERES', b'RITONAVIR', b'RITUXIMAB',\n",
       "        b'RIVAROXABAN', b'RIVASTIGMINE', b'RIVASTIGMINE TARTRATE',\n",
       "        b'RIZATRIPTAN BENZOATE', b'ROFLUMILAST', b'ROPINIROLE HCL',\n",
       "        b'ROSUVASTATIN CALCIUM', b'ROTIGOTINE', b'RUFINAMIDE',\n",
       "        b'RUXOLITINIB PHOSPHATE', b'SALMETEROL XINAFOATE', b'SALSALATE',\n",
       "        b'SAPROPTERIN DIHYDROCHLORIDE', b'SAQUINAVIR MESYLATE',\n",
       "        b'SAXAGLIPTIN HCL', b'SAXAGLIPTIN HCL METFORMIN HCL',\n",
       "        b'SCOPOLAMINE', b'SELEGILINE', b'SELEGILINE HCL',\n",
       "        b'SELENIUM SULFIDE', b'SERTRALINE HCL', b'SEVELAMER CARBONATE',\n",
       "        b'SEVELAMER HCL', b'SILDENAFIL CITRATE', b'SILODOSIN',\n",
       "        b'SILVER SULFADIAZINE', b'SIMVASTATIN', b'SIROLIMUS',\n",
       "        b'SITAGLIPTIN PHOS METFORMIN HCL', b'SITAGLIPTIN PHOSPHATE',\n",
       "        b'SOD PICOSULF MAG OX CITRIC AC', b'SODIUM BICARBONATE',\n",
       "        b'SODIUM CHLORIDE 0 45 %', b'SODIUM CHLORIDE IRRIG SOLUTION',\n",
       "        b'SODIUM CHLORIDE NAHCO3 KCL PEG', b'SODIUM OXYBATE',\n",
       "        b'SODIUM POLYSTYRENE SULFONATE', b'SOLIFENACIN SUCCINATE',\n",
       "        b'SOMATROPIN', b'SORAFENIB TOSYLATE', b'SOTALOL HCL',\n",
       "        b'SPIRONOLACT HYDROCHLOROTHIAZID', b'SPIRONOLACTONE',\n",
       "        b'STAVUDINE', b'SUCRALFATE', b'SULFACETAMIDE SODIUM',\n",
       "        b'SULFACETAMIDE PREDNISOLONE SP', b'SULFADIAZINE',\n",
       "        b'SULFAMETHOXAZOLE TRIMETHOPRIM', b'SULFASALAZINE', b'SULINDAC',\n",
       "        b'SUMATRIPTAN', b'SUMATRIPTAN SUCC NAPROXEN SOD',\n",
       "        b'SUMATRIPTAN SUCCINATE', b'SUNITINIB MALATE', b'TACROLIMUS',\n",
       "        b'TADALAFIL', b'TAFLUPROST PF', b'TAMOXIFEN CITRATE',\n",
       "        b'TAMSULOSIN HCL', b'TAPENTADOL HCL', b'TAZAROTENE',\n",
       "        b'TELMISARTAN', b'TELMISARTAN AMLODIPINE',\n",
       "        b'TELMISARTAN HYDROCHLOROTHIAZID', b'TEMAZEPAM',\n",
       "        b'TENOFOVIR DISOPROXIL FUMARATE', b'TERAZOSIN HCL',\n",
       "        b'TERBINAFINE HCL', b'TERBUTALINE SULFATE', b'TERCONAZOLE',\n",
       "        b'TERIFLUNOMIDE', b'TERIPARATIDE', b'TESTOSTERONE',\n",
       "        b'TESTOSTERONE CYPIONATE', b'TETRABENAZINE', b'THALIDOMIDE',\n",
       "        b'THEOPHYLLINE ANHYDROUS', b'THIORIDAZINE HCL', b'THIOTHIXENE',\n",
       "        b'TIAGABINE HCL', b'TICAGRELOR', b'TIGECYCLINE', b'TIMOLOL',\n",
       "        b'TIMOLOL MALEATE', b'TIMOLOL MALEATE PF', b'TINIDAZOLE',\n",
       "        b'TIOTROPIUM BROMIDE', b'TIPRANAVIR', b'TIZANIDINE HCL',\n",
       "        b'TOBRAMYCIN', b'TOBRAMYCIN SULFATE',\n",
       "        b'TOBRAMYCIN DEXAMETHASONE', b'TOBRAMYCIN LOTEPRED ETAB',\n",
       "        b'TOCILIZUMAB', b'TOFACITINIB CITRATE', b'TOLTERODINE TARTRATE',\n",
       "        b'TOLVAPTAN', b'TOPIRAMATE', b'TOREMIFENE CITRATE', b'TORSEMIDE',\n",
       "        b'TRAMADOL HCL', b'TRAMADOL HCL ACETAMINOPHEN', b'TRANDOLAPRIL',\n",
       "        b'TRANDOLAPRIL VERAPAMIL HCL', b'TRANYLCYPROMINE SULFATE',\n",
       "        b'TRASTUZUMAB', b'TRAVOPROST', b'TRAZODONE HCL', b'TRETINOIN',\n",
       "        b'TRIAMCINOLONE ACETONIDE', b'TRIAMTERENE',\n",
       "        b'TRIAMTERENE HYDROCHLOROTHIAZID', b'TRIAZOLAM',\n",
       "        b'TRIFLUOPERAZINE HCL', b'TRIFLURIDINE', b'TRIHEXYPHENIDYL HCL',\n",
       "        b'TRIMETHOBENZAMIDE HCL', b'TRIMETHOPRIM',\n",
       "        b'TRIMIPRAMINE MALEATE', b'TRIPTORELIN PAMOATE', b'TROPICAMIDE',\n",
       "        b'TROSPIUM CHLORIDE', b'URSODIOL', b'USTEKINUMAB',\n",
       "        b'VALACYCLOVIR HCL', b'VALGANCICLOVIR HCL', b'VALPROIC ACID',\n",
       "        b'VALPROIC ACID (AS SODIUM SALT)', b'VALSARTAN',\n",
       "        b'VALSARTAN HYDROCHLOROTHIAZIDE', b'VANCOMYCIN HCL',\n",
       "        b'VARENICLINE TARTRATE', b'VENLAFAXINE HCL', b'VERAPAMIL HCL',\n",
       "        b'VISMODEGIB', b'VORICONAZOLE', b'WARFARIN SODIUM',\n",
       "        b'ZAFIRLUKAST', b'ZALEPLON', b'ZIDOVUDINE', b'ZILEUTON',\n",
       "        b'ZIPRASIDONE HCL', b'ZOLEDRONIC ACID', b'ZOLMITRIPTAN',\n",
       "        b'ZOLPIDEM TARTRATE', b'ZONISAMIDE', b'ZOSTER VACCINE LIVE PF']],\n",
       "      dtype='|S256')"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f5['/data/column_labels'][:]\n",
    "#f5['/data/column_labels'][:,1:1167]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1, 912)"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "f5['/data/column_labels'][...].shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(145245120,)"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_array = f5[\"/data/core_array\"][...]\n",
    "#data_array = f5[\"/data/core_array\"][:,:,1:1167]\n",
    "data_array = np.ndarray.flatten(data_array)\n",
    "data_array.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "294046581"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "np.sum(data_array)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[b'is_excluded', b'total_claim_count', b'0 9 % SODIUM CHLORIDE',\n",
       "        b'ABACAVIR SULFATE', b'ABACAVIR SULFATE LAMIVUDINE',\n",
       "        b'ABACAVIR LAMIVUDINE ZIDOVUDINE', b'ABATACEPT',\n",
       "        b'ABATACEPT MALTOSE', b'ABIRATERONE ACETATE',\n",
       "        b'ACAMPROSATE CALCIUM', b'ACARBOSE', b'ACEBUTOLOL HCL',\n",
       "        b'ACETAMINOPHEN WITH CODEINE', b'ACETAZOLAMIDE', b'ACETIC ACID',\n",
       "        b'ACETYLCYSTEINE', b'ACITRETIN', b'ACLIDINIUM BROMIDE',\n",
       "        b'ACYCLOVIR', b'ADALIMUMAB', b'ADAPALENE', b'ADEFOVIR DIPIVOXIL',\n",
       "        b'ALBUTEROL SULFATE', b'ALCAFTADINE',\n",
       "        b'ALCLOMETASONE DIPROPIONATE', b'ALCOHOL ANTISEPTIC PADS',\n",
       "        b'ALENDRONATE SODIUM', b'ALENDRONATE SODIUM VITAMIN D3',\n",
       "        b'ALFUZOSIN HCL', b'ALISKIREN HEMIFUMARATE',\n",
       "        b'ALISKIREN HYDROCHLOROTHIAZIDE', b'ALLOPURINOL',\n",
       "        b'ALOSETRON HCL', b'ALPHA-1-PROTEINASE INHIBITOR', b'ALPRAZOLAM',\n",
       "        b'AMANTADINE HCL', b'AMBRISENTAN', b'AMIKACIN SULFATE',\n",
       "        b'AMILORIDE HCL', b'AMILORIDE HYDROCHLOROTHIAZIDE',\n",
       "        b'AMINOCAPROIC ACID', b'AMIODARONE HCL', b'AMITRIPTYLINE HCL',\n",
       "        b'AMLODIPINE BES OLMESARTAN MED', b'AMLODIPINE BESYLATE',\n",
       "        b'AMLODIPINE BESYLATE BENAZEPRIL', b'AMLODIPINE ATORVASTATIN',\n",
       "        b'AMLODIPINE VALSARTAN HCTHIAZID', b'AMMONIUM LACTATE',\n",
       "        b'AMOXAPINE', b'AMOXICILLIN', b'AMOXICILLIN POTASSIUM CLAV',\n",
       "        b'AMPICILLIN SODIUM', b'AMPICILLIN SODIUM SULBACTAM NA',\n",
       "        b'AMPICILLIN TRIHYDRATE', b'ANAGRELIDE HCL', b'ANASTROZOLE',\n",
       "        b'APIXABAN', b'APOMORPHINE HCL', b'APRACLONIDINE HCL',\n",
       "        b'APREPITANT', b'ARFORMOTEROL TARTRATE', b'ARIPIPRAZOLE',\n",
       "        b'ARMODAFINIL', b'ASENAPINE MALEATE', b'ASPIRIN DIPYRIDAMOLE',\n",
       "        b'ATAZANAVIR SULFATE', b'ATENOLOL', b'ATENOLOL CHLORTHALIDONE',\n",
       "        b'ATOMOXETINE HCL', b'ATORVASTATIN CALCIUM', b'ATOVAQUONE',\n",
       "        b'ATOVAQUONE PROGUANIL HCL', b'ATROPINE SULFATE', b'AURANOFIN',\n",
       "        b'AXITINIB', b'AZACITIDINE', b'AZATHIOPRINE', b'AZELAIC ACID',\n",
       "        b'AZELASTINE HCL', b'AZELASTINE FLUTICASONE',\n",
       "        b'AZILSARTAN MED CHLORTHALIDONE', b'AZILSARTAN MEDOXOMIL',\n",
       "        b'AZITHROMYCIN', b'AZTREONAM', b'BACITRACIN',\n",
       "        b'BACITRACIN POLYMYXIN B SULFATE', b'BACLOFEN',\n",
       "        b'BALSALAZIDE DISODIUM', b'BECLOMETHASONE DIPROPIONATE',\n",
       "        b'BELIMUMAB', b'BENAZEPRIL HCL',\n",
       "        b'BENAZEPRIL HYDROCHLOROTHIAZIDE', b'BENZONATATE',\n",
       "        b'BENZTROPINE MESYLATE', b'BEPOTASTINE BESILATE',\n",
       "        b'BESIFLOXACIN HCL', b'BETAMETHASONE DIPROPIONATE',\n",
       "        b'BETAMETHASONE VALERATE', b'BETAMETHASONE PROPYLENE GLYC',\n",
       "        b'BETAXOLOL HCL', b'BETHANECHOL CHLORIDE', b'BEVACIZUMAB',\n",
       "        b'BEXAROTENE', b'BICALUTAMIDE', b'BIMATOPROST',\n",
       "        b'BISOPROLOL FUMARATE', b'BORTEZOMIB', b'BOSENTAN',\n",
       "        b'BRIMONIDINE TARTRATE', b'BRIMONIDINE TARTRATE TIMOLOL',\n",
       "        b'BRINZOLAMIDE', b'BROMFENAC SODIUM', b'BROMOCRIPTINE MESYLATE',\n",
       "        b'BUDESONIDE', b'BUDESONIDE FORMOTEROL FUMARATE', b'BUMETANIDE',\n",
       "        b'BUPIVACAINE HCL PF', b'BUPRENORPHINE', b'BUPRENORPHINE HCL',\n",
       "        b'BUPRENORPHINE HCL NALOXONE HCL', b'BUPROPION HBR',\n",
       "        b'BUPROPION HCL', b'BUSPIRONE HCL',\n",
       "        b'BUTALB ACETAMINOPHEN CAFFEINE',\n",
       "        b'BUTALBIT ACETAMIN CAFF CODEINE',\n",
       "        b'BUTALBITAL ASPIRIN CAFFEINE', b'BUTENAFINE HCL',\n",
       "        b'BUTORPHANOL TARTRATE', b'C1 ESTERASE INHIBITOR',\n",
       "        b'CABERGOLINE', b'CALCIPOTRIENE', b'CALCIPOTRIENE BETAMETHASONE',\n",
       "        b'CALCITRIOL', b'CALCIUM ACETATE', b'CANAGLIFLOZIN',\n",
       "        b'CANDESARTAN CILEXETIL', b'CANDESARTAN HYDROCHLOROTHIAZID',\n",
       "        b'CAPTOPRIL', b'CAPTOPRIL HYDROCHLOROTHIAZIDE', b'CARBAMAZEPINE',\n",
       "        b'CARBIDOPA', b'CARBIDOPA LEVODOPA',\n",
       "        b'CARBIDOPA LEVODOPA ENTACAPONE', b'CARBINOXAMINE MALEATE',\n",
       "        b'CARBOPLATIN', b'CARISOPRODOL', b'CARTEOLOL HCL', b'CARVEDILOL',\n",
       "        b'CARVEDILOL PHOSPHATE', b'CEFAZOLIN SODIUM', b'CEFDINIR',\n",
       "        b'CEFEPIME HCL', b'CEFIXIME', b'CEFPODOXIME PROXETIL',\n",
       "        b'CEFPROZIL', b'CEFTAROLINE FOSAMIL ACETATE',\n",
       "        b'CEFTRIAXONE SODIUM', b'CEFUROXIME AXETIL', b'CELECOXIB',\n",
       "        b'CEPHALEXIN', b'CERTOLIZUMAB PEGOL', b'CETIRIZINE HCL',\n",
       "        b'CEVIMELINE HCL', b'CHENODIOL', b'CHLORAMBUCIL',\n",
       "        b'CHLORDIAZEPOXIDE HCL', b'CHLORHEXIDINE GLUCONATE',\n",
       "        b'CHLOROQUINE PHOSPHATE', b'CHLOROTHIAZIDE',\n",
       "        b'CHLORPROMAZINE HCL', b'CHLORTHALIDONE', b'CHLORZOXAZONE',\n",
       "        b'CHOLESTYRAMINE (WITH SUGAR)', b'CHOLESTYRAMINE ASPARTAME',\n",
       "        b'CICLESONIDE', b'CICLOPIROX', b'CICLOPIROX OLAMINE',\n",
       "        b'CILOSTAZOL', b'CIMETIDINE', b'CINACALCET HCL',\n",
       "        b'CIPROFLOXACIN HCL', b'CIPROFLOXACIN HCL DEXAMETH',\n",
       "        b'CIPROFLOXACIN CIPROFLOXA HCL', b'CISPLATIN',\n",
       "        b'CITALOPRAM HYDROBROMIDE', b'CITRIC ACID SODIUM CITRATE',\n",
       "        b'CLARITHROMYCIN', b'CLEMASTINE FUMARATE', b'CLINDAMYCIN HCL',\n",
       "        b'CLINDAMYCIN PHOS BENZOYL PEROX', b'CLINDAMYCIN PHOSPHATE',\n",
       "        b'CLOBAZAM', b'CLOBETASOL PROPIONATE',\n",
       "        b'CLOBETASOL PROPIONATE EMOLL', b'CLOCORTOLONE PIVALATE',\n",
       "        b'CLOMIPRAMINE HCL', b'CLONAZEPAM', b'CLONIDINE',\n",
       "        b'CLONIDINE HCL', b'CLOPIDOGREL BISULFATE',\n",
       "        b'CLORAZEPATE DIPOTASSIUM', b'CLOTRIMAZOLE',\n",
       "        b'CLOTRIMAZOLE BETAMETHASONE DIP', b'CLOZAPINE',\n",
       "        b'CODEINE SULFATE', b'CODEINE BUTALBITAL ASA CAFFEIN',\n",
       "        b'COLCHICINE', b'COLESEVELAM HCL', b'COLESTIPOL HCL',\n",
       "        b'COLISTIN (COLISTIMETHATE NA)',\n",
       "        b'COLLAGENASE CLOSTRIDIUM HIST ', b'CORTICOTROPIN',\n",
       "        b'CRIZOTINIB', b'CROMOLYN SODIUM', b'CROTAMITON',\n",
       "        b'CYCLOBENZAPRINE HCL', b'CYCLOPENTOLATE HCL',\n",
       "        b'CYCLOPHOSPHAMIDE', b'CYCLOSPORINE', b'CYPROHEPTADINE HCL',\n",
       "        b'DABIGATRAN ETEXILATE MESYLATE', b'DALFAMPRIDINE', b'DANAZOL',\n",
       "        b'DANTROLENE SODIUM', b'DAPSONE', b'DAPTOMYCIN',\n",
       "        b'DARBEPOETIN ALFA IN POLYSORBAT', b'DARIFENACIN HYDROBROMIDE',\n",
       "        b'DARUNAVIR ETHANOLATE', b'DASATINIB', b'DEFERASIROX',\n",
       "        b'DEGARELIX ACETATE', b'DEMECLOCYCLINE HCL', b'DENOSUMAB',\n",
       "        b'DESIPRAMINE HCL', b'DESLORATADINE',\n",
       "        b'DESLORATADINE PSEUDOEPHEDRINE',\n",
       "        b'DESMOPRESSIN (NONREFRIGERATED)', b'DESMOPRESSIN ACETATE',\n",
       "        b'DESOG-E ESTRADIOL E ESTRADIOL',\n",
       "        b'DESOGESTREL-ETHINYL ESTRADIOL', b'DESONIDE', b'DESOXIMETASONE',\n",
       "        b'DESVENLAFAXINE', b'DESVENLAFAXINE SUCCINATE', b'DEXAMETHASONE',\n",
       "        b'DEXAMETHASONE SOD PHOSPHATE', b'DEXLANSOPRAZOLE',\n",
       "        b'DEXMETHYLPHENIDATE HCL', b'DEXTROAMPHETAMINE SULFATE',\n",
       "        b'DEXTROAMPHETAMINE AMPHETAMINE',\n",
       "        b'DEXTROMETHORPHAN HBR QUINIDINE',\n",
       "        b'DEXTROSE 5 % AND 0 9 % NACL', b'DEXTROSE 5 % IN WATER',\n",
       "        b'DEXTROSE 70 % IN WATER', b'DIAZEPAM', b'DICLOFENAC EPOLAMINE',\n",
       "        b'DICLOFENAC POTASSIUM', b'DICLOFENAC SODIUM',\n",
       "        b'DICLOFENAC SODIUM MISOPROSTOL', b'DICLOXACILLIN SODIUM',\n",
       "        b'DICYCLOMINE HCL', b'DIDANOSINE', b'DIFLORASONE DIACETATE',\n",
       "        b'DIFLORASONE DIACETATE EMOLL', b'DIFLUNISAL', b'DIFLUPREDNATE',\n",
       "        b'DIGOXIN', b'DILTIAZEM HCL', b'DIMETHYL FUMARATE',\n",
       "        b'DIPHENHYDRAMINE HCL', b'DIPHENOXYLATE HCL ATROPINE',\n",
       "        b'DIPYRIDAMOLE', b'DISOPYRAMIDE PHOSPHATE', b'DISULFIRAM',\n",
       "        b'DIVALPROEX SODIUM', b'DOCETAXEL', b'DOFETILIDE',\n",
       "        b'DOLUTEGRAVIR SODIUM', b'DONEPEZIL HCL', b'DORZOLAMIDE HCL',\n",
       "        b'DORZOLAMIDE HCL TIMOLOL MALEAT', b'DORZOLAMIDE TIMOLOL PF',\n",
       "        b'DOXAZOSIN MESYLATE', b'DOXEPIN HCL', b'DOXERCALCIFEROL',\n",
       "        b'DOXYCYCLINE HYCLATE', b'DOXYCYCLINE MONOHYDRATE',\n",
       "        b'DRONABINOL', b'DRONEDARONE HCL', b'DULOXETINE HCL',\n",
       "        b'DUTASTERIDE', b'DUTASTERIDE TAMSULOSIN HCL',\n",
       "        b'ECHOTHIOPHATE IODIDE', b'ECONAZOLE NITRATE', b'EFAVIRENZ',\n",
       "        b'ELETRIPTAN HBR', b'ELTROMBOPAG OLAMINE', b'EMTRICITABINE',\n",
       "        b'ENALAPRIL MALEATE', b'ENALAPRIL HYDROCHLOROTHIAZIDE',\n",
       "        b'ENFUVIRTIDE', b'ENOXAPARIN SODIUM', b'ENTACAPONE',\n",
       "        b'ENTECAVIR', b'ENZALUTAMIDE', b'EPINASTINE HCL', b'EPINEPHRINE',\n",
       "        b'EPLERENONE', b'EPOETIN ALFA', b'ERGOCALCIFEROL (VITAMIN D2)',\n",
       "        b'ERGOLOID MESYLATES', b'ERLOTINIB HCL', b'ERTAPENEM SODIUM',\n",
       "        b'ERYTHROMYCIN BASE', b'ERYTHROMYCIN BASE ETHANOL',\n",
       "        b'ERYTHROMYCIN ETHYLSUCCINATE', b'ERYTHROMYCIN STEARATE',\n",
       "        b'ERYTHROMYCIN BENZOYL PEROXIDE', b'ESCITALOPRAM OXALATE',\n",
       "        b'ESOMEPRAZOLE MAGNESIUM', b'ESTAZOLAM', b'ESTRADIOL',\n",
       "        b'ESTRADIOL NORETHINDRONE ACET', b'ESZOPICLONE', b'ETANERCEPT',\n",
       "        b'ETHACRYNIC ACID', b'ETHAMBUTOL HCL',\n",
       "        b'ETHINYL ESTRADIOL DROSPIRENONE', b'ETHOSUXIMIDE',\n",
       "        b'ETHYNODIOL D-ETHINYL ESTRADIOL', b'ETODOLAC',\n",
       "        b'ETONOGESTREL ETHINYL ESTRADIOL', b'ETRAVIRINE', b'EVEROLIMUS',\n",
       "        b'EXEMESTANE', b'EXENATIDE', b'EXENATIDE MICROSPHERES',\n",
       "        b'EZETIMIBE', b'EZETIMIBE SIMVASTATIN', b'FAMCICLOVIR',\n",
       "        b'FAMOTIDINE', b'FAT EMULSIONS', b'FEBUXOSTAT', b'FELBAMATE',\n",
       "        b'FELODIPINE', b'FENOFIBRATE', b'FENOFIBRATE NANOCRYSTALLIZED',\n",
       "        b'FENOFIBRIC ACID', b'FENOFIBRIC ACID (CHOLINE)', b'FENTANYL',\n",
       "        b'FENTANYL CITRATE', b'FESOTERODINE FUMARATE', b'FILGRASTIM',\n",
       "        b'FINASTERIDE', b'FINGOLIMOD HCL', b'FLAVOXATE HCL',\n",
       "        b'FLECAINIDE ACETATE', b'FLUCONAZOLE',\n",
       "        b'FLUDROCORTISONE ACETATE', b'FLUNISOLIDE',\n",
       "        b'FLUOCINOLONE ACETONIDE', b'FLUOCINOLONE ACETONIDE OIL',\n",
       "        b'FLUOCINOLONE SHOWER CAP', b'FLUOCINONIDE',\n",
       "        b'FLUOCINONIDE EMOLLIENT BASE', b'FLUOROMETHOLONE',\n",
       "        b'FLUOROURACIL', b'FLUOXETINE HCL', b'FLUPHENAZINE DECANOATE',\n",
       "        b'FLUPHENAZINE HCL', b'FLURAZEPAM HCL', b'FLURBIPROFEN',\n",
       "        b'FLURBIPROFEN SODIUM', b'FLUTAMIDE', b'FLUTICASONE FUROATE',\n",
       "        b'FLUTICASONE PROPIONATE', b'FLUTICASONE SALMETEROL',\n",
       "        b'FLUVASTATIN SODIUM', b'FLUVOXAMINE MALEATE', b'FOLIC ACID',\n",
       "        b'FONDAPARINUX SODIUM', b'FORMOTEROL FUMARATE',\n",
       "        b'FOSAMPRENAVIR CALCIUM', b'FOSAPREPITANT DIMEGLUMINE',\n",
       "        b'FOSFOMYCIN TROMETHAMINE', b'FOSINOPRIL SODIUM',\n",
       "        b'FOSINOPRIL HYDROCHLOROTHIAZIDE', b'FROVATRIPTAN SUCCINATE',\n",
       "        b'FULVESTRANT', b'FUROSEMIDE', b'GABAPENTIN',\n",
       "        b'GABAPENTIN ENACARBIL', b'GALANTAMINE HBR', b'GANCICLOVIR',\n",
       "        b'GATIFLOXACIN', b'GEMCITABINE HCL', b'GEMFIBROZIL',\n",
       "        b'GENTAMICIN SULFATE', b'GLATIRAMER ACETATE', b'GLIMEPIRIDE',\n",
       "        b'GLIPIZIDE', b'GLIPIZIDE METFORMIN HCL', b'GLYBURIDE',\n",
       "        b'GLYBURIDE METFORMIN HCL', b'GLYCEROL PHENYLBUTYRATE',\n",
       "        b'GLYCOPYRROLATE', b'GOLIMUMAB', b'GOSERELIN ACETATE',\n",
       "        b'GRANISETRON', b'GRANISETRON HCL',\n",
       "        b'GRISEOFULVIN ULTRAMICROSIZE', b'GUANFACINE HCL',\n",
       "        b'HALCINONIDE', b'HALOBETASOL PROPIONATE', b'HALOPERIDOL',\n",
       "        b'HALOPERIDOL DECANOATE', b'HALOPERIDOL LACTATE',\n",
       "        b'HEPATITIS A VIRUS VACCINE PF', b'HYDRALAZINE HCL',\n",
       "        b'HYDROCHLOROTHIAZIDE', b'HYDROCODONE BIT HOMATROP ME-BR',\n",
       "        b'HYDROCODONE ACETAMINOPHEN', b'HYDROCODONE IBUPROFEN',\n",
       "        b'HYDROCORTISONE', b'HYDROCORTISONE ACETATE',\n",
       "        b'HYDROCORTISONE BUTYRATE', b'HYDROCORTISONE VALERATE',\n",
       "        b'HYDROCORTISONE PRAMOXINE', b'HYDROMORPHONE HCL',\n",
       "        b'HYDROMORPHONE HCL PF', b'HYDROXYCHLOROQUINE SULFATE',\n",
       "        b'HYDROXYPROPYL CELLULOSE', b'HYDROXYUREA', b'HYDROXYZINE HCL',\n",
       "        b'HYDROXYZINE PAMOATE', b'HYOSCYAMINE SULFATE',\n",
       "        b'IBANDRONATE SODIUM', b'IBUPROFEN', b'IBUPROFEN FAMOTIDINE',\n",
       "        b'ICATIBANT ACETATE', b'ICOSAPENT ETHYL', b'ILOPERIDONE',\n",
       "        b'IMATINIB MESYLATE', b'IMIPENEM CILASTATIN SODIUM',\n",
       "        b'IMIPRAMINE HCL', b'IMIPRAMINE PAMOATE', b'IMIQUIMOD',\n",
       "        b'INDACATEROL MALEATE', b'INDAPAMIDE', b'INDOMETHACIN',\n",
       "        b'INFLIXIMAB', b'INGENOL MEBUTATE', b'INSULIN ASPART',\n",
       "        b'INSULIN DETEMIR', b'INSULIN GLULISINE', b'INSULIN LISPRO',\n",
       "        b'INTERFERON BETA-1A', b'INTERFERON BETA-1A ALBUMIN',\n",
       "        b'INTERFERON BETA-1B', b'IPRATROPIUM BROMIDE',\n",
       "        b'IPRATROPIUM ALBUTEROL SULFATE', b'IRBESARTAN',\n",
       "        b'IRBESARTAN HYDROCHLOROTHIAZIDE', b'IRINOTECAN HCL',\n",
       "        b'ISOCARBOXAZID', b'ISONIAZID', b'ISOSORBIDE DINITRATE',\n",
       "        b'ISOSORBIDE MONONITRATE', b'ISRADIPINE', b'ITRACONAZOLE',\n",
       "        b'IVERMECTIN', b'KETOCONAZOLE', b'KETOPROFEN',\n",
       "        b'KETOROLAC TROMETHAMINE', b'LABETALOL HCL', b'LACOSAMIDE',\n",
       "        b'LACTULOSE', b'LAMIVUDINE', b'LAMIVUDINE ZIDOVUDINE',\n",
       "        b'LAMOTRIGINE', b'LANREOTIDE ACETATE', b'LANSOPRAZOLE',\n",
       "        b'LANTHANUM CARBONATE', b'LAPATINIB DITOSYLATE', b'LATANOPROST',\n",
       "        b'LEFLUNOMIDE', b'LENALIDOMIDE', b'LETROZOLE',\n",
       "        b'LEUCOVORIN CALCIUM', b'LEUPROLIDE ACETATE',\n",
       "        b'LEVALBUTEROL HCL', b'LEVALBUTEROL TARTRATE', b'LEVETIRACETAM',\n",
       "        b'LEVOBUNOLOL HCL', b'LEVOCARNITINE',\n",
       "        b'LEVOCARNITINE (WITH SUGAR)', b'LEVOCETIRIZINE DIHYDROCHLORIDE',\n",
       "        b'LEVOFLOXACIN', b'LEVOTHYROXINE SODIUM', b'LIDOCAINE',\n",
       "        b'LIDOCAINE HCL', b'LIDOCAINE HCL PF', b'LIDOCAINE PRILOCAINE',\n",
       "        b'LINACLOTIDE', b'LINAGLIPTIN', b'LINAGLIPTIN METFORMIN HCL',\n",
       "        b'LINEZOLID', b'LIOTHYRONINE SODIUM', b'LIPASE PROTEASE AMYLASE',\n",
       "        b'LIRAGLUTIDE', b'LISDEXAMFETAMINE DIMESYLATE', b'LISINOPRIL',\n",
       "        b'LISINOPRIL HYDROCHLOROTHIAZIDE', b'LITHIUM CARBONATE',\n",
       "        b'LITHIUM CITRATE', b'LOPERAMIDE HCL', b'LOPINAVIR RITONAVIR',\n",
       "        b'LORAZEPAM', b'LOSARTAN POTASSIUM',\n",
       "        b'LOSARTAN HYDROCHLOROTHIAZIDE', b'LOTEPREDNOL ETABONATE',\n",
       "        b'LOVASTATIN', b'LOXAPINE SUCCINATE', b'LUBIPROSTONE',\n",
       "        b'LURASIDONE HCL', b'MAGNESIUM SULFATE', b'MAPROTILINE HCL',\n",
       "        b'MARAVIROC', b'MECLIZINE HCL', b'MEDROXYPROGESTERONE ACETATE',\n",
       "        b'MEFLOQUINE HCL', b'MEGESTROL ACETATE', b'MELOXICAM',\n",
       "        b'MEMANTINE HCL', b'MEPERIDINE HCL', b'MEPERIDINE HCL PF',\n",
       "        b'MEPROBAMATE', b'MERCAPTOPURINE', b'MEROPENEM', b'MESALAMINE',\n",
       "        b'METAXALONE', b'METFORMIN HCL', b'METHADONE HCL',\n",
       "        b'METHAMPHETAMINE HCL', b'METHAZOLAMIDE',\n",
       "        b'METHENAMINE HIPPURATE', b'METHENAMINE MANDELATE',\n",
       "        b'METHIMAZOLE', b'METHOCARBAMOL', b'METHOTREXATE SODIUM',\n",
       "        b'METHOTREXATE SODIUM PF', b'METHSCOPOLAMINE BROMIDE',\n",
       "        b'METHSUXIMIDE', b'METHYCLOTHIAZIDE', b'METHYLDOPA',\n",
       "        b'METHYLNALTREXONE BROMIDE', b'METHYLPHENIDATE HCL',\n",
       "        b'METHYLPREDNISOLONE', b'METHYLPREDNISOLONE ACETATE',\n",
       "        b'METHYLPREDNISOLONE SOD SUCC',\n",
       "        b'METHYLPREDNISOLONE SOD SUCC PF', b'METOCLOPRAMIDE HCL',\n",
       "        b'METOLAZONE', b'METOPROLOL SUCCINATE', b'METOPROLOL TARTRATE',\n",
       "        b'METOPROLOL HYDROCHLOROTHIAZIDE', b'METRONIDAZOLE',\n",
       "        b'METRONIDAZOLE SODIUM CHLORIDE', b'MEXILETINE HCL',\n",
       "        b'MIDODRINE HCL', b'MIGLITOL', b'MILNACIPRAN HCL',\n",
       "        b'MILRINONE LACTATE', b'MINOCYCLINE HCL', b'MINOXIDIL',\n",
       "        b'MIRABEGRON', b'MIRTAZAPINE', b'MISOPROSTOL', b'MODAFINIL',\n",
       "        b'MOEXIPRIL HCL', b'MOEXIPRIL HYDROCHLOROTHIAZIDE',\n",
       "        b'MOMETASONE FUROATE', b'MOMETASONE FORMOTEROL',\n",
       "        b'MONTELUKAST SODIUM', b'MORPHINE SULFATE', b'MOXIFLOXACIN HCL',\n",
       "        b'MUPIROCIN', b'MUPIROCIN CALCIUM', b'MYCOPHENOLATE MOFETIL',\n",
       "        b'MYCOPHENOLATE SODIUM', b'NABUMETONE', b'NADOLOL',\n",
       "        b'NAFCILLIN SODIUM', b'NAFTIFINE HCL', b'NALTREXONE HCL',\n",
       "        b'NALTREXONE MICROSPHERES', b'NAPROXEN', b'NAPROXEN SODIUM',\n",
       "        b'NAPROXEN ESOMEPRAZOLE MAG', b'NARATRIPTAN HCL', b'NATALIZUMAB',\n",
       "        b'NATEGLINIDE', b'NEBIVOLOL HCL', b'NEFAZODONE HCL',\n",
       "        b'NELFINAVIR MESYLATE', b'NEOMYCIN SULFATE', b'NEPAFENAC',\n",
       "        b'NEVIRAPINE', b'NIACIN', b'NICARDIPINE HCL', b'NICOTINE',\n",
       "        b'NIFEDIPINE', b'NILOTINIB HCL', b'NILUTAMIDE', b'NISOLDIPINE',\n",
       "        b'NITROFURANTOIN', b'NITROFURANTOIN MACROCRYSTAL',\n",
       "        b'NITROFURANTOIN MONOHYD M-CRYST', b'NITROGLYCERIN',\n",
       "        b'NIZATIDINE', b'NORELGESTROMIN ETHIN ESTRADIOL',\n",
       "        b'NORETH-ETHINYL ESTRADIOL IRON', b'NORETHINDRONE',\n",
       "        b'NORETHINDRONE ACETATE', b'NORETHINDRONE-ETHINYL ESTRAD',\n",
       "        b'NORGESTIMATE-ETHINYL ESTRADIOL',\n",
       "        b'NORGESTREL-ETHINYL ESTRADIOL', b'NORTRIPTYLINE HCL',\n",
       "        b'NYSTATIN', b'NYSTATIN TRIAMCIN', b'OCTREOTIDE ACETATE',\n",
       "        b'OFLOXACIN', b'OLANZAPINE', b'OLANZAPINE PAMOATE',\n",
       "        b'OLANZAPINE FLUOXETINE HCL', b'OLMESARTAN MEDOXOMIL',\n",
       "        b'OLMESARTAN AMLODIPIN HCTHIAZID',\n",
       "        b'OLMESARTAN HYDROCHLOROTHIAZIDE', b'OLOPATADINE HCL',\n",
       "        b'OLSALAZINE SODIUM', b'OMALIZUMAB',\n",
       "        b'OMEGA-3 ACID ETHYL ESTERS', b'OMEPRAZOLE',\n",
       "        b'OMEPRAZOLE MAGNESIUM', b'OMEPRAZOLE SODIUM BICARBONATE',\n",
       "        b'ONABOTULINUMTOXINA', b'ONDANSETRON', b'ONDANSETRON HCL',\n",
       "        b'ONDANSETRON HCL PF', b'OPIUM TINCTURE',\n",
       "        b'ORPHENADRINE CITRATE', b'OSELTAMIVIR PHOSPHATE',\n",
       "        b'OXALIPLATIN', b'OXANDROLONE', b'OXAPROZIN', b'OXAZEPAM',\n",
       "        b'OXCARBAZEPINE', b'OXICONAZOLE NITRATE', b'OXYBUTYNIN',\n",
       "        b'OXYBUTYNIN CHLORIDE', b'OXYCODONE HCL',\n",
       "        b'OXYCODONE HCL ACETAMINOPHEN', b'OXYCODONE HCL ASPIRIN',\n",
       "        b'OXYMORPHONE HCL', b'PACLITAXEL', b'PACLITAXEL PROTEIN-BOUND',\n",
       "        b'PALIPERIDONE', b'PALIPERIDONE PALMITATE', b'PALONOSETRON HCL',\n",
       "        b'PANTOPRAZOLE SODIUM', b'PARENTERAL AMINO ACID 15% NO 1',\n",
       "        b'PARENTERAL AMINO ACID 20% NO 1', b'PARICALCITOL',\n",
       "        b'PAROXETINE HCL', b'PAROXETINE MESYLATE', b'PAZOPANIB HCL',\n",
       "        b'PEG3350 SOD SUL NACL ASB C KCL', b'PEGFILGRASTIM',\n",
       "        b'PEGINTERFERON ALFA-2A', b'PEMETREXED DISODIUM', b'PENCICLOVIR',\n",
       "        b'PENICILLIN V POTASSIUM', b'PENTAZOCINE HCL NALOXONE HCL',\n",
       "        b'PENTOSAN POLYSULFATE SODIUM', b'PENTOXIFYLLINE',\n",
       "        b'PERINDOPRIL ERBUMINE', b'PERMETHRIN', b'PERPHENAZINE',\n",
       "        b'PERPHENAZINE AMITRIPTYLINE HCL', b'PHENAZOPYRIDINE HCL',\n",
       "        b'PHENELZINE SULFATE', b'PHENOBARBITAL',\n",
       "        b'PHENYLEPHRINE HCL PROMETH HCL', b'PHENYTOIN',\n",
       "        b'PHENYTOIN SODIUM EXTENDED', b'PILOCARPINE HCL',\n",
       "        b'PIMECROLIMUS', b'PIMOZIDE', b'PINDOLOL', b'PIOGLITAZONE HCL',\n",
       "        b'PIOGLITAZONE HCL GLIMEPIRIDE',\n",
       "        b'PIOGLITAZONE HCL METFORMIN HCL',\n",
       "        b'PIPERACILLIN SODIUM TAZOBACTAM', b'PIROXICAM',\n",
       "        b'PITAVASTATIN CALCIUM', b'PODOFILOX',\n",
       "        b'POLYETHYLENE GLYCOL 3350', b'POLYMYXIN B SULF TRIMETHOPRIM',\n",
       "        b'POMALIDOMIDE', b'POSACONAZOLE',\n",
       "        b'POTASSIUM BICARBONATE CIT AC', b'POTASSIUM CHLORIDE',\n",
       "        b'POTASSIUM CITRATE', b'PRAMIPEXOLE DI-HCL',\n",
       "        b'PRAMLINTIDE ACETATE', b'PRASUGREL HCL', b'PRAVASTATIN SODIUM',\n",
       "        b'PRAZOSIN HCL', b'PREDNICARBATE', b'PREDNISOLONE',\n",
       "        b'PREDNISOLONE ACETATE', b'PREDNISOLONE SOD PHOSPHATE',\n",
       "        b'PREDNISONE', b'PREGABALIN', b'PRIMIDONE', b'PROBENECID',\n",
       "        b'PROCHLORPERAZINE MALEATE', b'PROMETHAZINE HCL',\n",
       "        b'PROPAFENONE HCL', b'PROPANTHELINE BROMIDE', b'PROPRANOLOL HCL',\n",
       "        b'PROPRANOLOL HYDROCHLOROTHIAZID', b'PROPYLTHIOURACIL',\n",
       "        b'PROTRIPTYLINE HCL', b'PSEUDOEPHEDRINE HCL ACRIVAS',\n",
       "        b'PYRIDOSTIGMINE BROMIDE', b'QUETIAPINE FUMARATE',\n",
       "        b'QUINAPRIL HCL', b'QUINAPRIL HYDROCHLOROTHIAZIDE',\n",
       "        b'QUINIDINE GLUCONATE', b'QUININE SULFATE',\n",
       "        b'RABEPRAZOLE SODIUM', b'RALOXIFENE HCL',\n",
       "        b'RALTEGRAVIR POTASSIUM', b'RAMELTEON', b'RAMIPRIL',\n",
       "        b'RANITIDINE HCL', b'RANOLAZINE', b'RASAGILINE MESYLATE',\n",
       "        b'REGORAFENIB', b'REPAGLINIDE', b'RIBAVIRIN', b'RIFABUTIN',\n",
       "        b'RIFAMPIN', b'RIFAXIMIN', b'RILPIVIRINE HCL', b'RILUZOLE',\n",
       "        b'RISEDRONATE SODIUM', b'RISPERIDONE',\n",
       "        b'RISPERIDONE MICROSPHERES', b'RITONAVIR', b'RITUXIMAB',\n",
       "        b'RIVAROXABAN', b'RIVASTIGMINE', b'RIVASTIGMINE TARTRATE',\n",
       "        b'RIZATRIPTAN BENZOATE', b'ROFLUMILAST', b'ROPINIROLE HCL',\n",
       "        b'ROSUVASTATIN CALCIUM', b'ROTIGOTINE', b'RUFINAMIDE',\n",
       "        b'RUXOLITINIB PHOSPHATE', b'SALMETEROL XINAFOATE', b'SALSALATE',\n",
       "        b'SAPROPTERIN DIHYDROCHLORIDE', b'SAQUINAVIR MESYLATE',\n",
       "        b'SAXAGLIPTIN HCL', b'SAXAGLIPTIN HCL METFORMIN HCL',\n",
       "        b'SCOPOLAMINE', b'SELEGILINE', b'SELEGILINE HCL',\n",
       "        b'SELENIUM SULFIDE', b'SERTRALINE HCL', b'SEVELAMER CARBONATE',\n",
       "        b'SEVELAMER HCL', b'SILDENAFIL CITRATE', b'SILODOSIN',\n",
       "        b'SILVER SULFADIAZINE', b'SIMVASTATIN', b'SIROLIMUS',\n",
       "        b'SITAGLIPTIN PHOS METFORMIN HCL', b'SITAGLIPTIN PHOSPHATE',\n",
       "        b'SOD PICOSULF MAG OX CITRIC AC', b'SODIUM BICARBONATE',\n",
       "        b'SODIUM CHLORIDE 0 45 %', b'SODIUM CHLORIDE IRRIG SOLUTION',\n",
       "        b'SODIUM CHLORIDE NAHCO3 KCL PEG', b'SODIUM OXYBATE',\n",
       "        b'SODIUM POLYSTYRENE SULFONATE', b'SOLIFENACIN SUCCINATE',\n",
       "        b'SOMATROPIN', b'SORAFENIB TOSYLATE', b'SOTALOL HCL',\n",
       "        b'SPIRONOLACT HYDROCHLOROTHIAZID', b'SPIRONOLACTONE',\n",
       "        b'STAVUDINE', b'SUCRALFATE', b'SULFACETAMIDE SODIUM',\n",
       "        b'SULFACETAMIDE PREDNISOLONE SP', b'SULFADIAZINE',\n",
       "        b'SULFAMETHOXAZOLE TRIMETHOPRIM', b'SULFASALAZINE', b'SULINDAC',\n",
       "        b'SUMATRIPTAN', b'SUMATRIPTAN SUCC NAPROXEN SOD',\n",
       "        b'SUMATRIPTAN SUCCINATE', b'SUNITINIB MALATE', b'TACROLIMUS',\n",
       "        b'TADALAFIL', b'TAFLUPROST PF', b'TAMOXIFEN CITRATE',\n",
       "        b'TAMSULOSIN HCL', b'TAPENTADOL HCL', b'TAZAROTENE',\n",
       "        b'TELMISARTAN', b'TELMISARTAN AMLODIPINE',\n",
       "        b'TELMISARTAN HYDROCHLOROTHIAZID', b'TEMAZEPAM',\n",
       "        b'TENOFOVIR DISOPROXIL FUMARATE', b'TERAZOSIN HCL',\n",
       "        b'TERBINAFINE HCL', b'TERBUTALINE SULFATE', b'TERCONAZOLE',\n",
       "        b'TERIFLUNOMIDE', b'TERIPARATIDE', b'TESTOSTERONE',\n",
       "        b'TESTOSTERONE CYPIONATE', b'TETRABENAZINE', b'THALIDOMIDE',\n",
       "        b'THEOPHYLLINE ANHYDROUS', b'THIORIDAZINE HCL', b'THIOTHIXENE',\n",
       "        b'TIAGABINE HCL', b'TICAGRELOR', b'TIGECYCLINE', b'TIMOLOL',\n",
       "        b'TIMOLOL MALEATE', b'TIMOLOL MALEATE PF', b'TINIDAZOLE',\n",
       "        b'TIOTROPIUM BROMIDE', b'TIPRANAVIR', b'TIZANIDINE HCL',\n",
       "        b'TOBRAMYCIN', b'TOBRAMYCIN SULFATE',\n",
       "        b'TOBRAMYCIN DEXAMETHASONE', b'TOBRAMYCIN LOTEPRED ETAB',\n",
       "        b'TOCILIZUMAB', b'TOFACITINIB CITRATE', b'TOLTERODINE TARTRATE',\n",
       "        b'TOLVAPTAN', b'TOPIRAMATE', b'TOREMIFENE CITRATE', b'TORSEMIDE',\n",
       "        b'TRAMADOL HCL', b'TRAMADOL HCL ACETAMINOPHEN', b'TRANDOLAPRIL',\n",
       "        b'TRANDOLAPRIL VERAPAMIL HCL', b'TRANYLCYPROMINE SULFATE',\n",
       "        b'TRASTUZUMAB', b'TRAVOPROST', b'TRAZODONE HCL', b'TRETINOIN',\n",
       "        b'TRIAMCINOLONE ACETONIDE', b'TRIAMTERENE',\n",
       "        b'TRIAMTERENE HYDROCHLOROTHIAZID', b'TRIAZOLAM',\n",
       "        b'TRIFLUOPERAZINE HCL', b'TRIFLURIDINE', b'TRIHEXYPHENIDYL HCL',\n",
       "        b'TRIMETHOBENZAMIDE HCL', b'TRIMETHOPRIM',\n",
       "        b'TRIMIPRAMINE MALEATE', b'TRIPTORELIN PAMOATE', b'TROPICAMIDE',\n",
       "        b'TROSPIUM CHLORIDE', b'URSODIOL', b'USTEKINUMAB',\n",
       "        b'VALACYCLOVIR HCL', b'VALGANCICLOVIR HCL', b'VALPROIC ACID',\n",
       "        b'VALPROIC ACID (AS SODIUM SALT)', b'VALSARTAN',\n",
       "        b'VALSARTAN HYDROCHLOROTHIAZIDE', b'VANCOMYCIN HCL',\n",
       "        b'VARENICLINE TARTRATE', b'VENLAFAXINE HCL', b'VERAPAMIL HCL',\n",
       "        b'VISMODEGIB', b'VORICONAZOLE', b'WARFARIN SODIUM',\n",
       "        b'ZAFIRLUKAST', b'ZALEPLON', b'ZIDOVUDINE', b'ZILEUTON',\n",
       "        b'ZIPRASIDONE HCL', b'ZOLEDRONIC ACID', b'ZOLMITRIPTAN',\n",
       "        b'ZOLPIDEM TARTRATE', b'ZONISAMIDE', b'ZOSTER VACCINE LIVE PF']],\n",
       "      dtype='|S256')"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_labels = f5[\"/data/column_labels\"][...]\n",
    "#data_labels = f5[\"/data/column_labels\"][:,1:1167]\n",
    "data_labels"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}