Python Forum
Not Getting the Desired value using json.dumps
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Not Getting the Desired value using json.dumps
#1
I am Trying to make a small code which will take values from excel and make a json file . I get the desired output except 1 issue . Below is my Code
**********************
import json
from openpyxl import load_workbook
print("")
path = "output.xlsx"
wb=load_workbook(path)
Sheet1 = wb.active
max_row=Sheet1.max_row
max_column=Sheet1.max_column
for i in range(2, max_column+1):
    listing = []
    for j in range(2, max_row+1):
         dictonery =  {}
         dictonery["ParameterKey"] = (Sheet1.cell(j,1)).value
         dictonery["ParameterValue"] = (Sheet1.cell(j,i)).value
         listing.append(dictonery)     

    print(json.dumps(listing,indent = 4, sort_keys=True))
**********************************
output i am getting for print(listing):
Output:
print(listing) [{'ParameterKey': 'SGASSNTCode', 'ParameterValue': 'test'}, {'ParameterKey': 'SGASCustomer', 'ParameterValue': 'testcompany'}, {'ParameterKey': 'OSName', 'ParameterValue': 'Ubuntu 18.04 LTS'}, {'ParameterKey': 'Hostname', 'ParameterValue': 'testhostname'}, {'ParameterKey': 'SubnetId', 'ParameterValue': 'subnet-0b33e'}, {'ParameterKey': 'SecurityGroupIds', 'ParameterValue': 'sg-05c21ea8,sg-063a770507,sg-0c259b8d,sg-026e2d7b5a'}, {'ParameterKey': 'InstanceType', 'ParameterValue': 'm5.large'}, {'ParameterKey': 'KeyPairName', 'ParameterValue': 'TestPair'}, {'ParameterKey': 'RootVolumeSize', 'ParameterValue': '""'}]
*************************************************
Till here everything is good
As you see above The last ParameterValue is "" but
But when i run the last line i.e print(json.dumps(listing,indent = 4, sort_keys=True))
the last ParameterValue i am getting "\"\"" (Below Output)
Below is the output of print(json.dumps(listing,indent = 4, sort_keys=True))
**************************************************
Output:
[ { "ParameterKey": "SGASSNTCode", "ParameterValue": "test" }, { "ParameterKey": "SGASCustomer", "ParameterValue": "testcompany" }, { "ParameterKey": "OSName", "ParameterValue": "Ubuntu 18.04 LTS" }, { "ParameterKey": "Hostname", "ParameterValue": "testhostname" }, { "ParameterKey": "SubnetId", "ParameterValue": "subnet-0b33e" }, { "ParameterKey": "SecurityGroupIds", "ParameterValue": "sg-05c21ea8,sg-063a770507,sg-0c259b8d,sg-026e2d7b5a" }, { "ParameterKey": "InstanceType", "ParameterValue": "m5.large" }, { "ParameterKey": "KeyPairName", "ParameterValue": "TestPair" }, { "ParameterKey": "RootVolumeSize", "ParameterValue": "\"\"" } ]
The JSON Output i need is with last ParamterValue as "" only . can some please helpme ?
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Json filter is not capturing desired key/element mrapple2020 1 1,072 Nov-24-2022, 09:22 AM
Last Post: ibreeden
  how can I display only desired items? 3lnyn0 5 1,973 Dec-25-2021, 06:49 PM
Last Post: menator01
  ERROR: importing desired module mbgamer28 0 1,648 Apr-05-2021, 07:46 PM
Last Post: mbgamer28
  Not rounding to desired decimal places? pprod 2 2,502 Mar-05-2021, 11:11 AM
Last Post: pprod
  Why this code not getting desired output ? MDRI 2 2,485 Sep-18-2020, 02:11 AM
Last Post: MDRI
  showing only desired part of a plot grknkilicaslan 1 2,291 Jul-10-2020, 03:51 PM
Last Post: Marbelous
  json.dumps list output qurr 12 5,063 Apr-08-2020, 10:13 PM
Last Post: micseydel
  [Beginner] Code is not producing desired result fakej171 2 2,379 Mar-21-2020, 10:26 AM
Last Post: buran
  json.dumps output error in python3 prayuktibid 2 2,613 Jan-21-2020, 06:41 AM
Last Post: prayuktibid
  json.dumps to keep dictionary keys batchenr 1 1,987 May-14-2019, 11:17 AM
Last Post: buran

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020