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”
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”
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.
In this article we will describe how to use add the weather forecast to your web page. If you want to quickly add the weather forecast to your website with minimal code, then our free widget will give your website a weather forecast with almost no coding at all. If you are looking for a …
Continue reading “How do I add the weather forecast to my web page?”
We use a lot of sources for our weather data. One of the richest sources of historical weather data is the Integrated Surface Database (ISD) from NOAA. The amount of data available is impressive. Hourly or sub-hourly weather records for 1000s of weather stations that are, in some cases, over 100 years old. However obtaining and manipulating …
Continue reading “How We Process the NOAA Integrated Surface Database Historical Weather Data”