-
Notifications
You must be signed in to change notification settings - Fork 0
nirajpaudel14/icdparser
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
## use where_clause.py to generate where clause for cohort make sure you choose correct sheet while generating where clause. default name is 'Sheet1' use case_when.py to generate case when statement with flag make sure you choose correct sheet while generating where clause. default name is 'Sheet2' things to consider before running code Make sure excel file is in standard format i.e Sheet1 to generate cohort script with 'where'clause Sheet2 to generate flag script with 'case when' statement codes are in table format separate column for separate codes codes must be separeted with either comma or space steps to follow: 1. Move or save excel file to working directory of python 2. open .py file (where_clause.py or case_when.py) 3. find(ctrl +f) @inputfilename 4. assign excel file name to variable 'input_filename' e.g. input_filename = 'ed_afrf.xlsx' 5. if the sheet names are different change sheet name under @inputsheetname 6. Run the code output file name is automatically generated based on inputfile name and text file with script will be created in working directory python for example: ed_afrf_case_when_script and ed_afrf_cohort_script Standard format excel criteria 1. separate column for each code EX. {inc_icd9, inc_icd10, inc_proc, exc_icd9, exc_icd10, exc_proc} 2. separate column for condition 3. wild card format: lower case 'x' should be used in code EX. '945.x', 'D434.xx' x = range from 0-9 EX. '99.x' -> '99.0' to '99.9' xx = range from 00-99 EX. '99.xx' -> '99.00' to '99.99' 4. range of code format: for alphanumeric range , alpha character should be on both side EX. 'A234-A500', 'ZA34.20-ZA34.30'
About
parsing diagnosis and procedure code from csv table
Resources
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published