Python JSON Tutorial: Parse and Manipulate Data

Tutorial to use Python to load JSON data and parse it. In this video, we learn the different ways we can use JSON data in Python, and we understand how we can use the dict and list data structures to access JSON Data.

This JSON tutorial will help you understand ways you can parse and manipulate data.

[drewbell]

Really good work. Thank you so much!!

[kottakaburlu]

Great content.

I have one real time scenario, since many days trying to resolve but no luck. could you please help me on Python code if possible can you make video


1. source excel book(sheet name is EMP) contain three column ColA, ColB, ColC
2. above excel attribute information (attribute start position, data type, length, scale, precision) coming through Json file(attaching below)


Normally every excel header start from A1 cell and data start from A2 cell but here Header start from B3 cell and data start from B4 cell.

Using read_excel i am able to read excel file but getting null value as Header start from B3. So Based on Json file (header start position, row start position) how to read excel file dynamically. and also need to convert data precision given in json file

Json
{
"templet_master":[
{
"templet_id":1475,
"templet_name":"emp",
"file_loc":"C:\Users\srinu\Desktop\emp.xls",
"file_type":"XLS",
"template_section":[
{
"section_name":"emp",
"skip_rows":0
"header_strt_position":"B3",
"row_strt_position":"B4",
"data_orienttion":"ROW",
"Abstraction_col_name":"sheetname",
"template_attr":[
{
"attri_name":"colA",
"len":8
"dateType":"DATE",
"date_formt":"mmm-yyyy",
},
{
"attri_name":"colb",
"len":100
"dateType":"string",

},
{
"attri_name":"colc",
"len":8
"dateType":"DECIMAL",
"precision":5
}

]
}

]
}
]
}

[fyounan]

what to put between the square brackets [ ] instead a specific position so that it reads all levels of the list/dictionary? should it loop?