From the course: Python in Excel: Data Outputs in Custom Data Visualizations and Algorithms

Unlock this course with a free trial

Join today to access over 25,400 courses taught by industry experts.

Challenge: Creating table objects in Excel

Challenge: Creating table objects in Excel

From the course: Python in Excel: Data Outputs in Custom Data Visualizations and Algorithms

Start my 1-month free trial Buy for my team

Challenge: Creating table objects in Excel

“

(upbeat music) - [Instructor] Now you'll have a chance to try out what you've learned so far in this course on your own. For the challenge in this course, let's continue to use Santa Barbara airport weather data, but instead of daily data, we'll use hourly data for the same location. We can get this data through the National Weather Service, and specifically this is the Aviation Weather Center. They have an API that we can explore and use without even having to sign up for an API token or key. I already set up an Excel file to include a template for getting this hourly weather data. You can use the query for the data table in your own challenge problem. If you refresh your data in the model, it won't look like mine because you'll see the latest 15 days of hourly weather measurements in your view. Alternatively in the text file, this is the API query that I use to get the data. You can use this query directly in Power Query to get the data if you want an additional challenge of…

Contents