Skip to content

Instantly share code, notes, and snippets.

@forskamse
forskamse / Treat.md
Last active March 22, 2019 14:11
Treatment Analysis

Basic Info

  • CSV Size: 46GB
  • Item Number: ~74000000

Example View of Shortcut MET_IPM_ORDER

|INPATIENT_NO|PATIENT_NO|TYPE_CODE|TYPE_NAME|ITEM_TYPE|ITEM_CODE|ITEM_NAME|CLASS_CODE|CLASS_NAME|PACK_QTY|SPECS|DOSE_MODEL_CODE|DRUG_TYPE|DRUG_QUALITY|COMB_NO|MAIN_DRUG|USAGE_CODE|USE_NAME|FREQUENCY_CODE|FREQUENCY_NAME|DOSE_ONCE||||||

@forskamse
forskamse / export_dataframe_to_md_tables.md
Last active March 22, 2019 07:04
[Export Python DataFrame to Markdown Table]
  • his/pha_sto_recipe.test.pickle
PARENT_CODE CURRENT_CODE DRUG_DEPT_CODE RECIPE_NO CLASS3_MEANING_CODE TRANS_TYPE RECIPE_STATE CLINIC_CODE CARD_NO PATIENT_NAME SEX_CODE BIRTHDAY PAYKIND_CODE DEPT_CODE REG_DATE DOCT_CODE DOCT_DEPT DRUGED_TERMINAL SEND_TERMINAL FEE_OPER FEE_DATE INVOICE_NO RECIPE_COST RECIPE_QTY DRUGED_QTY DRUGED_OPER DRUGED_DEPT DRUGED_DATE SEND_OPER SEND_DATE SEND_DEPT VALID_STATE MODIFY_FLAG BACK_OPER BACK_DATE CANCEL_OPER CANCEL_DATE MARK SUM_DAYS SORT_ID
10 4004 678 8369 M1 1 3 1700 0000001230 谭肖容 F 1973/5/19 8:00:29 3 594 2006/5/19 8:01:09 989 594 34 33 1417 2006/5/19 8:25:54 54980562 62.60 3.0 1.0 1572.0 678 2006/5/19 9:31:22 1141.0 2006/5/19 10:07:47 678 0 0 NaN 0001/1/1
10 4004 678 8368 M1 1 3 1700 0000001230 谭肖容 F 1973/5/19 8:00:29 3 594 2006/5/19 8:01:09 989 594 34 33 1417 2006/5/19 8:25:54 54980562 62.60 3.0 1.0 1572.0 678 2006/5/19 9:33:00 1141.0 2006/5/19 10:07:39 678 0 0 NaN 0001/1/1
10 4004