{"id":219287,"date":"2024-01-03T18:30:00","date_gmt":"2024-01-03T18:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=219287"},"modified":"2023-12-28T14:38:36","modified_gmt":"2023-12-28T14:38:36","slug":"web-scraping-avec-power-query","status":"publish","type":"post","link":"https:\/\/datascientest.com\/web-scraping-avec-power-query","title":{"rendered":"Web scraping avec Power Query : Comment \u00e7a marche ?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"219287\" class=\"elementor elementor-219287\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-86f89c3 e-flex e-con-boxed e-con\" data-id=\"86f89c3\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3d38e0f elementor-widget elementor-widget-heading\" data-id=\"3d38e0f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Internet regorge de donn\u00e9es pr\u00e9cieuses pour les entreprises de tous secteurs d\u2019activit\u00e9. Alors pour profiter de toutes ces informations disponibles, il est possible d\u2019extraire les donn\u00e9es depuis une ou plusieurs pages web. Notamment gr\u00e2ce au web scraping avec Power Query. DataScientest vous explique comment faire. <\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-140e403 e-flex e-con-boxed e-con\" data-id=\"140e403\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-34a725e elementor-widget elementor-widget-heading\" data-id=\"34a725e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">C\u2019est quoi le Web Scraping ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f693a48 elementor-widget elementor-widget-text-editor\" data-id=\"f693a48\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">Le <a href=\"https:\/\/datascientest.com\/web-scraping-tout-savoir\">web scraping<\/a>, c\u2019est tout simplement la possibilit\u00e9 de<\/span><b> r\u00e9cup\u00e9rer des donn\u00e9es depuis une page web. <\/b><span style=\"font-weight: 400;\">Cela permet ainsi de stocker dans sa propre <a href=\"https:\/\/datascientest.com\/base-de-donnees-definition\">base de donn\u00e9es<\/a>, toutes les informations utiles pr\u00e9sentes sur un site web.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Cette d\u00e9marche est souvent utilis\u00e9e par les entreprises lors de <strong>veille concurrentielle<\/strong>. L\u2019id\u00e9e est alors de comparer les donn\u00e9es d\u2019entreprises concurrentes pour r\u00e9aliser une \u00e9tude de march\u00e9 compl\u00e8te. Mais il est aussi possible de faire du web scraping depuis un site du gouvernement afin de stocker des informations officielles, de l\u2019INSEE pour r\u00e9cup\u00e9rer des statistiques, d\u2019un site sp\u00e9cialis\u00e9 dans un secteur d\u2019activit\u00e9 compl\u00e9mentaire, etc.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Quel que soit l\u2019objectif, la r\u00e9cup\u00e9ration de donn\u00e9es est <\/span><b>possible \u00e0 partir de n\u2019importe quel site web.<\/b><span style=\"font-weight: 400;\"> Et surtout, le web scraping est facilit\u00e9 avec <\/span><a href=\"https:\/\/datascientest.com\/power-query-tout-savoir\"><span style=\"font-weight: 400;\">Power Query, <\/span><\/a><span style=\"font-weight: 400;\">l\u2019\u00e9diteur de requ\u00eate int\u00e9gr\u00e9 \u00e0 <a href=\"https:\/\/datascientest.com\/power-bi\">Power BI<\/a>.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a6063ee e-flex e-con-boxed e-con\" data-id=\"a6063ee\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-329300b elementor-widget elementor-widget-heading\" data-id=\"329300b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Comment faire du Web Scraping avec Power Query ?<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0f1ec01 elementor-widget elementor-widget-text-editor\" data-id=\"0f1ec01\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Pour effectuer du web Scraping \u00e0 travers Power Query et Power BI, voici les d\u00e9marches \u00e0 suivre.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7fe9a8e elementor-widget elementor-widget-heading\" data-id=\"7fe9a8e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Extraire les donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7007aa4 elementor-widget elementor-widget-text-editor\" data-id=\"7007aa4\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">L\u2019extraction des donn\u00e9es se fait <\/span><b>depuis l\u2019outil Power BI.<\/b><span style=\"font-weight: 400;\"> \u00c0 partir de l\u00e0, suivez les \u00e9tapes ci-dessous :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans l\u2019onglet Accueil, cliquez sur \u00ab\u00a0<\/span><i><span style=\"font-weight: 400;\">Obtenir des donn\u00e9es<\/span><\/i><span style=\"font-weight: 400;\">\u00ab\u00a0.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Dans la barre de recherche, tapez \u00ab\u00a0web\u00a0\u00bb pour s\u00e9lectionner le connecteur web. C\u2019est ce qui permet de se connecter au site internet et de r\u00e9cup\u00e9rer ses donn\u00e9es.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Renseignez l\u2019URL dont vous souhaitez extraire les donn\u00e9es et cliquez sur \u00ab\u00a0OK\u00a0\u00bb. La plupart du temps, aucune authentification ne sera requise pour acc\u00e9der au site. Mais dans certains cas, vous devrez vous authentifier \u00e0 travers les modes de connexion Windows, les API web ou les comptes professionnels.\u00a0\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquer sur \u00ab\u00a0Se connecter\u00a0\u00bb.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Une page de navigation s\u2019ouvre, celle-ci vous indique plusieurs tables sugg\u00e9r\u00e9es contenant les donn\u00e9es issues de l\u2019URL. Il vous suffit de s\u00e9lectionner la table dont vous souhaitez extraire les donn\u00e9es.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquer sur \u00ab\u00a0Transformer les donn\u00e9es\u00a0\u00bb.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0788566 elementor-widget elementor-widget-text-editor\" data-id=\"0788566\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Si le web scraping permet de r\u00e9cup\u00e9rer facilement les donn\u00e9es d\u2019une page web, ces derni\u00e8res sont format\u00e9es selon les pr\u00e9requis du site web. Or, la plupart du temps, <\/span><b>ces formats ne s\u2019adaptent pas \u00e0 votre base de donn\u00e9es<\/b><span style=\"font-weight: 400;\">. Il faudra donc transformer la table et utiliser le web scraping avec Power Query.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2d6c0fc elementor-widget elementor-widget-image\" data-id=\"2d6c0fc\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"886\" height=\"600\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/web-scraping-power-query-1.jpg\" class=\"attachment-full size-full wp-image-219318\" alt=\"\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6637482 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"6637482\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-data-marketing\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Ma\u00eetriser le web scraping avec Power Query<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e9e8ce elementor-widget elementor-widget-heading\" data-id=\"4e9e8ce\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Transformer les donn\u00e9es<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f49416f elementor-widget elementor-widget-text-editor\" data-id=\"f49416f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">D\u00e8s lors que vous avez cliqu\u00e9 sur \u201cTransformer les donn\u00e9es\u201d,<\/span><b> l\u2019\u00e9diteur de requ\u00eate Power Query appara\u00eet pour compl\u00e9ter le web scraping<\/b><span style=\"font-weight: 400;\">. Vous y retrouverez la table s\u00e9lectionn\u00e9e avec toutes ses donn\u00e9es.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Afin qu\u2019elle r\u00e9ponde \u00e0 vos besoins d\u2019analyse et de reporting, vous pouvez effectuer plusieurs actions de modification avec Power Query. Par exemple :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Renommer la table<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Supprimer des colonnes\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Renommer les colonnes<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ajouter des colonnes<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6f8612e elementor-widget elementor-widget-text-editor\" data-id=\"6f8612e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">D\u00e8s que votre table est pr\u00eate, cliquez sur \u00ab\u00a0Fermer et appliquer\u00a0\u00bb afin de les visualiser dans Power BI.\u00a0<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ed002a8 elementor-widget elementor-widget-heading\" data-id=\"ed002a8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">Ajouter toutes les tables du site<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f0bc069 elementor-widget elementor-widget-text-editor\" data-id=\"f0bc069\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">L\u2019int\u00e9r\u00eat du web scraping avec Power Query, c\u2019est aussi la<\/span><b> possibilit\u00e9 de r\u00e9cup\u00e9rer les donn\u00e9es de toutes les pages d\u2019un site web.\u00a0<\/b><\/p><p><span style=\"font-weight: 400;\">Pour cela, il convient de modifier le code de la table. Voici les d\u00e9marches \u00e0 suivre :\u00a0<\/span><\/p><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Utilisez l\u2019\u00e9diteur avanc\u00e9 pour voir appara\u00eetre les lignes de code de la table ;\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Vous verrez appara\u00eetre une ligne : <\/span><ul><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Source=Web.Browser.Content(\u00ab\u00a0https:<\/span><span style=\"font-weight: 400;\">www.votre-url.com\/blog\/page\/2<\/span><span style=\"font-weight: 400;\">\u00ab\u00a0). Dans ce cas, seules les tables de la page sont int\u00e9gr\u00e9es. Alors si vous souhaitez toutes les pages, vous pouvez modifier le code de la mani\u00e8re suivante : <\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Source=Web.Browser.Content(\u00ab\u00a0https:<\/span><span style=\"font-weight: 400;\">www.votre-url.com\/blog\/page\/<\/span><span style=\"font-weight: 400;\">\u201d&amp;Page&amp;\u00a0\u00bb)<\/span><\/li><\/ul><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">D\u00e8s lors, la table de donn\u00e9es devient une fonction. Vous pouvez la renommer en FxPages avant de cr\u00e9er une liste qui contient tous les num\u00e9ros de page.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Appeler une fonction personnalis\u00e9e\u00a0\u00bb afin d\u2019appeler la fonction FxPages.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Une nouvelle colonne s\u2019ajoute. D\u00e9veloppez-la afin de cr\u00e9er une nouvelle table englobant toutes les donn\u00e9es du site.<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Transformez les donn\u00e9es comme susmentionn\u00e9.\u00a0<\/span><\/li><li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Cliquez sur \u00ab\u00a0Fermer et appliquer\u00a0\u00bb.<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-61d377f e-flex e-con-boxed e-con\" data-id=\"61d377f\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0e56e2e elementor-widget elementor-widget-heading\" data-id=\"0e56e2e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Ma\u00eetriser Power Query avec DataScientest<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-08fb55f elementor-widget elementor-widget-text-editor\" data-id=\"08fb55f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">En plus du web scraping, Power Query vous offre une multitude de fonctionnalit\u00e9s pour g\u00e9rer vos bases de donn\u00e9es. Mais l\u2019\u00e9diteur de requ\u00eate n\u2019est pas si simple \u00e0 ma\u00eetriser. Pour utiliser tous ces services avec aisance, il est primordial de se former. C\u2019est justement pour cela que <strong>DataScientest<\/strong> vous propose ses formations data. <a href=\"https:\/\/datascientest.com\/formations-data\">D\u00e9couvrez-les !<\/a><\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3e4e2cc elementor-widget elementor-widget-image\" data-id=\"3e4e2cc\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"734\" height=\"600\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/web-scraping-power-query-2.jpg\" class=\"attachment-full size-full wp-image-219325\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/web-scraping-power-query-2.jpg 734w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/web-scraping-power-query-2-300x245.jpg 300w\" sizes=\"(max-width: 734px) 100vw, 734px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cb721f9 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"cb721f9\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-data-marketing\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Commencer une formation en Marketing Digital et Data<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-96f1a76 e-flex e-con-boxed e-con\" data-id=\"96f1a76\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-72f04ae elementor-widget elementor-widget-html\" data-id=\"72f04ae\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"C\u2019est quoi le Web Scraping ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Le web scraping, c\u2019est tout simplement la possibilit\u00e9 de r\u00e9cup\u00e9rer des donn\u00e9es depuis une page web. Cela permet ainsi de stocker dans sa propre base de donn\u00e9es, toutes les informations utiles pr\u00e9sentes sur un site web.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Transformer les donn\u00e9es\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"D\u00e8s lors que vous avez cliqu\u00e9 sur \u201cTransformer les donn\u00e9es\u201d, l\u2019\u00e9diteur de requ\u00eate Power Query appara\u00eet pour compl\u00e9ter le web scraping. Vous y retrouverez la table s\u00e9lectionn\u00e9e avec toutes ses donn\u00e9es. Afin qu\u2019elle r\u00e9ponde \u00e0 vos besoins d\u2019analyse et de reporting, vous pouvez effectuer plusieurs actions de modification avec Power Query.\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Internet regorge de donn\u00e9es pr\u00e9cieuses pour les entreprises de tous secteurs d\u2019activit\u00e9. Alors pour profiter de toutes ces informations disponibles, il est possible d\u2019extraire les donn\u00e9es depuis une ou plusieurs pages web. Notamment gr\u00e2ce au web scraping avec Power Query. DataScientest vous explique comment faire. C\u2019est quoi le Web Scraping ? Le web scraping, c\u2019est [&hellip;]<\/p>\n","protected":false},"author":74,"featured_media":219305,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2493],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Web scraping avec Power Query : Comment \u00e7a marche ?<\/title>\n<meta name=\"description\" content=\"Pour extraire les donn\u00e9es d\u2019une page web, vous pouvez utiliser le web scraping avec Power Query. Mode d\u2019emploi.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/web-scraping-avec-power-query\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Web scraping avec Power Query : Comment \u00e7a marche ?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/web-scraping-avec-power-query\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2024-01-03T18:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-28T14:38:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/web-scraping-power-query.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Antoine Tardivon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Antoine Tardivon\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/web-scraping-avec-power-query\",\"url\":\"https:\/\/datascientest.com\/web-scraping-avec-power-query\",\"name\":\"Web scraping avec Power Query : Comment \u00e7a marche ?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2024-01-03T18:30:00+00:00\",\"dateModified\":\"2023-12-28T14:38:36+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\"},\"description\":\"Pour extraire les donn\u00e9es d\u2019une page web, vous pouvez utiliser le web scraping avec Power Query. Mode d\u2019emploi.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/web-scraping-avec-power-query\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57\",\"name\":\"Antoine Tardivon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg\",\"caption\":\"Antoine Tardivon\"},\"description\":\"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/\",\"Business Intelligence\"],\"url\":\"https:\/\/datascientest.com\/author\/antoinetardivon\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Web scraping avec Power Query : Comment \u00e7a marche ?","description":"Pour extraire les donn\u00e9es d\u2019une page web, vous pouvez utiliser le web scraping avec Power Query. Mode d\u2019emploi.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/web-scraping-avec-power-query","og_locale":"fr_FR","og_type":"article","og_title":"Web scraping avec Power Query : Comment \u00e7a marche ?","og_url":"https:\/\/datascientest.com\/web-scraping-avec-power-query","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2024-01-03T18:30:00+00:00","article_modified_time":"2023-12-28T14:38:36+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/web-scraping-power-query.png","type":"image\/png"}],"author":"Antoine Tardivon","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Antoine Tardivon","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/web-scraping-avec-power-query","url":"https:\/\/datascientest.com\/web-scraping-avec-power-query","name":"Web scraping avec Power Query : Comment \u00e7a marche ?","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2024-01-03T18:30:00+00:00","dateModified":"2023-12-28T14:38:36+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57"},"description":"Pour extraire les donn\u00e9es d\u2019une page web, vous pouvez utiliser le web scraping avec Power Query. Mode d\u2019emploi.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/web-scraping-avec-power-query"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/40cb5b6317e138be77b9dd23007cab57","name":"Antoine Tardivon","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/antoine-tardivon.jpeg","caption":"Antoine Tardivon"},"description":"Antoine Tardivon est Data Scientist chez DataScientest. Il a pr\u00e9c\u00e9demment effectu\u00e9 un stage en impl\u00e9mentation Python \u00e0 l'University of Helsinki et en recherche Machine Learning chez Thales. Dipl\u00f4m\u00e9 de l'Ecole centrale de Nantes et d'Audencia, il poss\u00e8de des comp\u00e9tences en ing\u00e9nierie et en finance.","sameAs":["https:\/\/www.linkedin.com\/in\/antoine-tardivon-385881204\/","Business Intelligence"],"url":"https:\/\/datascientest.com\/author\/antoinetardivon"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/219287"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/74"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=219287"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/219287\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/219305"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=219287"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=219287"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=219287"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}