Python Forum
[split] Print JSON Dictionary to Excel?
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[split] Print JSON Dictionary to Excel?
#2
Split from https://python-forum.io/Thread-Print-JSO...y-to-Excel

I ran your code and couldn't reproduce the error, here's what I got as output:
Output:
incident_number,division,nature_of_call,priority,date_time,unit_number,block,location,beat,reporting_area,status 19-2084137,Northeast,40/01 - Other,2,2019-11-04T11:09:00.000,B299,8100,Park Ln,211,1062,At Scene 19-2084045,Northeast,40/01 - Other,2,2019-11-04T11:08:00.000,B245,,WALNUT HILL LN / N CENTRAL SERV NB,211,1062,At Scene 19-2084045,Northeast,40/01 - Other,2,2019-11-04T11:08:00.000,B239,,WALNUT HILL LN / N CENTRAL SERV NB,211,1062,At Scene 19-2084126,Northeast,37F - Freeway Blockage,2,2019-11-04T11:07:00.000,B256,,N Central Expy Nb / Walnut Hill Ln,211,1062,At Scene 19-2084146,Southeast,37 - Street Blockage,4,2019-11-04T11:05:00.000,T412,7500,Scyene Rd,321,1235,At Scene 19-2075873,Southeast,7X - Major Accident,1,2019-11-03T01:30:00.000,T245,,Elam Rd / N Prairie Creek Rd,334,2211,At Scene
Reply


Messages In This Thread
RE: [split] Print JSON Dictionary to Excel? - by micseydel - Nov-15-2019, 09:33 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  [split] Parse Nested JSON String in Python mmm07 4 1,550 Mar-28-2023, 06:07 PM
Last Post: snippsat
  Python Split json into separate json based on node value CzarR 1 5,641 Jul-08-2022, 07:55 PM
Last Post: Larz60+
  Converting cells in excel to JSON format desmondtay 4 1,768 May-23-2022, 10:31 AM
Last Post: Larz60+
Question How do I skipkeys on json file read to python dictionary? BrandonKastning 3 1,905 Mar-08-2022, 09:34 PM
Last Post: BrandonKastning
  [split] Results of this program in an excel file eisamabodian 1 1,589 Feb-11-2022, 03:18 PM
Last Post: snippsat
Question How to print each possible permutation in a dictionary that has arrays as values? noahverner1995 2 1,766 Dec-27-2021, 03:43 AM
Last Post: noahverner1995
  excel - json jmabrito 23 6,577 Mar-02-2021, 10:11 PM
Last Post: jmabrito
  saving a dictionary as json file vinay_py 6 3,118 Jun-06-2020, 05:07 PM
Last Post: vinay_py
  [split] script: remove all "carriage return" from my json variable pete 2 2,816 May-05-2020, 03:22 PM
Last Post: deanhystad
  iterate and print json datas enigma619 1 1,935 Apr-01-2020, 11:48 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