RadialAnalyticsExercise/HeaderStrip.py at master · sckohen/RadialAnalyticsExercise · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
import csv

def strip_header():
    input_file_name = "Hospital General Information.csv"
    output_file_name = "HGI.csv"

    with open(input_file_name, 'r') as inFile, open(output_file_name, 'w') as outfile:
        r = csv.reader(inFile)
        w = csv.writer(outfile)

        next(r)

        w.writerow(['ProviderID', 'HospitalName', 'Address', 'City', 'State', 'ZIPCode',
                    'CountyName', 'PhoneNumber', 'HospitalType', 'HospitalOwnership',
                    'EmergencyServices', 'MeetscriteriaformeaningfuluseofEHRs',
                    'Hospitaloverallrating', 'Hospitaloverallratingfootnote',
                    'Mortalitynationalcomparison',
                    'Mortalitynationalcomparisonfootnote',
                    'Safetyofcarenationalcomparison',
                    'Safetyofcarenationalcomparisonfootnote',
                    'Readmissionnationalcomparison',
                    'Readmissionnationalcomparisonfootnote',
                    'Patientexperiencenationalcomparison',
                    'Patientexperiencenationalcomparisonfootnote',
                    'Effectivenessofcarenationalcomparison',
                    'Effectivenessofcarenationalcomparisonfootnote',
                    'Timelinessofcarenationalcomparison',
                    'Timelinessofcarenationalcomparisonfootnote',
                    'Efficientuseofmedicalimagingnationalcomparison',
                    'Efficientuseofmedicalimagingnationalcomparisonfootnote'])

        # copy the rest
        for row in r:
            w.writerow(row)


if __name__ == '__main__':
   strip_header()