Handle xlsx & JSON files (structured data) with Python

Published: 24 August 2022
on channel: Hydro-Morphodynamics
74
0

Create, read, and modify structured (XML and JSON) data with Python and materials provided at https://hydro-informatics.com/jupyter...

The jupyter notebooks can be git-cloned (or zip-downloaded) from the course repository: https://github.com/hydro-informatics/...

This tutorial uses the jupyter notebook named b10-xmls.ipynb in the course repository.

Lecturer: Sebastian Schwindt


-- Contents of this video --
00:00:33 - Structured data overview
00:02:03 - Workbook (xlsx) handling basics
00:09:05 - Read (open) and modify an existing workbook
00:18:04 - Read columns function
00:20:07 - Workbook formulae
00:22:32 - Plots and charts
00:25:41 - Custom classes for workbook manipulation
00:28:38 - Example for when to combine Python with workbooks in water resources research
00:30:21 - JSON files and the json package
00:35:35 - Manipulate JSON files with pandas
00:37:27 - Modify a JSON file


On this page of the site you can watch the video online Handle xlsx & JSON files (structured data) with Python with a duration of hours minute second in good quality, which was uploaded by the user Hydro-Morphodynamics 24 August 2022, share the link with friends and acquaintances, this video has already been watched 74 times on youtube and it was liked by 0 viewers. Enjoy your viewing!