Singlefile_CRF_1.py

import pandas as pd
import json
import os

# Initialize the dictionary template
json_template = {
    "performing_site": "",
    "subject_id": "",
    "experimenter_name": "",
    "experiment_date": "",
    "experiment_time": "",
    "eyetracker_calibration_quality": "",
    "errors_problems_setup": "",
    "practice_quantity": "",
    "notes_run_1": "",
    "notes_run_2": "",
    "notes_run_3": "",
    "notes_run_4": "",
    "notes_run_5": "",
    "notes_run_6": "",
    "notes_run_7": "",
    "notes_run_8": "",
    "notes_t1": "",
    "errors_problems_after_scanning": ""
}

item_to_json_key = {
    "Performing site": "performing_site",
    "Subject ID": "subject_id",
    "Experimenter Name": "experimenter_name",
    "Experiment Date": "experiment_date",
    "Experiment_time": "experiment_time",
    "Eyetracker calibration quality": "eyetracker_calibration_quality",#
    "Errors/Problems: Setup": "errors_problems_setup",
    "Practice quantity": "practice_quantity",
    "Notes: Run1": "notes_run_1",
    "Notes: Run2": "notes_run_2",
    "Notes: Run3": "notes_run_3",
    "Notes: Run4": "notes_run_4",
    "Notes: Run5": "notes_run_5",
    "Notes: Run6": "notes_run_6",
    "Notes: Run7": "notes_run_7",
    "Notes: Run8": "notes_run_8",
    "Notes: T1": "notes_t1",
    "Errors/Problems after scanning": "errors_problems_after_scanning"
}

# Excel File Path
excel_path = "C:/Users/kyle.kahraman/Seafile/shared_Kyle_Prav/FMRI_subjects/SC101/SC101_CRF_V1.xlsx"
df = pd.read_excel(excel_path, names=['Item', 'Value'])

# Iterate through the DataFrame to populate the JSON template
for index, row in df.iterrows():
    item = row['Item']
    value = row['Value']
    json_key = item_to_json_key.get(item, None)
    if json_key:
        json_template[json_key] = value

# Save the populated JSON to a file
output_json_file = "c:/users/kyle.kahraman/Seafile/shared_Kyle_Prav/scripts/kyle work in progress/FMRI Population/CRF_1_FMRI.json"
with open(output_json_file, 'w') as json_file:
    json.dump(json_template, json_file, indent=4)

print("JSON file has been created.")