how to read json file

[snippsat]

A part of problem is that you struggle with basic understating of this
I gone explain in detail under here,if this don't work ask someone to help you local.

i tried to download from your link but after downloading it,i can not open it and my computer

There is no need to open data.json(then you can mess it up if save it),you shall just open colab then File --> New Notebook .
You copy is this code:

# test_read.py
import json
from pprint import pprint
 
with open("data.json", "r") as read_file:
    data = json.load(read_file)
 
pprint(data)

Then on Files left side menu,here you choice upload as in image.
Now find data.json on your hard-drive and upload.
Now push Run Cell button and it should work.

my computer say's look for appropriate program from internet to open such files also i tried to save my data.json

That because you have not JSON set to open in a program file associations.
This is is how it should be you can choice what you want eg basic notepad or better a basic editor like Notepad ++.

last post as .ipynd in file extension but some how that notepad file gets saved in .txt format only not sure what is wrong here.

You most be careful to save in notepad all will be .txt default,have to choice all files the type file name wanted and save.
Why to do talk about .ipynd,do as posted here,
after you get all to work you can download the Notebook the it will in .ipynd format.
Here have i downloaded it and share it with nbviewer My Notebook.

[jk91]

any updates please?

---

any updates please?

please ignore my last follow up post asking for update as i did not see recent reply sorry for that.

but as suggested i again tried to upload data.json text file as a notepad form to colab file-upload new file but again and again receiving same error as attached here.

[snippsat]

This is getting silly you most read what post.
I can get that error to bye doing File --> Upload Notebook.
This is not what you shall do.
Look at image stay away from the top menu line.
It's the menu on the left side Files,then if you take mouse over Upload it say Upload to session storage.
When Push button it open file menu and you have to navigate to data.json on your hard-drive.

[jk91]

This is getting silly you most read what post.
I can get that error to bye doing File --> Upload Notebook.
This is not what you shall do.
Look at image stay away from the top menu line.
It's the menu on the left side Files,then if you take mouse over Upload it say Upload to session storage.
When Push button it open file menu and you have to navigate to data.json on your hard-drive.

when trying to select data.json file from menu on left side files,i can not see my data.json file as shon in attached screen shot for uploding were you able to see that data.json file once you had saved it as a notepad++ file on your desktop and once you tried to select it from this option.?
not sure why i am unable to select it whereas the same is available on my deskop in a notepad++ file.

[jk91]

experts,please advise what is wrong here?

Thanks

[buran]

did you bother to look at @snippsat image? He shows with arrow the Upload that you need to use. How you will see the file before you upload it?

[jk91]

did you bother to look at @snippsat image? He shows with arrow the Upload that you need to use. How you will see the file before you upload it?

in his attached diagram it says first select then upload but for me to select itself file is not getting populated whereas i can see it is there on desktop as a notepad++ file.

[snippsat]

Ohhhhh you have not even done File --> New Notebook still in starting notebook intro.
Shall not select data.json have to upload it as i show with image.
You shall do nothing with the data.json after download other than maybe move to a folder of choice.

Last try here a video from start to finish.

[jk91]

Ohhhhh you have not even done File --> New Notebook still in starting notebook intro.
Shall not select data.json have to upload it as i show with image.
You shall do nothing with the data.json after download other than maybe move to a folder of choice.

Last try here a video from start to finish.

ok,thanks.

but how does it match with my problem,i mean here i have very very complex data model like below:-
Introduction
Someone wants to manage their website. One of
the most important pages on their website is the “Menu” page.The menu gets updated every
night at the restaurant and Joe’s grill wants the updated menu published to their website every
morning. customer will upload their menu in a JSON formatted file (Let’s call it menu.json) to our
ftp server every night.
Requirement is to develop a program to take this menu.json file and store the data
in a relational database. The data model for the database tables is defined as follows.
Data model
items: id(pkey), name
categories: id(pkey), name
category_items: id(pkey), category_id (fkey categories), item_id(fkey items)
menu.json
{
"category”:[{
“name”: “Appetizer”,
},
{
“name”: “Entree”
}
]
],
"item”:[
{
"name":"French Fries",
"category":"Appetizer"
},
{
"name":"Onion Rings",
"category":"Appetizer"
},
{
"name":"Sandwich",
"category":"Entree"
},
{
"name":"Tacos",
"category":"Entree"
},
{
"name":"Ice Cream Sundae",
"category":"Dessert"
}
],
"restaurant":"Joe's Grill"
}
}
Existing classes:
class category:
def __init__(self, name):
self.name = name
class item:
def __init__(self, name, category_name):
self.name = name
self.category_name = category_name
Helper Functions that Already exist
// json.get_categories(file_name) -> returns array of active category objects (category.name)
// json.get_items(file_name) --> returns array of item object (item.name, item.category_name)
// db.write(table_name, <a data dict or an array of data dicts>) //db.write('categories', {'name':
'c1'})
Note:The keys of the dictionary are the table column names, the values are the row values in
the database table

[snippsat]

Use Code Tag,and there is no indentation in code you have posted.
There is mix of two diffent quotation marks in the json sample,that will never work.
"category”

but how does it match with my problem,i mean here i have very very complex data model like below:-

You struggle even with the most basic stuff as usage of OS,files...ect,have you looked into and learned some basic Python?
If this is task you have gotten,ask people who have given it you to help get started.