Experiment 1(b)

import pandas as pd
newData = pd.read_excel("path")

# New Cell

import xml.etree.ElementTree as ET
import pandas as pd
mytree = ET.parse(r"path.xml")
root = mytree.getroot()
data[]
for note in root.findall("note"):
    department = note.find("department").text
    dep_id = note.findall("dep_id").text
    data.append({"Department Name":department, "Department_ID",dep_id})
df = pd.DataFrame(data)
display(df)

# New Cell

import json
import pandas as pd
with open(r,"path.json","r") as file:
    data = json.load(file)
df = pd.json_normalize(data["salaries"])
display(df)

# New Cell

merged_df = pd.merge(newData, dept_df, on="Department Name", how="left")
merged_df = pd.merge(mergedData, df, on="emp_id", how = "left")
display(merged_df)