Download "Using Fabric notebooks (pySpark) to clean and transform real-world JSON data"
%3Aformat(webp)%2Fi.ytimg.com%252Fvi_webp%252F4S-IocL9Glo%252Fmaxresdefault.webp&w=1139&q=75)
Table of contents
Similar videos from our catalog
%3Aformat(webp)%2Fi.ytimg.com%252Fvi_webp%252F7zrn149sniY%252Fmaxresdefault.webp&w=1139&q=75)
%3Aformat(webp)%2Fi.ytimg.com%252Fvi_webp%252FYaTh5R85Cn0%252Fmaxresdefault.webp&w=1139&q=75)
%3Aformat(webp)%2Fi.ytimg.com%252Fvi_webp%252Fjrcr28HGtEA%252Fmaxresdefault.webp&w=1139&q=75)
%3Aformat(webp)%2Fi.ytimg.com%252Fvi%252FloqqVPZ1KYM%252Fmaxresdefault.jpg&w=1139&q=75)
%3Aformat(webp)%2Fi.ytimg.com%252Fvi_webp%252FsFVNmTZ5h4Y%252Fmaxresdefault.webp&w=1139&q=75)
%3Aformat(webp)%2Fi.ytimg.com%252Fvi%252FBjk93hi21QM%252Fmaxresdefault.jpg&w=1139&q=75)
Video tags
Description:
10+ hours of FREE Fabric Training: https://www.skool.com/microsoft-fabric/classroom/d154aad4?md=3b108b0e216c46c88d891407ccd8647b #dataengineering #python #microsoftfabric In this video, I make use of Microsoft Fabric's data engineering experience - specifically the Synapse Data Engineering Notebooks (pySpark engine) to read a JSON file in our Lakehouse Files area, parse the JSON structure, clean the data a bit, transform some of the columns and then LOAD the data into a nice Lakehouse Table. This video follows on from my last video, in which I extracted data from an external weather API, using Data Pipelines in Microsoft Fabric, then loaded the raw JSON into Lakehouse Files. https://youtu.be/7zrn149sniY Next parts of the series include: - Data validation of pySpark dataframes in Fabric using Great Expectations - Visualising the weather data in Power BI. --LINK TO OPENWEATHERMAP-- Here's the API used in this tutorial: https://openweathermap.org/api --OTHER VIDEOS YOU MIGHT LIKE-- LAKEHOUSE - https://youtu.be/wb4HzFoqsU8 Data warehouse - https://youtu.be/UFF_QpHJJNQ Data pipelines - https://youtu.be/suL76brljZI End-to-end data flows project - https://youtu.be/ZmgZPhl2LRU OneLake - https://youtu.be/hQs_JxCmL0U --TIMELINE-- 0:00 Intro 1:09 Recap on the Lakehouse Files 1:40 Intro to notebook structure 2:12 Reading JSON into pySpark dataframe 4:07 Exploring the data in Azure Storage Explorer & VS Code 5:28 Parsing the JSON 8:52 Datetime conversion 9:55 Calculated columns 11:25 Rounding numbers 12:37 Code refactoring 15:Load dataframe to Lakehouse table --LINKEDIN-- Not following the LinkedIn page yet? Here's the link: https://www.linkedin.com/company/learnmicrosoftfabric/ --ABOUT WILL-- Hi, I'm Will! I'm hugely passionate about data and using it to create a better world. I currently work as a Consultant, focusing on Data Strategy, Data Engineering and Business Intelligence (within the Microsoft/Azure/Fabric environment). I have previously worked as a Data Scientist. I started Learn Microsoft Fabric to share my learnings on how Microsoft Fabric works and help you build your career and build meaningful things in Fabric. --SUBSCRIBE-- Not subscribed yet? You should! There are lots of new videos in the pipeline covering all aspects of Microsoft Fabric.
Mediafile available in formats
Questions about downloading video
How can I download "Using Fabric notebooks (pySpark) to clean and transform real-world JSON data" video?
http://univideos.ru/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.
The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.
UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.
UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.
Which format of "Using Fabric notebooks (pySpark) to clean and transform real-world JSON data" video should I choose?
The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.
Why does my computer freeze when loading a "Using Fabric notebooks (pySpark) to clean and transform real-world JSON data" video?
The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.
How can I download "Using Fabric notebooks (pySpark) to clean and transform real-world JSON data" video to my phone?
You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.
How can I download an audio track (music) to MP3 "Using Fabric notebooks (pySpark) to clean and transform real-world JSON data"?
The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.
How can I save a frame from a video "Using Fabric notebooks (pySpark) to clean and transform real-world JSON data"?
This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.
How do I play and download streaming video?
- in video formats, hover your mouse over "Streaming Video**";
- right-click on "Copy link";
- open VLC-player;
- select Media - Open Network Stream - Network in the menu;
- paste the copied link into the input field;
- click "Play".
- copy the video address (URL);
- select "Open Network Stream" in the "Media" item of VLC player and paste the link to the video into the input field;
- click on the arrow on the "Play" button and select "Convert" in the list;
- select "Video - H.264 + MP3 (MP4)" in the "Profile" line;
- click the "Browse" button to select a folder to save the converted video and click the "Start" button;
- conversion speed depends on the resolution and duration of the video.
For this purpose you need VLC-player, which can be downloaded for free from the official website https://www.videolan.org/vlc/.
How to play streaming video through VLC player:
To download streaming video via VLC player, you need to convert it:
Warning: this download method no longer works with most YouTube videos.
What's the price of all this stuff?
It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.