Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live!

SOLVED

Kertosis and Skewness

Highlighted
7 - Meteor

Other than going to the raw math, anyone figure out how to obtain Kertosis and Skewness measures of a univariate distribution? Macro?

Highlighted
16 - Nebula
16 - Nebula

Easiest and quickest way I can think of is to use Python:

 

First get packages:

from ayx import Package
Package.installPackages(['pandas','scipy'])

Next:

from ayx import Alteryx
import scipy.stats
import pandas as pd
a = Alteryx.read('#1')
kurt = scipy.stats.kurtosis(a['Field1'])
skew = scipy.stats.skew(a['Field1'])
d = {'kurt': [kurt], 'skew': [skew]}
df = pd.DataFrame(data=d)
Alteryx.write(df,1)

Simple workflow using this attached.

Highlighted
7 - Meteor

Good idea - now to figure out Python. I see a few Python help's in the community so I'll check them out. 

Thanks!

Labels