cluster rows calc extension Cluster Rows

Tags: Calc Extensions

Rating: ★ ★ ★ ★ ★

A LibreOffice Calc extension that clusters the rows in a table and color them to indicate the clusters.

cluster rows calc extension 585f8b5e 85d9 4d8c bbc2 faf8f3c69fa4

Description

A LibreOffice Calc extension that clusters the rows in a table and color them to indicate the clusters.

To use this extension on some data in a sheet in LibreOffice, place the cursor on any cell inside your table with data ( no need to select the whole table ) and go to the menu Clustering, and click on "Cluster rows and color them". The rows are colored with respect to the cluster assignment. Two new columns [ClusterId and Confidence] are added to the right of the table. ClusterId specifies the cluster to which the row is assigned and Confidence indicates the algorithm's confidence in scale [0,1] that this cluster assignment may be correct (higher number means higher confidence).

The project uses an in-house implementation of Expectation Maximization algorithm to compute the clusters. It chooses the number of clusters parameter via Bayesian information criterion.

The project is under heavy development, but is usable. Whole of the project was written from scratch and it does not depend on any Machine Learning or Linear Algebra library. Full source code is made available under GPL3 license. If you are interested in understanding how to build LibreOffice extensions like this, I have a blog for that at https://niocs.github.io/LOBook/extensions/index.html.

Homepage: https://github.com/dennisfrancis/ClusterRows

Release List

  • Release Description Compatibility Operating Systems License Release notes  
  • 0.1.0 First release of a LibreOffice Calc extension that clusters the rows in a table and color them to indicate the clusters. 4.0 Linux GPL

    A major issue is that the prebuilt extension (.oxt file) supports only modern GNU/Linux 64 bit systems comparable to Fedora 24. However support for MS Windows and MacOSX is planned. Another caveat is that for the extension to work, at least 10 samples(rows) are needed in the table.

    Download

Feedback

★ ★ ★ ★ ★

Post your review

Reviews

  • roussel Oct 6, 2020, 6:27 PM (54 days ago)

    ★ ★ ★ ★ ★

    j aime bien cete aplis

RSS feed for reviews on this page | RSS feed for all reviews