How do I get the total of balance, except for that accountid and contractoraccountid are not equal and with a condition from data1 and data2

Question

0.00/5 (No votes)

See more:

Data1 =
{
"accounts": [
{
"userLoginKey": "082223”,
"accountId": "j5j556f"
},
{
"userLoginKey": "097644”,
"accountId": "qx954fjg"
},
{
"userLoginKey": "089675”,
"accountId": “h54ub5”
},
{
"userLoginKey": "084575",
"accountId": “jfh9nh5”
},
{
"userLoginKey": "088838",
"accountId": "i6kn6j"
}
]
}

Data2 =
{
"finance_assets": [
{
"contractorAccountId": “j5j556f”,
"balance": 3999
},
{
"contractorAccountId": “qx954fjg”,
"balance": 3084775
},
{
"contractorAccountId": “khojoh7”,
"balance": 1000000 -
},
{
"contractorAccountId": "h54ub5",
"balance": 113578277
},
{
"contractorAccountId": “jngi408”,
"balance": 31116496 -
},
{
"contractorAccountId": "jfh9nh5",
"balance": 5
},
{
"contractorAccountId": “njvgj54g”,
"balance": 22
},
{
"contractorAccountId": "i6kn6j",
"balance": 3000
},
{
"contractorAccountId": "qx954fjg",
"balance": 1200
}
]
}

What I have tried:

Python: How do I get the total of balance, except for that accountId and contractorAccountId are not equal and with a condition
From Data1 and Data2

The desired output1:
How do I get the total of balance, except for that accountId and contractorAccountId are not equal?

{
"total_Assets": 116671278
}

The desired output2:
Please adjust the output so that the total assets of the top 10 (can be specified) can also be output.
For example: 3999 3084775 113578277 5 22 3000 1200
→ 5 < 22 < 1200 < 3000 < 3999 < 3084775 < 113578277 if getting the total of top4
→ 113578277 + 3084775 + 3999 + 3000
= 116670051
So, it should be like this:

{
"total_Assets": 116670051
}

Posted 24-Mar-22 16:00pm

Kota6543

Updated 24-Mar-22 21:36pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CPallini · Accepted Answer · 2022-03-24T21:36:00

Try

Python

import json

Data1 = """{
  "accounts": [{
      "userLoginKey": "082223",
      "accountId": "j5j556f"
    },
    {
      "userLoginKey": "097644",
      "accountId": "qx954fjg"
    },
    {
      "userLoginKey": "089675",
      "accountId": "h54ub5"
    },
    {
      "userLoginKey": "084575",
      "accountId": "jfh9nh5"
    },
    {
      "userLoginKey": "088838",
      "accountId": "i6kn6j"
    }
  ]
}"""

Data2 = """ {
  "finance_assets": [{
      "contractorAccountId": "j5j556f",
      "balance": 3999
    },
    {
      "contractorAccountId": "qx954fjg",
      "balance": 3084775
    },
    {
      "contractorAccountId": "khojoh7",
      "balance": -1000000
    },
    {
      "contractorAccountId": "h54ub5",
      "balance": 113578277
    },
    {
      "contractorAccountId": "jngi408",
      "balance": -31116496
    },
    {
      "contractorAccountId": "jfh9nh5",
      "balance": 5
    },
    {
      "contractorAccountId": "njvgj54g",
      "balance": 22
    },
    {
      "contractorAccountId": "i6kn6j",
      "balance": 3000
    },
    {
      "contractorAccountId": "qx954fjg",
      "balance": 1200
    }
  ]
}"""

# parse the JSON strings into Python data
acc = json.loads(Data1)
ass = json.loads(Data2)

# list of account Ids
aid = [ x.get('accountId') for  x in acc.get('accounts') ]

# list of balances, filtering in only contractorId correponding to aid items
bal = [ x.get('balance') for x in ass.get('finance_assets') if x.get('contractorAccountId') in aid]

# sum of the balances
total_assets = sum(bal)
print(total_assets)