Question 109464 in Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Removing items from nested json in Python

I have to manipulate nested json file in way that only one assignment stays.

How it looks now:

import json
a = '''
{
    "tasks": [
        {
            "Assignments": [
                {
                    "EmployeeId": "1000",
                    "TotalWork": 1,
                    "RemainingWork": 1
                },
                {
                    "EmployeeId": "3L2kVk00x",
                    "TotalWork": 1,
                    "RemainingWork": 1
                },
                {
                    "EmployeeId": "3L2kVk00y",
                    "TotalWork": 1,
                    "RemainingWork": 1
                }
            ],
            "TaskId": "487058",
            "Project": 100
        }
    ]
}
'''

data = json.loads(a)

How I want it to look.

{
    "tasks": [
        {
            "Assignments": [
                {
                    "EmployeeId": "1000",
                    "TotalWork": 1,
                    "RemainingWork": 1
                }
            ],
            "TaskId": "487058",
            "Project": 100
        }
    ]
}

I have written some code like this.

data = json.loads(a)
data = data['tasks'][0]['Assignments'].pop(0)
print(json.dumps(data, indent=2))

but the result is incorrect because it looks like this. There should be tasks and assignments before in it.

{
  "EmployeeId": "1000",
  "TotalWork": 1,
  "RemainingWork": 1
}

Can you give me some tips?

Tags:

2

Answers


  1. 0

    Try this approach, re-assigning assignments

    data["tasks"][0]["Assignments"] = [data["tasks"][0]["Assignments"][0]]
print(json.dumps(data, indent=2))

    When working with large JSON data-set and happen to encounter some syntax errors, you might want to validate your JSON data using JSONLint which is one possible way.

    Login or Signup to reply.
  2. 0

    Instead of modifying the input data, it’s probably better to create a new structure based on the criteria as stated in the question.

    The input data has a list as the value for ‘tasks’. Although there is only one element in that list you should allow for an arbitrary size.

    data = json.loads(a)

result = {}

for d in data.get('tasks', []):
    result.setdefault('tasks', []).append({})
    for k, v in d.items():
        if k == 'Assignments':
            for _d in v:
                if _d.get('EmployeeId') == '1000':
                    result['tasks'][-1].setdefault('Assignments', []).append(_d)
        else:
            result['tasks'][-1][k] = v

print(json.dumps(result, indent=2))

    Output:

    {
  "tasks": [
    {
      "Assignments": [
        {
          "EmployeeId": "1000",
          "TotalWork": 1,
          "RemainingWork": 1
        }
      ],
      "TaskId": "487058",
      "Project": 100
    }
  ]
}
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search