Python Pandas: Dataframe to_json not index oriented

Question

The default Dataframe.to_json() exports like this:

{
    "date": {
        "0": Example_date1,
        "1": Example_date2
    }
    "name": {
        "0": Example_name1,
        "1": Example_name2,
    }
}

I want the json to be document oriented for MongoDB, like this:

{
    {
        "date": Example_date1,
        "name": Example_name1
    }
    {
        "date": Example_date2,
        "name": Example_name2,
    }
}

I got this problem, because I want to read data from MongoDB database and when I load into a Dataframe, it gets only one line. I think it's better to send a json document oriented. I am new to working with MongoDB and NoSQL structures, so if you have a suggestion I'd be happy to read it.

Please do not upload images of code/data/errors. Please edit your question to include your DataFrame as text in code fences instead. You might find this guide useful. — Anerdw
– Anerdw, Commented Jul 30, 2024 at 14:50

José Daniel Montoya Salazar · Accepted Answer · 2024-07-30 16:34:44Z

0

If you use .to_dict(orient="records") you get this output:

[
    {'date': 'Example_date1', 'name': 'Example_name1'}, 
    {'date': 'Example_date2', 'name': 'Example_name2'}
]

If you really needed the mentioned format then I suggest this:

dict_df = df.to_dict(orient="records")
formatted_dict = str(dict_df).replace("[", "{").replace("]", "}")

answered Jul 30, 2024 at 16:34

José Daniel Montoya Salazar

828 bronze badges

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

Collectives™ on Stack Overflow

Python Pandas: Dataframe to_json not index oriented

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related