Web Scraping? With Python in the SQL Query | SQL Server

Publicado el: 23 febrero 2022
en el canal de: fabioms

2,558

120

We will learn how to execute the technique of prospecting data on the internet known as Web Scraping using Python in SQL Server.
Knowing the subjects and techniques:
What is Web Scraping?
Stages of the Web Scraping and the packages Python;
To install new packages in SQL Server Python;
To declare a variable for Script Python;
To obtain code of the internet page with Python (requests);
To analyze the code HTML and to convert in objects (BeatifulSoup);
To create DataFrame to store the values (pandas);
To add values in DataFrame;
To make available the result (OutputDataset);
To execute the script Python (sp_execute_external_script);
To create Procedure (PROCEDURE);
To execute Procedure;
To consult table with the result (SELECT);
#microsoft #dataplataform #sqlserver #machinelearning #python #webscraping

Path to find the application 'pip' in the servant where SQL Server 2019 is installed :
C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\PYTHON_SERVICES\Scripts
#Note: Alter the path according to the version of SQL Server used

Code to install the packages in SQL Server:
pip install requests
pip install bs4
pi install html5lib
pip install lxml
#Note: It is important to understand that the packages can depend on other packages and the number of specific versions according to SQL Server installation

Notebook with complete code in the github:
https://github.with / fabioms-br / sqlserverCaminho to find the application 'pip' in the servant where SQL Server 2019 is installed :

En esta página del sitio puede ver el video en línea Web Scraping? With Python in the SQL Query | SQL Server de Duración hora minuto segunda en buena calidad , que subió el usuario fabioms 23 febrero 2022, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 2,558 veces y le gustó 120 a los espectadores. Disfruta viendo!

448