[In-Database Python Analysis Tutorial with SQL Server 2017] Step 1: Download sample data

From the beginning of the tutorial

In-Database Python Analysis for SQL Developers

Previous step

In-Database Python Analysis for SQL Developers

Next step

Step 2: Import data into SQL Server using PowerShell

Step 1: Download sample data

In this step, you will download the sample dataset and script shared on Github by the PowerShell script to a local directory of your choice.

Download data and scripts

  1. Open the Windows PowerShell command console.

Use ** Run as administrator ** if you need administrator privileges to create a download directory or write files to the specified download destination.

  1. Run the following PowerShell command to change the value of the parameter DestDir to your local directory. Here, ** C: \ tempPythonSQL ** is specified as the download destination directory.

    $source = 'https://raw.githubusercontent.com/Azure/Azure-MachineLearning-DataScience/master/Misc/PythonSQL/Download_Scripts_SQL_Walkthrough.ps1'
    $ps1_dest = "$pwd\Download_Scripts_SQL_Walkthrough.ps1"
    $wc = New-Object System.Net.WebClient
    $wc.DownloadFile($source, $ps1_dest)
    .\Download_Scripts_SQL_Walkthrough.ps1 -DestDir 'C:\tempPythonSQL'
    

If the folder specified by DestDir does not exist, it will be created by the PowerShell script.

  1. Depending on your internet connection, it may take some time to download. Once all the files have been downloaded, run the following command at the PowerShell command prompt to see the downloaded files.

    ls
    

    sqldev-python-filelist-gho9o9.png

Link

Next step

Step 2: Import data into SQL Server using PowerShell

Previous step

In-Database Python Analysis for SQL Developers

From the beginning of the tutorial

In-Database Python Analysis for SQL Developers

Source

Step 1: Download the Sample Data

Related item

Machine Learning Services with Python

Recommended Posts

[In-Database Python Analysis Tutorial with SQL Server 2017] Step 1: Download sample data
[In-Database Python Analysis Tutorial with SQL Server 2017]
[In-Database Python Analysis Tutorial with SQL Server 2017] Step 6: Using the model
[In-Database Python Analysis Tutorial with SQL Server 2017] Step 5: Training and saving a model using T-SQL
Data analysis with python 2
Data analysis with Python
Sample data created with python
Data analysis starting with python (data visualization 1)
Data analysis starting with python (data visualization 2)
Download Japanese stock price data with python
Data analysis starting with python (data preprocessing-machine learning)
Data analysis python
Data analysis for improving POG 1 ~ Web scraping with Python ~
Data analysis using Python 0
Data analysis overview python
Voice analysis with python
Reading Note: An Introduction to Data Analysis with Python
Data analysis environment construction with Python (IPython notebook + Pandas)
Challenge principal component analysis of text data with Python
Python data analysis template
[Python tutorial] Data structure
Voice analysis with python
Local server with python
ODBC access to SQL Server from Linux with Python
Access the host SQL Server with python27 / pyodbc on the container
20200329_Introduction to Data Analysis with Python Second Edition Personal Summary
<Python> Build a dedicated server for Jupyter Notebook data analysis
My python data analysis container
[Python] Morphological analysis with MeCab
Python for Data Analysis Chapter 4
Get Youtube data with python
Sentiment analysis with Python (word2vec)
[Python] Notes on data analysis
Python data analysis learning notes
Planar skeleton analysis with Python
Japanese morphological analysis with Python
Easy HTTP server with Python
Data analysis using python pandas
Muscle jerk analysis with Python
Download csv file with python
Python for Data Analysis Chapter 3
Read json data with python
Practical exercise of data analysis with Python ~ 2016 New Coder Survey Edition ~
Introduction to Data Analysis with Python P32-P43 [ch02 3.US Baby Names 1880-2010]
Introduction to Data Analysis with Python P17-P26 [ch02 1.usa.gov data from bit.ly]
Links to people who are just starting data analysis with python
Create a USB boot Ubuntu with a Python environment for data analysis
EEG analysis in Python: Python MNE tutorial
3D skeleton structure analysis with Python
Python: Time Series Analysis: Preprocessing Time Series Data
Implemented file download with Python + Bottle
Impedance analysis (EIS) with python [impedance.py]
Web scraping with Python First step
[Python] Get economic data with DataReader
[GUI with Python] PyQt5-The first step-
Text mining with Python ① Morphological analysis
Python data structures learned with chemoinformatics
Preprocessing template for data analysis (Python)
Easy data visualization with Python seaborn.
Process Pubmed .xml data with python
Logistic regression analysis Self-made with python