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 …

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

In this article we are going to demonstrate how to import data from a RESTful Weather API. This API returns JSON-based data into Microsoft Excel. 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 …

“North and West of I-95” – why does snow in the Eastern US always seem fall to the West of I-95?

As winter starts in the Northern Hemisphere , schoolchildren are hoping for a “snow day” – a day where school is cancelled and everyone gets to build snowmen and launch a few well-aimed snowballs at their neighbors. However for children in the North-East of the United States, in cities including Richmond, Washington, DC, Baltimore, Philadelphia, …

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 …

How to Import Weather Forecast Data and Historical Weather Data into a MySQL Database

In this article, we are going to import weather data into a MySQL database. In addition to setting up the database tables, we will demonstrate techniques to import both historical weather data and weather forecast data. We will include the ways to retrieve the weather data and how to set up a script so the …