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 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     }   ] } 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 }

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
100%

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


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
    }
  ]
}

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
}

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY