From the course: Advanced Analysis Using Python in Excel Copilot
Join today to access over 25,500 courses taught by industry experts.
Analyzing real-world data
From the course: Advanced Analysis Using Python in Excel Copilot
Analyzing real-world data
- [Instructor] To explore real-world data using advanced analysis, I'll be using a dataset of electric vehicle data from the US state of Washington. This data is available from data.gov as a CSV. I'll download that. And I'll open it in Excel. In order to use advanced analysis, the auto save feature needs to be enabled, and for that to happen, we need for this file to be an Excel file. So I'll save it as that. I will open my Home ribbon and find the Copilot button and click it. And then I'll move into Advanced analysis for this workbook. Let's explore this data a little bit and ask a fairly basic question like, "What are the top five most popular models of car?" Copilot shows its work and returns a data frame with the five most popular models. It also displays it here in the chat. That's something we could also do with Excel by itself. But what's important here is that Copilot is using Python and its understanding of our data to build a data frame and use the Python methods for working…
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.