Articles for "CSV"

How to add Weather Data to Google Sheets using a Dynamic Weather Query

The value of weather data comes from what you do with it.   In order to get value from our weather data typically users will import it into other business systems or spreadsheet systems such as Excel or Google Sheets.   In this document we will demonstrate how to get a Visual Crossing Weather query directly into …

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 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 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 …

How can I load historical weather data into Google Sheets?

In this article, I’m going to show you how to easily load historical weather data into Google sheets.  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 results into Google Sheets. Also see our companion article that …