Importing data from a JSON Weather API into Microsoft Excel using Power Query

This article shows how to import data into Microsoft Excel using Power Query from a RESTful Weather API. This API returns JSON-based data. We are also going to explain how to create a loop within our script so that we can call the API multiple times for multiple locations and create a combined result table …

Does weather affect the results of the London Marathon?

Does weather affect the results of the London Marathon?

Every year runners descend on London, England for the annual London Marathon. Can weather change the race? In this blog we investigate whether London Marathon finishing times vary with the weather. Were previous marathons affected by weather? First, let’s take a look at the previous results and if they were affected by weather. Here I …

How to find weather data using NLP (Natural Language Processing)

Natural Language Processing (NLP) is an artificial intelligence process used to by computer systems to find the meaning of text content. This allows the human users to ask questions using sentences written in a natural way using normal sentences. Successful NLP systems will allow users to ask questions in different ways and still be able …

How to use the Microsoft Excel WEBSERVICE function to retrieve weather data

The Microsoft Excel WEBSERVICE function retrieves data from a URL into a single cell within an Excel worksheet. In this article we describe how to use WEBSERVICE to retrieve weather forecast and historical weather data directly into Excel without the need for macros or scripts. However, is it always the best way to work with …

Plan for the weather on your next camping or RV trip

If you are a keen campers or RV-ers like our family, you are looking forward to a summer of exploration. Exploring beaches, cities and mountains around the country is what makes camping and RV-ing such as wonderful experience. However camping is inherently weather-based. Extremely hot or cold weather or strong storms, hurricanes (and blizzards if …

How to use Python and Pandas to join historical weather data to road accident data

I am currently investigating the relationship between weather conditions and accidents by using a dataset of road accidents in Fairfax County, Virginia obtained from the Virginia Department of Motor Vehicles. The first step to perform the analysis is to combine the accident data with the historical weather conditions. In this article, we will discuss how …