• v7.7.0
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
PREVIOUS
Reverse (reverse)
NEXT
Split (split)

Searching data / Building a query / Operations reference / String group / Shannon entropy (shannonentropy)

Download as PDF

Shannon entropy (shannonentropy)

Description

Adds a new column that returns the Shannon entropy of a given string.

How does it work in the search window?

Select Create column in the search window toolbar, then select the Shannon entropy operation. You need to specify one argument:

ArgumentData type
String (mandatory)
string

The data type of the values in the new column is float.

Example

In the demo.ecommerce.data table, we want to create a new column that calculates the Shannon entropy of the strings in our uri column. To do it, we will create a new column using the Shannon entropy operation.

The arguments needed to create the new column are:

  • String - uri column

Click Create column and you will see the following result:


How does it work in LINQ?

Use the operator select... as...  and add the operation syntax to create the new column. This is the syntax for the Shannon entropy operation:

  • shannonentropy(string)

Example

You can copy the following LINQ script and try the above example on the demo.ecommerce.data table. 

from demo.ecommerce.data
  select shannonentropy(uri) as uri_shannonentropy
Download as PDF

PREVIOUS
Reverse (reverse)
NEXT
Split (split)

Export

See what Devo can do for you. Request a demo!
Discover what's new (Release notes)
  • v7.7.0
    • v7.11.0 (latest)
    • v7.10.0
    • v7.9.0
    • v7.8.0
    • v7.7.0
    • v7.6.0
    • v7.5.0
    • v7.3.0
    • v7.2.0
    • v7.1.1
    • v7.1.0
    • v7.0.8
  • Services & Support
  • Devo.com
  • Contact
    • Contact Us
    • Request a Demo
    • Partner Inquiry
  • Log In
    • USA Devo
    • EU Devo
  • +1 888 6830910 (USA)
  • +34 900 838 880 (Spain)
Copyright © 2019 Legal Terms Privacy Policy Cookies Policy

Powered by Confluence and Scroll Viewport