Articles, videos, and documentation to help you get the most from Visual Crossing Weather
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 …
Continue reading “Importing data from a JSON Weather API into Microsoft Excel using Power Query”
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 …
Continue reading “Does weather affect the results of the London Marathon?”
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 …
Continue reading “How to find weather data using NLP (Natural Language Processing)”
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 …
Continue reading “How to use the Microsoft Excel WEBSERVICE function to retrieve weather data”
If you are creating a web page that needs to display weather data using client side code such as JavaScript, you may find that your browser blocks the request to the Weather API. Today we discuss how the Timeline Weather API makes solving this easy and painless. How? Because the API supports reading the weather …
Continue reading “How to use CORS with a RESTful Weather API”
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 …
Continue reading “Plan for the weather on your next camping or RV trip”
Why does it seem like the most snow falls North & East of the large cities of the North East United States?
The Visual Crossing Weather API is a rich, restful API that you can use to get historical weather data, weather forecast data and even climate data sets into your database, analysis tool or coding project. The API has a rich set of parameters that may be overwhelming at first. In this blog, i describe the …
Continue reading “Five Easy Weather API calls to Get The Weather Data You Need”
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 …
In this article we will describe various techniques to include both historical weather data and weather forecast data into a Microsoft Word document.