Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance during the next 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

Kertosis and Skewness

Highlighted
Meteor

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

Highlighted

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