How to add new data to JSON file using Pyhton and keep the JSON file format

Free Python Code - Aug 31 '23 - - Dev Community

Hi 🙂🖐

In this post, I will share with you how to add new data to JSON file using Pyhton.

If you have this JSON data in this format, how can we deal with this data in this format? It is not as easy as you think; some programmers, especially beginners, face problems. The problem happened when they started to add new data. In this post, I will share with you an easy way to solve this problem.

This is the JSON file called database.json 

{
    "tasks": [
        {
            "name": "signup and earn 0.20$",
            "description": "signup and earn money",
            "money": 0.2
        },
        {
            "name": "signup and earn 0.10$",
            "description": "signup and earn money",
            "money": 0.1
        },
        {
            "name": "signup and earn 1.20$",
            "description": "signup and earn money",
            "money": 1.2
        }
    ]
}
Enter fullscreen mode Exit fullscreen mode

Now i will to add new data to this file 

import json

tasks = json.load(open('database.json', 'r'))['tasks']

tasks.append({"name": "test", "description": "2222", "money": 1})

json.dump(tasks, open('database.json', 'w'))
Enter fullscreen mode Exit fullscreen mode

As you can see, the JSON format will be damaged. 

[{"name": "signup and earn 0.20$", "description": "signup and earn money", "money": 0.2}, {"name": "signup and earn 0.10$", "description": "signup and earn money", "money": 0.1}, {"name": "signup and earn 1.20$", "description": "signup and earn money", "money": 1.2}, {"name": "test", "description": "2222", "money": 1}]
Enter fullscreen mode Exit fullscreen mode

This happend becuse you write a tasks list to the json file

tasks = json.load(open('database.json', 'r'))['tasks']
print(tasks)
Enter fullscreen mode Exit fullscreen mode

result 

[{'name': 'signup and earn 0.20$', 'description': 'signup and earn money', 'money': 0.2}, {'name': 'signup and earn 0.10$', 'description': 'signup and earn money', 'money': 0.1}, {'name': 'signup and earn 1.20$', 'description': 'signup and 
earn money', 'money': 1.2}, {'name': 'test', 'description': '2222', 'money': 1}]
Enter fullscreen mode Exit fullscreen mode

To keep the JSON file format

import json

tasks = json.load(open('database.json', 'r'))


tasks['tasks'].append({"name": "test", "description": "2222", "money": 1})


json.dump(tasks, open('database.json', 'w'), indent=4)
Enter fullscreen mode Exit fullscreen mode

result 

{
    "tasks": [
        {
            "name": "signup and earn 0.20$",
            "description": "signup and earn money",
            "money": 0.2
        },
        {
            "name": "signup and earn 0.10$",
            "description": "signup and earn money",
            "money": 0.1
        },
        {
            "name": "signup and earn 1.20$",
            "description": "signup and earn money",
            "money": 1.2
        },
        {
            "name": "test",
            "description": "2222",
            "money": 1
        }
    ]
}
Enter fullscreen mode Exit fullscreen mode

Now we're done 🤗

Don't forget to like and follow 🙂

Support me on PayPal 🤗
https://www.paypal.com/paypalme/amr396

Image
C++ Best Practices : Naming Conventions

cpp, convention, language
Image
Unlock New Features: RazorSharp CLI & Dashboard Updates!

dotnet, programming
Image
Backblaze B2: How to store a file

webdev, programming, tutorial, cloud
Image
Machine Learning: The Crystal Ball of Data

devchallenge, cschallenge, computerscience, beginners
Image
Identifiers 101: Understanding and Implementing UUIDs and ULIDs

database, programming, security, computerscience
Image
The Halting Problem

devchallenge, cschallenge, computerscience, beginners
Image
SteamVR Overlay with Unity: Dashboard Overlay

unity3d, steamvr, openvr, vr
Image
Some Standard Sample Text Style Configuration in Figma.

webdev, javascript, ui, figma
Image
SteamVR Overlay with Unity: Draw Camera Output

unity3d, steamvr, openvr, vr
Image
SteamVR Overlay with Unity: Follow Device

unity3d, steamvr, openvr, vr
Image
SteamVR Overlay with Unity: Change Size and Position

unity3d, steamvr, openvr, vr
Image
SteamVR Overlay with Unity: Draw Image

unity3d, steamvr, openvr, vr
Image
GSoC Week 3

gsoc, googlesummerofcode, wagtail, opensource
Image
Getting Started with Flutter: Understanding the Basics and State Management
Image
How to configure Pulumi using YAML Config Files
Image
SteamVR Overlay with Unity: Create Overlay

unity3d, steamvr, openvr, vr
Image
Introduction to Queue Data Structure In JavaScript

datastructures, javascript, beginners, computerscience
Image
Failure Is Not An Option For AI (And It Shouldn't Be)

ai, community, chatgpt
Image
Creative Photography Showcase Slider | Swiper Slider

codepen
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .