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
Auf dieser Seite können Sie das Online-Video How to read excel file as a Python dictionary mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer برمجه وأكثر بالعربي 15 Juli 2021 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 745 Mal angesehen und es wurde von 24 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
