Skip to content

demo-data-airlinedemo-in-sql.md

Latest commit

 

History

History
62 lines (38 loc) · 2.75 KB

demo-data-airlinedemo-in-sql.md

File metadata and controls

62 lines (38 loc) · 2.75 KB
title Airline flight demo data set for SQL Server Python and R tutorials
Description Create a database containing the Airline dataset from R and Python. This dataset is used in exercises showing how to wrap R language or Python code in a SQL Server stored procedure.
ms.prod sql
ms.technology machine-learning
ms.date 10/22/2018
ms.topic tutorial
author dphansen
ms.author davidph
monikerRange >=sql-server-2016||>=sql-server-linux-ver15||=sqlallproducts-allversions

Airline flight arrival demo data for SQL Server Python and R tutorials

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md]

In this exercise, create a SQL Server database to store imported data from R or Python built-in Airline demo data sets. R and Python distributions provide equivalent data, which you can import to a SQL Server database using Management Studio.

To complete this exercise, you should have SQL Server Management Studio or another tool that can run T-SQL queries.

Tutorials and quickstarts using this data set include the following:

Create the database

  1. Start SQL Server Management Studio, connect to a database engine instance that has R or Python integration.

  2. In Object Explorer, right-click Databases and create a new database called flightdata.

  3. Right-click flightdata, click Tasks, click Import Flat File.

  4. Open the AirlineDemoData.csv file provided in the R or Python distribution, depending on which language you installed.

    For R, look for AirlineDemoSmall.csv at C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\R_SERVICES\library\RevoScaleR\SampleData

    For Python, look for AirlineDemoSmall.csv at C:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\PYTHON_SERVICES\Lib\site-packages\revoscalepy\data\sample_data

When you select the file, default values are filled in for table name and schema.

Import flat file wizard showing airline demo defaults

Click through the remaining pages, accepting the defaults, to import the data.

Query the data

As a validation step, run a query to confirm the data was uploaded.

  1. In Object Explorer, under Databases, right-click the flightdata database, and start a new query.

  2. Run some simple queries:

    SELECT TOP(10) * FROM AirlineDemoSmall;
SELECT COUNT(*) FROM AirlineDemoSmall;

Next steps

In the following lesson, you will create a linear regression model based on this data.