I was hoping that someone here may be able to help me. I would like to map to entities together from a json file and use them as headers in a pandas data frame. For example, I would like to first map the two objects in the picture below:
As you can see in the json file, I want to map the 'file_name' to the 'entity_submitter_id' then I would like to display the 'entity_submitter_id' to the column headers in my data frame. I have tried the following code to try and reproduce this below:
When I print the head of the data frame, you can see the column headers are a mix of characters. Can anyone share how I can change those headers to the 'entity_submiter_id' in the json file? Your help would be much appreciated. Thanks in advance for any help!