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
In questa pagina del sito puoi guardare il video online How to read excel file as a Python dictionary della durata di ore minuti seconda in buona qualità , che l'utente ha caricato برمجه وأكثر بالعربي 15 luglio 2021, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 745 volte e gli è piaciuto 24 spettatori. Buona visione!
