Kertosis and Skewness
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Other than going to the raw math, anyone figure out how to obtain Kertosis and Skewness measures of a univariate distribution? Macro?
Solved! Go to Solution.
- Labels:
- Data Investigation
- Macros
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Good idea - now to figure out Python. I see a few Python help's in the community so I'll check them out.
Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you help me modify the Python code to pass in another field to subgroup by when doing the kurtosis and skew calculations? Output would be 1 row per subgroup_value, with 3 fields in each row: subgroup_value, kurtosis, skew.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Super - worked flawlessly! Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Has anyone experienced error messages when using a python tool in a macro? I'm trying to calculate the Skew for each product. The python script in this thread works when I run it by itself, but I'm running into a roadblock when applying it to a macro.
Thanks!
Jon
