{"id":16,"date":"2023-03-02T01:30:24","date_gmt":"2023-03-02T01:30:24","guid":{"rendered":"https:\/\/juegacondatos.com\/?p=16"},"modified":"2023-03-09T20:30:08","modified_gmt":"2023-03-10T01:30:08","slug":"tres-formas-de-usar-python-en-power-bi","status":"publish","type":"post","link":"https:\/\/juegacondatos.com\/index.php\/2023\/03\/02\/tres-formas-de-usar-python-en-power-bi\/","title":{"rendered":"Tres formas de usar Python en Power BI"},"content":{"rendered":"\n<p class=\"has-medium-font-size\">Python es un lenguaje de programaci\u00f3n muy popular, as\u00ed mismo Microsoft Power BI es la herramienta de creaci\u00f3n de dashboards (Tableros de Control) m\u00e1s popular en el momento de escribir este blog.<\/p>\n\n\n\n<p class=\"has-medium-font-size\">A continuaci\u00f3n veras c\u00f3mo usar Python dentro de Microsoft Power BI. <br>Existen tres formas:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Python c\u00f3mo fuente de datos<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Python para realizar transformaciones<\/li>\n<\/ul>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Python para crear visualizaciones<\/li>\n<\/ul>\n\n\n\n<h2 class=\"has-large-font-size wp-block-heading\" style=\"font-style:normal;font-weight:700\">Prerrequisitos<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tener instalado Python junto con el paquete de Pandas y matplotlib<\/li>\n\n\n\n<li>Tener instalado Power BI Desktop<\/li>\n<\/ul>\n\n\n\n<h2 class=\"has-large-font-size wp-block-heading\" style=\"font-style:normal;font-weight:700\">Python como fuente de datos<\/h2>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile is-vertically-aligned-top\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p class=\"has-medium-font-size\">En Power BI, ir al men\u00fa&nbsp;<strong>Obtener Datos<\/strong>&nbsp;y dar click en el icono.<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"269\" height=\"213\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_Z823x3ghcp-1.png\" alt=\"\" class=\"wp-image-56 size-full\"\/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p class=\"has-medium-font-size\">Se despliega una ventana con el listado de las fuentes de informaci\u00f3n que Power BI soporta<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"487\" height=\"333\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_0H2a5PHPUo.png\" alt=\"\" class=\"wp-image-25 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_0H2a5PHPUo.png 487w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_0H2a5PHPUo-300x205.png 300w\" sizes=\"auto, (max-width: 487px) 100vw, 487px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p class=\"has-medium-font-size\">El el cuadro de b\u00fasqueda escribir <em>Python<\/em> y en el cuadro de la derecha seleccionar <em>Script de Python<\/em> y dar click en <strong>Conectar<\/strong><\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"517\" height=\"344\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_fhs9qNn1Sf.png\" alt=\"\" class=\"wp-image-26 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_fhs9qNn1Sf.png 517w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_fhs9qNn1Sf-300x200.png 300w\" sizes=\"auto, (max-width: 517px) 100vw, 517px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p class=\"has-medium-font-size\">Se despliega la ventana Script de Python<br>En la parte inferior del cuadro hay un mensaje que indica la instalaci\u00f3n de Python identificada en el sistema.<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"416\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_izemxcawRy.png\" alt=\"\" class=\"wp-image-30 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_izemxcawRy.png 698w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_izemxcawRy-300x179.png 300w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_izemxcawRy-600x358.png 600w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><\/figure><\/div>\n\n\n\n<p class=\"has-medium-font-size\">Ahora en el cuadro podemos escribir el c\u00f3digo que servir\u00e1 de fuente de datos para el informe<\/p>\n\n\n\n<pre class=\"wp-block-code has-medium-font-size\"><code>import pandas as pd \ndf = pd.DataFrame({ \n    'Fname':&#91;'Harry','Sally','Paul','Abe','June','Mike','Tom'], \n    'Age':&#91;21,34,42,18,24,80,22], \n    'Weight': &#91;180, 130, 200, 140, 176, 142, 210], \n    'Gender':&#91;'M','F','M','M','F','M','M'], \n    'State':&#91;'Washington','Oregon','California','Washington','Nevada','Texas','Nevada'],\n    'Children':&#91;4,1,2,3,0,2,0],\n    'Pets':&#91;3,2,2,5,0,1,5] \n}) \nprint (df)<\/code><\/pre>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p class=\"has-medium-font-size\">Pegar el fragmento de c\u00f3digo en el cuadro<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"416\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_3QCxSdWhDX.png\" alt=\"\" class=\"wp-image-35 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_3QCxSdWhDX.png 698w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_3QCxSdWhDX-300x179.png 300w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_3QCxSdWhDX-600x358.png 600w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p class=\"has-medium-font-size\">Luego se despliega una ventana para seleccionar el DataFrame (df), dar clic en <em>aceptar<\/em><\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"598\" height=\"730\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/MigFn9FYPn.png\" alt=\"\" class=\"wp-image-39 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/MigFn9FYPn.png 598w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/MigFn9FYPn-246x300.png 246w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p class=\"has-medium-font-size\">De esta manera podemos usar python como fuente datos.<br><\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"505\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_W8N2HL2jS5-1024x505.png\" alt=\"\" class=\"wp-image-40 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_W8N2HL2jS5-1024x505.png 1024w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_W8N2HL2jS5-300x148.png 300w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_W8N2HL2jS5-768x379.png 768w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_W8N2HL2jS5-1536x758.png 1536w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_W8N2HL2jS5-600x296.png 600w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_W8N2HL2jS5.png 1605w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"has-large-font-size wp-block-heading\"><strong>Python para realizar transformaciones<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p>Vamos a la opci\u00f3n transformar en el <em>editor de power query<\/em><\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"568\" height=\"425\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_Ilf6LaOFry.png\" alt=\"\" class=\"wp-image-156 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_Ilf6LaOFry.png 568w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_Ilf6LaOFry-300x224.png 300w\" sizes=\"auto, (max-width: 568px) 100vw, 568px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p>Buscamos la \u00faltima opci\u00f3n en scripts \u00ab<em>Ejecutar scripts de python<\/em>\u00ab<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"721\" height=\"510\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_72gWKtxyxE.png\" alt=\"\" class=\"wp-image-155 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_72gWKtxyxE.png 721w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_72gWKtxyxE-300x212.png 300w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_72gWKtxyxE-600x424.png 600w\" sizes=\"auto, (max-width: 721px) 100vw, 721px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p>Se abre una ventana donde podemos poner el script<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"698\" height=\"416\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_izemxcawRy.png\" alt=\"\" class=\"wp-image-30 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_izemxcawRy.png 698w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_izemxcawRy-300x179.png 300w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/PBIDesktop_izemxcawRy-600x358.png 600w\" sizes=\"auto, (max-width: 698px) 100vw, 698px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p>La descripci\u00f3n en la primera l\u00ednea indica que &#8216;<em>dataset<\/em>&#8216; contiene los datos de entrada,<br>debajo podemos poner el c\u00f3digo<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"879\" height=\"562\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_NYlhBS70qQ.png\" alt=\"\" class=\"wp-image-154 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_NYlhBS70qQ.png 879w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_NYlhBS70qQ-300x192.png 300w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_NYlhBS70qQ-768x491.png 768w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_NYlhBS70qQ-600x384.png 600w\" sizes=\"auto, (max-width: 879px) 100vw, 879px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p>Vamos a aplicar 4 transformaciones sobre estas datos<br>La primera crea una nueva columna llamada \u00abEdad m\u00e1xima\u00bb y le asigna la edad m\u00e1xima basada en la columna edad.<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"880\" height=\"530\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_hwGZXP0FXL.png\" alt=\"\" class=\"wp-image-166 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_hwGZXP0FXL.png 880w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_hwGZXP0FXL-300x181.png 300w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_hwGZXP0FXL-768x463.png 768w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_hwGZXP0FXL-600x361.png 600w\" sizes=\"auto, (max-width: 880px) 100vw, 880px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p>La segunda transformaci\u00f3n crea la columna \u00abMenores30\u00bb y le asigna un valor de falso o verdadero si el dato de la columna edad es menor a 30<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"876\" height=\"529\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_DRtJrds741.png\" alt=\"\" class=\"wp-image-165 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_DRtJrds741.png 876w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_DRtJrds741-300x181.png 300w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_DRtJrds741-768x464.png 768w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_DRtJrds741-600x362.png 600w\" sizes=\"auto, (max-width: 876px) 100vw, 876px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p>La tercer transformaci\u00f3n a\u00f1ade un columna llamada \u00abPrimera Letra\u00bb , toma la columna \u00abState\u00bb y de all\u00ed toma la primera letra<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"878\" height=\"528\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_ckWlz98cVx.png\" alt=\"\" class=\"wp-image-164 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_ckWlz98cVx.png 878w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_ckWlz98cVx-300x180.png 300w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_ckWlz98cVx-768x462.png 768w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_ckWlz98cVx-600x361.png 600w\" sizes=\"auto, (max-width: 878px) 100vw, 878px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p>Finalmente tomamos el dataset y seleccionamos las primeras 5 filas del data set<br>Dar clic en aceptar<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"877\" height=\"561\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_R12Yz30JJT.png\" alt=\"\" class=\"wp-image-172 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_R12Yz30JJT.png 877w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_R12Yz30JJT-300x192.png 300w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_R12Yz30JJT-768x491.png 768w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_R12Yz30JJT-600x384.png 600w\" sizes=\"auto, (max-width: 877px) 100vw, 877px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p>Damos clic en \u00ab<strong><em>Table<\/em><\/strong>\u00bb para expandirla<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"678\" height=\"398\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_0vO9IPmDQp.png\" alt=\"\" class=\"wp-image-173 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_0vO9IPmDQp.png 678w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_0vO9IPmDQp-300x176.png 300w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_0vO9IPmDQp-600x352.png 600w\" sizes=\"auto, (max-width: 678px) 100vw, 678px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p>De esta manera hemos aplicado las transformaciones a los datos.<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"633\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_c0tyuAcA40-1024x633.png\" alt=\"\" class=\"wp-image-174 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_c0tyuAcA40-1024x633.png 1024w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_c0tyuAcA40-300x185.png 300w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_c0tyuAcA40-768x475.png 768w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_c0tyuAcA40-600x371.png 600w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_c0tyuAcA40.png 1168w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"has-large-font-size wp-block-heading\"><strong>Python para crear visualizaciones<\/strong><\/h2>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p>Vamos al men\u00fa de visualizaciones<br>Damos clic en el objeto visual de Python<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"563\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_oq2Wf0kE1Y-1024x563.png\" alt=\"\" class=\"wp-image-180 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_oq2Wf0kE1Y-1024x563.png 1024w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_oq2Wf0kE1Y-300x165.png 300w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_oq2Wf0kE1Y-768x422.png 768w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_oq2Wf0kE1Y-600x330.png 600w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_oq2Wf0kE1Y.png 1148w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\" style=\"grid-template-columns:auto 42%\"><div class=\"wp-block-media-text__content\">\n<p>Se inserta el objeto en el \u00e1rea de visualizaci\u00f3n<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"662\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_UxYejYSeQ3-1024x662.png\" alt=\"\" class=\"wp-image-182 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_UxYejYSeQ3-1024x662.png 1024w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_UxYejYSeQ3-300x194.png 300w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_UxYejYSeQ3-768x496.png 768w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_UxYejYSeQ3-600x388.png 600w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_UxYejYSeQ3.png 1314w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<p>Se arrastran los campos que vamos a usar en el box <em>Valores<\/em> del objeto visual, por lo menos debe haber un campo num\u00e9rico<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"939\" height=\"819\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_brKiWXq7XU.png\" alt=\"\" class=\"wp-image-190 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_brKiWXq7XU.png 939w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_brKiWXq7XU-300x262.png 300w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_brKiWXq7XU-768x670.png 768w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_brKiWXq7XU-600x523.png 600w\" sizes=\"auto, (max-width: 939px) 100vw, 939px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<p>Luego de poner los campos , en la parte de abajo se habilita la ventana para a\u00f1adir el c\u00f3digo<\/p>\n\n\n\n<p>A\u00f1adimos el c\u00f3digo:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>import matplotlib.pyplot as plt<br>dataset.plot(kind='scatter', x='Age', y='Weight, color='red')<br>plt.show()<\/code><\/pre>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"831\" height=\"881\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_mM8UN66QMJ.png\" alt=\"\" class=\"wp-image-187 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_mM8UN66QMJ.png 831w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_mM8UN66QMJ-283x300.png 283w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_mM8UN66QMJ-768x814.png 768w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_mM8UN66QMJ-600x636.png 600w\" sizes=\"auto, (max-width: 831px) 100vw, 831px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<p>Damos clic en el icono de ejecutar<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"391\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_BUfIpbOt7z.png\" alt=\"\" class=\"wp-image-185 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_BUfIpbOt7z.png 512w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_BUfIpbOt7z-300x229.png 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/figure><\/div>\n\n\n\n<div class=\"wp-block-media-text has-media-on-the-right is-stacked-on-mobile\"><div class=\"wp-block-media-text__content\">\n<p>As\u00ed la gr\u00e1fica se visualiza<\/p>\n<\/div><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"598\" height=\"470\" src=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_CPZyPVYiof.png\" alt=\"\" class=\"wp-image-184 size-full\" srcset=\"https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_CPZyPVYiof.png 598w, https:\/\/juegacondatos.com\/wp-content\/uploads\/2023\/03\/brave_CPZyPVYiof-300x236.png 300w\" sizes=\"auto, (max-width: 598px) 100vw, 598px\" \/><\/figure><\/div>\n\n\n\n<p><\/p>\n\n\n\n<p>Tambi\u00e9n puedes ver este contenido en video.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"3 Formas de usar python en Power BI\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/a_Qlzok_Sec?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Python es un lenguaje de programaci\u00f3n muy popular, as\u00ed mismo Microsoft Power BI es la herramienta de creaci\u00f3n de dashboards (Tableros de Control) m\u00e1s popular en el momento de escribir este blog. A continuaci\u00f3n veras c\u00f3mo usar Python dentro de Microsoft Power BI. Existen tres formas: Prerrequisitos Python como fuente de datos En Power BI, [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[16,17],"tags":[],"class_list":["post-16","post","type-post","status-publish","format-standard","hentry","category-power-bi","category-python"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/juegacondatos.com\/index.php\/wp-json\/wp\/v2\/posts\/16","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/juegacondatos.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/juegacondatos.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/juegacondatos.com\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/juegacondatos.com\/index.php\/wp-json\/wp\/v2\/comments?post=16"}],"version-history":[{"count":44,"href":"https:\/\/juegacondatos.com\/index.php\/wp-json\/wp\/v2\/posts\/16\/revisions"}],"predecessor-version":[{"id":193,"href":"https:\/\/juegacondatos.com\/index.php\/wp-json\/wp\/v2\/posts\/16\/revisions\/193"}],"wp:attachment":[{"href":"https:\/\/juegacondatos.com\/index.php\/wp-json\/wp\/v2\/media?parent=16"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/juegacondatos.com\/index.php\/wp-json\/wp\/v2\/categories?post=16"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/juegacondatos.com\/index.php\/wp-json\/wp\/v2\/tags?post=16"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}