| 1 |
'''
|
| 2 |
In this narco request, they asked that I take a file that had the patient and the 9 questions on 9 sep lines. So I consolidated the
|
| 3 |
patient info (which repeated on each line) and made it so that all 9 questions were on the same line, with full patient info
|
| 4 |
'''
|
| 5 |
|
| 6 |
contents = open(r"\\bstads01\app\Manny\Cases\Honeywell - Narco_(037354-0021)\NNT Not Prequal Nonmalignant 06102014.csv").readlines()
|
| 7 |
>>> contents = contents[1:]
|
| 8 |
>>> len(contents)
|
| 9 |
507456
|
| 10 |
>>> patMatrix = {}
|
| 11 |
>>> for line in contents:
|
| 12 |
... line = line.replace("\n","")
|
| 13 |
... ss = line.split("|")[5]
|
| 14 |
... if ss in patMatrix.keys():
|
| 15 |
... patMatrix[ss].append(line)
|
| 16 |
... else:
|
| 17 |
... patMatrix[ss] = [line,]
|
| 18 |
...
|
| 19 |
>>> len(patMatrix.keys())
|
| 20 |
56384
|
| 21 |
>>> ssList = patMatrix.keys()
|
| 22 |
>>> ssList.sort()
|
| 23 |
>>> outputFile = open(r"C:\Users\eborges\Desktop\Working\Honeywell\Narco\NNT Not Prequal Nonmalignant 06102014_Output.dat",'w')
|
| 24 |
>>> outputFile.write("uid|Firm|uid|AffiliateabbrDelete|Claim|ssn|Match to NNT Prequal|Claimant|Question 1|Question 2|Question 3|Question 4|Question 5|Question 6|Question 7|Question 8|Question 9|Cond|Jurisdiction|ddodeath\n")
|
| 25 |
>>> ssList[0]
|
| 26 |
'001-05-6133'
|
| 27 |
>>> patMatrix[ssList[0]]
|
| 28 |
['290696|NNT|29|THO|163858|001-05-6133|#N/A|MacKinnon, Louis P|1|Y|Nonmalignant||NH|7/11/1983', '290696|NNT|29|THO|163858|001-05-6133|#N/A|MacKinnon, Louis P|2|Y|Nonmalignant||NH|7/11/1983', '290696|NNT|29|THO|163858|001-05-6133|#N/A|MacKinnon, Louis P|3|Not Applicable|Nonmalignant||NH|7/11/1983', '290696|NNT|29|THO|163858|001-05-6133|#N/A|MacKinnon, Louis P|4|Y|Nonmalignant||NH|7/11/1983', '290696|NNT|29|THO|163858|001-05-6133|#N/A|MacKinnon, Louis P|5|Y|Nonmalignant||NH|7/11/1983', '290696|NNT|29|THO|163858|001-05-6133|#N/A|MacKinnon, Louis P|6|11/7/1978|Nonmalignant||NH|7/11/1983', '290696|NNT|29|THO|163858|001-05-6133|#N/A|MacKinnon, Louis P|7|Y|Nonmalignant||NH|7/11/1983', '290696|NNT|29|THO|163858|001-05-6133|#N/A|MacKinnon, Louis P|8|Benson L. Eisenberg|Nonmalignant||NH|7/11/1983', '290696|NNT|29|THO|163858|001-05-6133|#N/A|MacKinnon, Louis P|9|Y|Nonmalignant||NH|7/11/1983']
|
| 29 |
|
| 30 |
>>> for ss in ssList:
|
| 31 |
... mainLine = patMatrix[ss][0].split("|")
|
| 32 |
... q1 = patMatrix[ss][0].split("|")[9]
|
| 33 |
... q2 = patMatrix[ss][1].split("|")[9]
|
| 34 |
... q3 = patMatrix[ss][2].split("|")[9]
|
| 35 |
... q4 = patMatrix[ss][3].split("|")[9]
|
| 36 |
... q5 = patMatrix[ss][4].split("|")[9]
|
| 37 |
... q6 = patMatrix[ss][5].split("|")[9]
|
| 38 |
... q7 = patMatrix[ss][6].split("|")[9]
|
| 39 |
... q8 = patMatrix[ss][7].split("|")[9]
|
| 40 |
... q9 = patMatrix[ss][8].split("|")[9]
|
| 41 |
... outputFile.write("%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s|%s\n"%(mainLine[0],mainLine[1],mainLine[2],mainLine[3],mainLine[4],mainLine[5],mainLine[6],mainLine[7],q1,q2,q3,q4,q5,q6,q7,q8,q9,mainLine[10],mainLine[12],mainLine[13]))
|
| 42 |
...
|
| 43 |
>>> outputFile.close()
|
| 44 |
>>> |
