How to read excel file as a Python dictionary
The video explain how to read excel file and deal with its data as a Python dictionary. You will learn how to convert the stream of the bytes from the file to a Python object (Dictionary) through the Deserialization. The example use the load method from the JSON module to deserialize the python file to a python dictionary. Also you will learn how to access a specific values through their keys.
🕐Time Stamps
00:20 What is JSON?
01:36 Excel file vs JSON file
02:05 How to retrieve data from excel file
02:38 What is Comma Separated File .csv?
03:23 How to save excel file as .csv file?
04:35 How to convert JSON file to CSV file
05:50 Open JSON file in visual studio code
06:56 JSON module in Python
07:40 How to make serialization and deserialization through JSON module
08:08 How to deserialize using load in Python
08:15 Python program to deserialize JSON file to Python dictionary
08:55 How to convert JSON file to an object (list of dictionaries)
09:05 How to read the dictionaries from JSON file
09:40 How to retrieve specific data depending on if condition
10:22 How to print the object type in Python
On this page of the site you can watch the video online How to read excel file as a Python dictionary with a duration of hours minute second in good quality, which was uploaded by the user برمجه وأكثر بالعربي 15 July 2021, share the link with friends and acquaintances, this video has already been watched 745 times on youtube and it was liked by 24 viewers. Enjoy your viewing!
