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
Sur cette page du site, vous pouvez voir la vidéo en ligne How to read excel file as a Python dictionary durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur برمجه وأكثر بالعربي 15 juillet 2021, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 745 fois et il a aimé 24 téléspectateurs. Bon visionnage!
