R flavoured Kmeans algorithm in Power Query

100%

R flavoured Kmeans algorithm in Power Query

✓ Published0🌍 Public

Last edited Mar 9, 2017

Created on Mar 9, 2017

This example demonstrates the R-flavored K-means clustering algorithm executed directly within Power Query, using the iris dataset’s petal width and length columns to assign cluster memberships. The visualization shows the resulting iris data points colored by their assigned cluster, with the clustering computed in R via the `kmeans` function and seeded for reproducibility. The Power Query M code invokes the R engine through the `R.Execute` API, passing a script that runs K-means with three centers and twenty random starts, then returns the augmented table containing the cluster labels. The underlying data originates from the built-in iris dataset, and the rendering relies on Power Query’s native table output, not a separate charting library.

AI-generated description

Similar vizzes

Loading thumbnail…

KMeans clustering call in DAX Power BI desktop 3D

This example demonstrates a 3D KMeans clustering visualization built directly in DAX for Power BI, using the Iris dataset’s numeric columns (Column6, Column7, Column8). It shows how raw table columns are summarized and then passed into the custom `KMeansClustering` DAX function, which assigns each data point to a cluster and returns a cluster ID alongside the original attributes. The code explicitly constructs a DAX query with `SUMMARIZECOLUMNS` and `SELECTCOLUMNS` to shape the data, then calls `KMeansClustering` with parameter lists defining attribute roles and output columns. The rendering approach is not visible here, but the focus is on the algorithmic clustering step within Power BI’s DAX engine.

HHugoberry

76% match

Loading thumbnail…

Gist 599b117350a329c9046f68ae0ce1e21a

This example visualizes a k-means clustering result over a set of data points, showing how the algorithm partitions the space into distinct clusters based on two measured attributes. The chart is generated from a Power BI DAX query that first summarizes the source table `Query1` by summing the X and Y values for each category Z, then feeds those aggregated coordinates into the `KMeansClustering` function. The output assigns a `ClusterId` to each point, which the visualization likely encodes through color or position. The rendering relies on Power BI’s built-in visual engine rather than a custom JavaScript library, as no D3 or Canvas code appears in the provided DAX.

HHugoberry

72% match

Loading thumbnail…

Using R.Execute() in Power Query to export the contents of a table to CSV

This example demonstrates how to use R.Execute() in Power Query to export a table’s contents to a CSV file. The code generates a seed list of numbers from 1 to 1,000,000, converts it into a table, and then passes that dataset to R’s write.csv() function via the R.Execute() API. The R script writes the data to a specified file path. The visualization highlights the integration between Power Query and R, showing how R’s data-export capabilities can be invoked directly within a query pipeline, without additional manual steps.

HHugoberry

64% match

Loading thumbnail…

A worked example of using the undocumented DAX function KMeansClustering

This example demonstrates how to cluster a set of labeled numeric values using the undocumented DAX function `KMeansClustering`, which partitions the sample data into groups based on their attribute values. The visualization shows the resulting cluster assignments for each item, with the function called directly in a DAX query. The code supplies a table of letter-value pairs, specifies the column mappings for the attribute and item labels, and requests cluster IDs as output. The clustering runs with a parameter of -1, indicating automatic determination of the number of clusters, and the result appears as a table of items paired with their assigned cluster identifiers.

HHugoberry

63% match

Loading thumbnail…

K-means clustering in DAX

This example demonstrates a K-means clustering implementation written in DAX, showing how to group items into clusters based on multiple numeric attributes. The code computes a transformed table using `SUMMARIZECOLUMNS` to aggregate attribute values per item, then passes that table to a custom `KMeansClustering` function. The function assigns each item a `ClusterId` while preserving the original item labels. The visualization highlights the resulting clusters, with the DAX code serving as the core analytical engine rather than relying on a JavaScript library. The source is a gist by Hugoberry, and the rendering approach is not visible here, so the focus remains on the clustering logic and the data transformation pipeline.

HHugoberry

62% match

Loading thumbnail…

R Regex matching of mentions in twitts. with Power Query and R

This example demonstrates how to extract regex-matched mentions (prefixed with `#` or `@`) from Twitter text using R within a Power Query workflow. The visualization shows the original tweets alongside a new `mention` column containing the first matched term. The solution uses the `R.Execute` function to run an R script that applies `regmatches` and `regexpr` with the pattern `[#@]\w+` across the `text` column. The R script processes the dataset provided by Power Query, leveraging R's base string manipulation functions. The data originates from a CSV file loaded via `Csv.Document`, with the final result passed back to Power Query through the `[Name="temp"]` output.

HHugoberry

62% match

Loading thumbnail…

Writing 10M lines of a query result to a table in Power Query via R

This example demonstrates how to write 10 million rows of a query result to a CSV file from Power Query by invoking an R script. It shows the integration of Power Query’s table generation with R’s file-export capabilities, specifically using the `R.Execute` function to run `write.csv` on a dataset. The Power Query code creates a list of numbers from 1 to 10,000,000 via `{1..10000000}`, converts it to a table with `Table.FromList`, and passes that table as the `dataset` parameter to the R script. The R script then writes the data to `d:\Downloads\out.csv`.

HHugoberry

62% match

Loading thumbnail…

K means clustering

This example shows the k-means clustering algorithm in action, animating the iterative process of grouping a small set of points from `data.csv` into three clusters. Initially, three randomly placed centroids are drawn, and each iteration assigns points to the nearest centroid using Euclidean distance, then moves the centroids to the cluster mean. The visualization uses D3 v6’s selection and `transition` methods to animate the points and centroids, with the centroid styled distinctly via a black stroke. The iteration count is displayed as text, and the animation stops after ten iterations.

Kkaviya-ds

60% match