| 1 |
"""
|
| 2 |
|
| 3 |
john_muir_dataParser
|
| 4 |
|
| 5 |
Created by
|
| 6 |
Emanuel Borges
|
| 7 |
03.26.2014
|
| 8 |
|
| 9 |
This program will run parse a very complex excel export into somthing that can be imported into RL.
|
| 10 |
|
| 11 |
"""
|
| 12 |
|
| 13 |
import re,string
|
| 14 |
|
| 15 |
def Parse(contents,outputFile):
|
| 16 |
comments = ""
|
| 17 |
actHC =""
|
| 18 |
dur =""
|
| 19 |
attndPhy =""
|
| 20 |
cptCode =""
|
| 21 |
stTmDxDlvd =""
|
| 22 |
primaryDiag =""
|
| 23 |
count = 1
|
| 24 |
outputFile.write("Sch_Date|Sch_Time|ActTx_Time|Status|Comments|Activity|Patient Name|MedRc|P Stf|Loc|MD|Dur|AttndPhy|CptCode|PrimaryDiag\n")
|
| 25 |
for line in contents:
|
| 26 |
match = re.search(r'^\d+/\d+/\d+[|][ ]*\d+:\d+(am|pm)?',line)
|
| 27 |
line = line.replace("\n","")
|
| 28 |
line = line.split("|")
|
| 29 |
if match:
|
| 30 |
if count >1:
|
| 31 |
outputFile.write("%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s\n"%(date,time,stTmDxDlvd,sts,comments,actHC,pName,medRc,pStr,loc,md,dur,attndPhy,cptCode,primaryDiag))
|
| 32 |
actHC =""
|
| 33 |
dur =""
|
| 34 |
attndPhy =""
|
| 35 |
cptCode =""
|
| 36 |
stTmDxDlvd =""
|
| 37 |
primaryDiag =""
|
| 38 |
comments =""
|
| 39 |
|
| 40 |
date = ""
|
| 41 |
time = ""
|
| 42 |
pName = ""
|
| 43 |
medRc = ""
|
| 44 |
desc = ""
|
| 45 |
pStr = ""
|
| 46 |
loc = ""
|
| 47 |
sts = ""
|
| 48 |
md = ""
|
| 49 |
|
| 50 |
count = count+1
|
| 51 |
|
| 52 |
date = line[0]
|
| 53 |
time = line[1]
|
| 54 |
time = time.lstrip()
|
| 55 |
time = time.split(" ")
|
| 56 |
tmPt1,tmPt2 = time
|
| 57 |
tmPt2.lower()
|
| 58 |
time = "%s %s"% (tmPt1,tmPt2)
|
| 59 |
pName = line[3]
|
| 60 |
medRc = line[8]
|
| 61 |
|
| 62 |
if medRc:
|
| 63 |
desc = line[13]
|
| 64 |
pStr = line[21]
|
| 65 |
loc = line[23]
|
| 66 |
sts = line[28]
|
| 67 |
else:
|
| 68 |
desc = line[12]
|
| 69 |
pStr = line[17]
|
| 70 |
loc = line[20]
|
| 71 |
sts = line[24]
|
| 72 |
|
| 73 |
md = line[25]
|
| 74 |
#elif "Activity & (Hosp Code):" in line:
|
| 75 |
elif "Activity & (Hos.Code):" in line:
|
| 76 |
actHC = line[3]
|
| 77 |
dur = line[11]
|
| 78 |
attndPhy = line[21]
|
| 79 |
if attndPhy:
|
| 80 |
test = attndPhy.split(",")
|
| 81 |
fstInit = test[1][1]
|
| 82 |
lstInit = test[0][0]
|
| 83 |
if md == "%s%s"%(fstInit,lstInit):
|
| 84 |
pass
|
| 85 |
else:
|
| 86 |
sts = md
|
| 87 |
md = loc
|
| 88 |
loc = pStr
|
| 89 |
if pStr == loc:
|
| 90 |
pStr = ""
|
| 91 |
elif "CPT Code:" in line:
|
| 92 |
cptCode = line[4]
|
| 93 |
stTmDxDlvd = line[18]
|
| 94 |
elif "Primary Diagnosis:" in line:
|
| 95 |
primaryDiag = line[3]
|
| 96 |
primaryDiag = primaryDiag + ";"+line[4]
|
| 97 |
elif "Comments:" in line:
|
| 98 |
comments = line[3]
|
| 99 |
comments = comments.lower()
|
| 100 |
comments = string.upper(comments[0]) + comments[1:]
|
| 101 |
outputFile.write("%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s\n"%(date,time,stTmDxDlvd,sts,comments,actHC,pName,medRc,pStr,loc,md,dur,attndPhy,cptCode,primaryDiag))
|
| 102 |
|
| 103 |
|
| 104 |
|
| 105 |
##for line in content:
|
| 106 |
##... match = re.search(r'^\d+/\d+/\d+[| ]\d+:\d+(am|pm)?',line)
|
| 107 |
##... line = line.replace("\n","")
|
| 108 |
##... if match:
|
| 109 |
##... line = line.split("|")
|
| 110 |
##... date = line[0]
|
| 111 |
##... time = line[1]
|
| 112 |
##... pName = line[3]
|
| 113 |
##... medRc = line[8]
|
| 114 |
##... desc = line[12]
|
| 115 |
##... if desc:
|
| 116 |
##... pass
|
| 117 |
##... else:
|
| 118 |
##... desc = line[13]
|
| 119 |
##... pStr = line[17]
|
| 120 |
##... if pStr:
|
| 121 |
##... pass
|
| 122 |
##... else:
|
| 123 |
##... pStr = line[21]
|
| 124 |
##... loc = line[20]
|
| 125 |
##... if loc:
|
| 126 |
##... pass
|
| 127 |
##... else:
|
| 128 |
##... loc = line[23]
|
| 129 |
##... md = line[25]
|
| 130 |
##... sts = line[24]
|
| 131 |
##... if sts:
|
| 132 |
##... pass
|
| 133 |
##... else:
|
| 134 |
## sts = line[28]
|
| 135 |
##... outputFile.write("%s|%s|%s|%s|%s|%s|%s|%s|%s\n"%(date,time,pName,medRc,desc,pStr,loc,md,sts))
|
| 136 |
|
| 137 |
|
| 138 |
|
| 139 |
|
| 140 |
if __name__=='__main__':
|
| 141 |
#outputFile = open(r"\\BSTDD967DTW1\Users\eborges\My Documents\Test_dir\wc 2013 (1.1.13-8.26.13) with actual times111.dat",'w')
|
| 142 |
#contents = open(r"\\BSTDD967DTW1\Users\eborges\My Documents\Test_dir\wc 2013 (1.1.13-8.26.13) with actual times111.csv").readlines()
|
| 143 |
outputFile = open(r"W:\Manny\Client\018292-0062\MOSAIQ Schedule Review\MOSAIQ Schedule Review\Concord\2012\REV00000430.dat",'w')
|
| 144 |
contents = open(r"W:\Manny\Client\018292-0062\MOSAIQ Schedule Review\MOSAIQ Schedule Review\Concord\2012\REV00000430.csv").readlines()
|
| 145 |
Parse(contents,outputFile)
|
| 146 |
outputFile.close() |
