Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
how to read json file
#13
(Feb-20-2020, 12:07 PM)snippsat Wrote:
(Feb-20-2020, 11:20 AM)jk91 Wrote: how should i make it according to my case also i just have eclispse software installed on my system
Use PyDev
PyDev Wrote:PyDev is a Python IDE for Eclipse

(Feb-20-2020, 11:20 AM)jk91 Wrote: i also tried to execute above code in colab but again it ended in error:-
You shall not use it like this,i do it in two parts read file then doing some test in interactive interpreter >>>.
The task will be hard without any basic knowledge of Python.

Here is what's in data.json test file.
Output:
{ "firstName": "Jane", "lastName": "Doe", "hobbies": [ "running", "sky diving", "singing" ], "age": 35, "children": [ { "firstName": "Alice", "age": 6 }, { "firstName": "Bob", "age": 8 } ] }
# test_read.py
import json
from pprint import pprint

with open("data.json", "r") as read_file:
    data = json.load(read_file)

pprint(data)
Output:
{'age': 35, 'children': [{'age': 6, 'firstName': 'Alice'}, {'age': 8, 'firstName': 'Bob'}], 'firstName': 'Jane', 'hobbies': ['running', 'sky diving', 'singing'], 'lastName': 'Doe'}
So now reading as a script test_read.py and run it,and i have to print the content.

Doing test in interactive interpreter >>>,i do not need print.
>>> data
{'age': 35,
 'children': [{'age': 6, 'firstName': 'Alice'}, {'age': 8, 'firstName': 'Bob'}],
 'firstName': 'Jane',
 'hobbies': ['running', 'sky diving', 'singing'],
 'lastName': 'Doe'}
>>> 
>>> data['hobbies']
['running', 'sky diving', 'singing']
>>> ', '.join(data['hobbies'])
'running, sky diving, singing'

# Can also use print here
>>> print(', '.join(data['hobbies']))
running, sky diving, singing
>>> 

if i just download pydev ide will it not require to install python separately also i am on windows 7 32 bit and tried to install sp1 for it but it's getting failed so alternatively someone advised me to use colab.
so with colab can't i just test above all?

(Feb-20-2020, 02:06 PM)jk91 Wrote:
(Feb-20-2020, 12:07 PM)snippsat Wrote: Use PyDev

You shall not use it like this,i do it in two parts read file then doing some test in interactive interpreter >>>.
The task will be hard without any basic knowledge of Python.

Here is what's in data.json test file.
Output:
{ "firstName": "Jane", "lastName": "Doe", "hobbies": [ "running", "sky diving", "singing" ], "age": 35, "children": [ { "firstName": "Alice", "age": 6 }, { "firstName": "Bob", "age": 8 } ] }
# test_read.py
import json
from pprint import pprint

with open("data.json", "r") as read_file:
    data = json.load(read_file)

pprint(data)
Output:
{'age': 35, 'children': [{'age': 6, 'firstName': 'Alice'}, {'age': 8, 'firstName': 'Bob'}], 'firstName': 'Jane', 'hobbies': ['running', 'sky diving', 'singing'], 'lastName': 'Doe'}
So now reading as a script test_read.py and run it,and i have to print the content.

Doing test in interactive interpreter >>>,i do not need print.
>>> data
{'age': 35,
 'children': [{'age': 6, 'firstName': 'Alice'}, {'age': 8, 'firstName': 'Bob'}],
 'firstName': 'Jane',
 'hobbies': ['running', 'sky diving', 'singing'],
 'lastName': 'Doe'}
>>> 
>>> data['hobbies']
['running', 'sky diving', 'singing']
>>> ', '.join(data['hobbies'])
'running, sky diving, singing'

# Can also use print here
>>> print(', '.join(data['hobbies']))
running, sky diving, singing
>>> 


if i just download pydev ide will it not require to install python separately also i am on windows 7 32 bit and tried to install sp1 for it but it's getting failed so alternatively someone advised me to use colab.
so with colab can't i just test above all?

also where do we save that data.json test file?also what is the type we give it while saving it and what should be the location of aving it and can we save it it in plain note pad text file?
Reply


Messages In This Thread
how to read json file - by jk91 - Feb-18-2020, 11:48 AM
RE: how to read json file - by Larz60+ - Feb-18-2020, 06:02 PM
RE: how to read json file - by ndc85430 - Feb-18-2020, 06:10 PM
RE: how to read json file - by jk91 - Feb-19-2020, 05:44 AM
RE: how to read json file - by ndc85430 - Feb-19-2020, 06:41 AM
RE: how to read json file - by jk91 - Feb-19-2020, 07:28 AM
RE: how to read json file - by jk91 - Feb-20-2020, 06:17 AM
RE: how to read json file - by jk91 - Feb-20-2020, 09:18 AM
RE: how to read json file - by buran - Feb-20-2020, 09:40 AM
RE: how to read json file - by snippsat - Feb-20-2020, 10:03 AM
RE: how to read json file - by jk91 - Feb-20-2020, 11:20 AM
RE: how to read json file - by snippsat - Feb-20-2020, 12:07 PM
RE: how to read json file - by jk91 - Feb-20-2020, 02:10 PM
RE: how to read json file - by snippsat - Feb-20-2020, 02:38 PM
RE: how to read json file - by jk91 - Feb-23-2020, 06:37 AM
RE: how to read json file - by snippsat - Feb-23-2020, 10:49 AM
RE: how to read json file - by jk91 - Feb-23-2020, 11:03 AM
RE: how to read json file - by snippsat - Feb-23-2020, 12:06 PM
RE: how to read json file - by jk91 - Feb-23-2020, 01:17 PM
RE: how to read json file - by jk91 - Feb-23-2020, 02:24 PM
RE: how to read json file - by snippsat - Feb-23-2020, 03:30 PM
RE: how to read json file - by jk91 - Feb-23-2020, 04:26 PM
RE: how to read json file - by snippsat - Feb-23-2020, 04:50 PM
RE: how to read json file - by jk91 - Feb-24-2020, 11:56 AM
RE: how to read json file - by jk91 - Feb-24-2020, 01:15 PM
RE: how to read json file - by buran - Feb-24-2020, 01:28 PM
RE: how to read json file - by jk91 - Feb-24-2020, 01:38 PM
RE: how to read json file - by snippsat - Feb-24-2020, 01:45 PM
RE: how to read json file - by jk91 - Feb-24-2020, 06:22 PM
RE: how to read json file - by snippsat - Feb-24-2020, 07:45 PM
RE: how to read json file - by jk91 - Feb-25-2020, 04:11 PM
RE: how to read json file - by t4keheart - Feb-25-2020, 02:08 PM
RE: how to read json file - by t4keheart - Feb-25-2020, 06:24 PM
RE: how to read json file - by jk91 - Feb-26-2020, 08:10 AM
RE: how to read json file - by snippsat - Feb-26-2020, 05:07 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to read a file as binary or hex "string" so that I can do regex search? tatahuft 3 1,328 Dec-19-2024, 11:57 AM
Last Post: snippsat
  Read TXT file in Pandas and save to Parquet zinho 2 1,408 Sep-15-2024, 06:14 PM
Last Post: zinho
  JSON File - extract only the data in a nested array for CSV file shwfgd 2 1,191 Aug-26-2024, 10:14 PM
Last Post: shwfgd
  Pycharm can't read file Genericgamemaker 5 1,785 Jul-24-2024, 08:10 PM
Last Post: deanhystad
  Python is unable to read file Genericgamemaker 13 4,310 Jul-19-2024, 06:42 PM
Last Post: snippsat
  Connecting to Remote Server to read contents of a file ChaitanyaSharma 1 3,504 May-03-2024, 07:23 AM
Last Post: Pedroski55
  encrypt data in json file help jacksfrustration 1 2,410 Mar-28-2024, 05:16 PM
Last Post: deanhystad
  Recommended way to read/create PDF file? Winfried 3 5,395 Nov-26-2023, 07:51 AM
Last Post: Pedroski55
  parse json field from csv file lebossejames 4 2,174 Nov-14-2023, 11:34 PM
Last Post: snippsat
  python Read each xlsx file and write it into csv with pipe delimiter mg24 4 4,104 Nov-09-2023, 10:56 AM
Last Post: mg24

Forum Jump:

User Panel Messages

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