From the course: Utilizing Excel, Python, and Copilot as a Citizen Data Scientist
Join today to access over 24,700 courses taught by industry experts.
Data transformations utilizing Power Query and Python
From the course: Utilizing Excel, Python, and Copilot as a Citizen Data Scientist
Data transformations utilizing Power Query and Python
- [Instructor] In our previous videos, we talked about the functionality Citizen AI Data Scientist has to join datasets together. We talked about the Excel-based approach and the Power Query approach. Well, with Power Query, we focused on looking at the appending data methodology and the merging data methodology. Now, in this video, we're going to unpack this in a bit more detail and talk about how you transform the data you've now joined. Now, data transformations in Power Query are a key part of the AI Citizen Data Science workflow. It's very likely you receive data that needs to modify and transform to your, suit your analytical needs. Now, within Power Query, the beauty of this is not just the flexibility you have with merging, appending, and then modifying all your data, but more importantly, the query settings here, where for every transformation step you take, it'll be logged where you can reverse it, or better yet, let anyone else identify what has been done to the dataset…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
