create dataframe or list with dynamic json records

Question

I am trying to create a dataframe or list that contains within each record a JSON schema that I will later insert through Rest-API. I have a sample that I'm trying to run but it doesn't work, I leave the code:

data_collect = df_res.collect()

for row in data_collect:
  v_id_person = '"' + row["Id"] + '"' 
  i= 1
  data[i] = """{
    "resourceType" : "Example",
    "identifier" : [{ 
            "use" : "official", 
             {
                    "system": "https://example/identif",
                    "code": "CC"
                }
            ] }, 
            "value" : """ +    str(v_id_person)   + """
    } """
  i = i + 1

display(data)

As I mentioned, the previous code does not achieve the objective of creating a list with the JSON structure for each record of the "FOR" cycle

What I want to achieve is:

display(data)
row[1] = {"resourceType" : "Example", "identifier" : [{ ... "value": 5412"
row[2] = {"resourceType" : "Example", "identifier" : [{ ... "value": 432"
row[3] = {"resourceType" : "Example", "identifier" : [{ ... "value": 1112"
...
row[n] = {"resourceType" : "Example", "identifier" : [{ ... "value": v_id_person

" What do you recommend me to do?

From already thank you for your time.

Regards

Can you share your json structure that you want to convert to dataframe ? — Deepak Tripathi
– Deepak Tripathi, Commented Oct 3, 2022 at 18:25
thanks for your answer. I want to add the json structure that appears posted, this for each record in the new dataframe "data", thanks — Gonza
– Gonza, Commented Oct 3, 2022 at 18:26
I am not able to get you. Can you please write what you have and what you want i.e. input, output and expected_output. — Deepak Tripathi
– Deepak Tripathi, Commented Oct 3, 2022 at 18:27

Deepak Tripathi · Accepted Answer · 2022-10-03 19:06:53Z

1

Can you try with this

data = []
for row in data_collect:
  data.append(f"""{{
    "resourceType" : "Example",
    "identifier" : [{{ 
            "use" : "official", 
             {{
                    "system": "https://example/identif",
                    "code": "CC"
                }}
            ] }}, 
            "value" : "{row['Id']}"
    }} """)

edited Oct 3, 2022 at 19:06

answered Oct 3, 2022 at 18:38

Deepak Tripathi

3,2611 gold badge11 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Gonza Over a year ago

thanks you for response. I try to implement you comment, but return error "f-string: expressions nested too deeply". I try resolve this. If you have any other comment, I would appreciate it. Thank you

Deepak Tripathi Over a year ago

@Gonza My bad. I have edited the answer now check

Gonza Over a year ago

Thank you very much for your answer, now I can run as I wanted. I have a query about it: is this that I just created a dataframe? why doesn't it work for me with the display() function but it does with print() ?? Thank you!!

Deepak Tripathi Over a year ago

For that you need to show the display function.

Gonza Over a year ago

because I want to validate the data, since I will create a much larger json. How can I see the structured dataframe type diplsya()? Thanks!

|

Kiran S · Accepted Answer · 2022-10-03 18:32:23Z

0

You can create DataFrame from json using

import pandas as pd
df = pd.read_json("data.json")
print(df)

answered Oct 3, 2022 at 18:32

Kiran S

15810 bronze badges

1 Comment

Gonza Over a year ago

thanks for you response. I've posted an edit to the expected output.

Collectives™ on Stack Overflow

create dataframe or list with dynamic json records

2 Answers 2

8 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related