<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Number of rows in dataset for R and Python visual objects in Developer</title>
    <link>https://community.fabric.microsoft.com/t5/Developer/Number-of-rows-in-dataset-for-R-and-Python-visual-objects/m-p/3398980#M53708</link>
    <description>&lt;P&gt;How many rows are sampled in the 'dataset' preloaded object for R and Python visual objects? I have about 2 million rows in my dataset&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;If I insert a ggscatterplot as a R visual object in PowerBI, the number of rows used in my case is 2248,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;This is the R Code:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="c"&gt;library(ggplot2)

color_palette &amp;lt;- colorRampPalette(c("steelblue", "darkblue"))(length(dataset$Accesos))

ggplot(dataset, aes(x = Edad, y = Hora, size = Accesos, alpha = Accesos, color = Accesos)) +
  geom_point(stroke = NA) +
  scale_size_continuous(range = c(2, 10)) +
  scale_alpha_continuous(range = c(0.1, 0.8)) +
  scale_color_gradientn(colors = color_palette) + 
  labs(
      x = "Edad", y = "Hora", 
      title = "Scatterplot Edad/Horas",
      subtitle = paste("Nº de registros", nrow(dataset)))&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;And this is the R visual object result:&lt;BR /&gt;&lt;BR /&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Scatterggplot_2.jpg" style="width: 602px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/960435iD15C7E8D7856A309/image-size/large?v=v2&amp;amp;px=999" role="button" title="Scatterggplot_2.jpg" alt="Scatterggplot_2.jpg" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;But, if I try to insert a python seaborn density plot&amp;nbsp; as a Python visual object...&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The source:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="python"&gt;import pandas as pd
import numpy as np
import seaborn as sns
import matplotlib.pyplot as plt

num_filas = len(dataset)

sns.set(style="white")

sns.kdeplot(data=dataset, x='Hora', y='Edad', fill=True, cmap='viridis', thresh=0, levels=100)

plt.xlabel('Hora')
plt.ylabel('Edad')

plt.title("Grafico de densidad horas-Edad")
plt.suptitle(f"Número de Filas: {num_filas}", y=0.95) 

plt.show()&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The rows included in dataset are just... 24! And, of course, nothing to plot...&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="PythonDensityPlotPowerBI.jpg" style="width: 470px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/960440iC2680637362BE5C2/image-size/large?v=v2&amp;amp;px=999" role="button" title="PythonDensityPlotPowerBI.jpg" alt="PythonDensityPlotPowerBI.jpg" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;It should look like this (same code, in Google Collab)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DensityPython2.png" style="width: 572px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/960441i01C7166FAE9E0D9E/image-size/large?v=v2&amp;amp;px=999" role="button" title="DensityPython2.png" alt="DensityPython2.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Is there someting wrong in my code?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;</description>
    <pubDate>Fri, 25 Aug 2023 11:14:43 GMT</pubDate>
    <dc:creator>Francisco_G_Cal</dc:creator>
    <dc:date>2023-08-25T11:14:43Z</dc:date>
    <item>
      <title>Number of rows in dataset for R and Python visual objects</title>
      <link>https://community.fabric.microsoft.com/t5/Developer/Number-of-rows-in-dataset-for-R-and-Python-visual-objects/m-p/3398980#M53708</link>
      <description>&lt;P&gt;How many rows are sampled in the 'dataset' preloaded object for R and Python visual objects? I have about 2 million rows in my dataset&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;If I insert a ggscatterplot as a R visual object in PowerBI, the number of rows used in my case is 2248,&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;This is the R Code:&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="c"&gt;library(ggplot2)

color_palette &amp;lt;- colorRampPalette(c("steelblue", "darkblue"))(length(dataset$Accesos))

ggplot(dataset, aes(x = Edad, y = Hora, size = Accesos, alpha = Accesos, color = Accesos)) +
  geom_point(stroke = NA) +
  scale_size_continuous(range = c(2, 10)) +
  scale_alpha_continuous(range = c(0.1, 0.8)) +
  scale_color_gradientn(colors = color_palette) + 
  labs(
      x = "Edad", y = "Hora", 
      title = "Scatterplot Edad/Horas",
      subtitle = paste("Nº de registros", nrow(dataset)))&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;And this is the R visual object result:&lt;BR /&gt;&lt;BR /&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Scatterggplot_2.jpg" style="width: 602px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/960435iD15C7E8D7856A309/image-size/large?v=v2&amp;amp;px=999" role="button" title="Scatterggplot_2.jpg" alt="Scatterggplot_2.jpg" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;But, if I try to insert a python seaborn density plot&amp;nbsp; as a Python visual object...&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;The source:&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;LI-CODE lang="python"&gt;import pandas as pd
import numpy as np
import seaborn as sns
import matplotlib.pyplot as plt

num_filas = len(dataset)

sns.set(style="white")

sns.kdeplot(data=dataset, x='Hora', y='Edad', fill=True, cmap='viridis', thresh=0, levels=100)

plt.xlabel('Hora')
plt.ylabel('Edad')

plt.title("Grafico de densidad horas-Edad")
plt.suptitle(f"Número de Filas: {num_filas}", y=0.95) 

plt.show()&lt;/LI-CODE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;The rows included in dataset are just... 24! And, of course, nothing to plot...&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="PythonDensityPlotPowerBI.jpg" style="width: 470px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/960440iC2680637362BE5C2/image-size/large?v=v2&amp;amp;px=999" role="button" title="PythonDensityPlotPowerBI.jpg" alt="PythonDensityPlotPowerBI.jpg" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;It should look like this (same code, in Google Collab)&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="DensityPython2.png" style="width: 572px;"&gt;&lt;img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/960441i01C7166FAE9E0D9E/image-size/large?v=v2&amp;amp;px=999" role="button" title="DensityPython2.png" alt="DensityPython2.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Is there someting wrong in my code?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;</description>
      <pubDate>Fri, 25 Aug 2023 11:14:43 GMT</pubDate>
      <guid>https://community.fabric.microsoft.com/t5/Developer/Number-of-rows-in-dataset-for-R-and-Python-visual-objects/m-p/3398980#M53708</guid>
      <dc:creator>Francisco_G_Cal</dc:creator>
      <dc:date>2023-08-25T11:14:43Z</dc:date>
    </item>
  </channel>
</rss>

