ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Discussions

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

Kertosis and Skewness

SteveP
7 - Meteor

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

jdunkerley79
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.

SteveP
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