Articles for "CSV"

How do I get started with the Weather API?

This article describes the fastest way to get started with the Visual Crossing Weather API by constructing API queries using the Weather Data Services page. Steps Navigate to Visual Crossing Weather Data Services Log in to your account (create a free trial account if necessary) Add one or more locations Construct a weather forecast or weather …

How to Load Weather Data into Microsoft Excel using a Web Query Data Connection

One of the powerful features of the Visual Crossing Weather Service is the ability to query data via a Web Service or URL.  This ability isn’t only limited to coders but rather can be utilized to import data into most Business Intelligence Systems including Excel.   When you include your data into Excel, you can refresh …

Getting Started With Shipment Weather

Many businesses ship weather-sensitive products such as wine, food, beverages, and pharmaceuticals. Shipment Weather uses worldwide weather forecast data to verify that the weather at the shipping destination is within provided parameters that will not damage the items being shipped.  Users can plan shipments that reduce product spoilage and increase customer satisfaction. The tool helps …

Weather Data Documentation

The Visual Crossing Weather Data platform provides the ability to easily access weather data sets including weather forecast data, weather history data and historical weather summary data. The data is available for download through the Weather Data Download page and is also available through the Weather Data API and Timeline Weather API. This document explains the weather data variables that …

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 …

How can I load historical weather data into Microsoft Power BI?

In this article, I’m going to show you how to easily load historical weather data for any worldwide location into Microsoft Power BI for further analysis.  We’ll walk through the process step-by-step showing you how to construct the query in Visual Crossing Weather web interface and then use the query URL to import the weather …

How can I find historical weather data for analysis in R?

In this article, I’m going to show you how to easily load historical weather data into your R analysis.  We’ll walk through the process step-by-step showing you how to construct the query in Visual Crossing Weather and then use the query URL to import the weather history results using R Studio. Also see our companion …

How to Find Weather Data for your Next Data Science Project

The use of weather data in data science is hugely varied and there are applications in all applied verticals. However at the heart of all data science projects are accurate, trustworthy weather datasets. In this article, we’ll explain the types of weather data available for data science, how to get them, how to make sure …