<reponame>Solrovivrus/MedicalApp<gh_stars>1-10
import pandas
import json

files = [
    "Central_Montana_Medical_Center",
    "Shodair_Childrens_Hospital",
    "St_Vincent_Healthcare",
    "Great_Falls_Clinic_Hospital",
    "Holy_Rosary_Healthcare",
    "St_Luke_Community_Hospital",
    "Roundup_Memorial_Healthcare",
    "Daniels_Memorial_Hospital",
    "Granite_County_Medical_Center",
    "Poplar_Community_Hospital",
    "St_James_Healthcare",
    "Livingston_Healthcare",
    "Barrett_Hospital_and_Healthcare"
]

for item in files:
    print("Scanning: ", item)
    
    excel_data_df = pandas.read_excel('./machine_readable_files/' + item + '.xlsx', sheet_name=item)

    thisisjson = excel_data_df.to_json(orient='records')


    thisisjson_dict = json.loads(thisisjson)

    with open('./json_files/' + item + '.json', 'w') as json_file:
        json.dump(thisisjson_dict, json_file)

    print("Completed")
    print()

import pandas
import json

files = [
    "Central_Montana_Medical_Center",
    "Shodair_Childrens_Hospital",
    "St_Vincent_Healthcare",
    "Great_Falls_Clinic_Hospital",
    "Holy_Rosary_Healthcare",
    "St_Luke_Community_Hospital",
    "Roundup_Memorial_Healthcare",
    "Daniels_Memorial_Hospital",
    "Granite_County_Medical_Center",
    "Poplar_Community_Hospital",
    "St_James_Healthcare",
    "Livingston_Healthcare",
    "Barrett_Hospital_and_Healthcare"
]

for item in files:
    print("Scanning: ", item)
    
    excel_data_df = pandas.read_excel('./machine_readable_files/' + item + '.xlsx', sheet_name=item)

    thisisjson = excel_data_df.to_json(orient='records')


    thisisjson_dict = json.loads(thisisjson)

    with open('./json_files/' + item + '.json', 'w') as json_file:
        json.dump(thisisjson_dict, json_file)

    print("Completed")
    print()