Python Forum
Need help in python scripting
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Need help in python scripting
#5
import json
import csv


with open('/local/dummy.json') as f:
    json_data = json.load(f, strict=False)

with open('/local/application.csv', 'w') as outfile:
    csv_write = csv.writer(outfile)
    csv_write.writerow(["id", "SID", "Type", "ttt"])
    for x in json_data["dummy"]:
        try:
            row = x["id"], x["salary"][0]["SID"], x["ttt111"][0]["ttt"], x["ttt111"][0]["S"]
        except KeyError:
            # skip this row?
            # using a default fill value?
            continue # continue with next iteration, won't write the row
        csv_write.writerow(row)
Don't ask for permission, ask for forgiveness.
The try-except block handles the error. You can decide what you want to do, if the key does not exist.

Instead of re-opening the csv-file the whole time for only one row is inefficient.
Use the file-object outfile in the with-block instead. As long the for-loop is inside the with-block,
the file is still open and it would write.

By the way, why are you setting the default encoding?
A reload of sys direct after importing it, does not change anything.
Almost dead, but too lazy to die: https://sourceserver.info
All humans together. We don't need politicians!
Reply


Messages In This Thread
Need help in python scripting - by rajrishi990 - Nov-25-2019, 02:13 PM
RE: Need help in python scripting - by ichabod801 - Nov-25-2019, 03:44 PM
RE: Need help in python scripting - by rajrishi990 - Nov-26-2019, 06:25 AM
RE: Need help in python scripting - by rajrishi990 - Nov-26-2019, 09:35 AM
RE: Need help in python scripting - by DeaD_EyE - Nov-26-2019, 11:24 AM
RE: Need help in python scripting - by rajrishi990 - Nov-26-2019, 12:32 PM
RE: Need help in python scripting - by DeaD_EyE - Nov-26-2019, 12:51 PM
RE: Need help in python scripting - by rajrishi990 - Nov-26-2019, 01:24 PM
RE: Need help in python scripting - by DeaD_EyE - Nov-26-2019, 03:23 PM
RE: Need help in python scripting - by rajrishi990 - Nov-26-2019, 03:46 PM
RE: Need help in python scripting - by rajrishi990 - Nov-27-2019, 03:51 AM
RE: Need help in python scripting - by rajrishi990 - Nov-27-2019, 07:12 AM
RE: Need help in python scripting - by buran - Nov-27-2019, 09:03 AM
RE: Need help in python scripting - by rajrishi990 - Nov-27-2019, 09:12 AM
RE: Need help in python scripting - by buran - Nov-27-2019, 09:27 AM
RE: Need help in python scripting - by rajrishi990 - Nov-27-2019, 09:28 AM
RE: Need help in python scripting - by DeaD_EyE - Nov-27-2019, 11:56 AM
RE: Need help in python scripting - by buran - Nov-27-2019, 12:04 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Blender scripting the_jl_zone 0 493 Jul-10-2023, 08:48 PM
Last Post: the_jl_zone
  Python Scripting Environment jpotter0 1 1,786 Nov-19-2022, 03:07 PM
Last Post: snippsat
  Scripting: Multiple Votes With a Single Click or Button Ovidiu 0 1,412 Jul-07-2020, 10:51 AM
Last Post: Ovidiu
  Abaqus Python Scripting..Key error maddy 0 4,833 May-19-2018, 08:05 AM
Last Post: maddy
  Network scripting bsoth 1 2,691 Feb-06-2018, 01:41 AM
Last Post: wavic

Forum Jump:

User Panel Messages

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