Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Connect Discussions

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

Data profiling

Dataguy777
5 - Atom

Hi, I am doing some basic profiling and not sure how to calculate Average Value, Median Value and Std deviation on a string data type file. The file I have is mostly string value hence struggling to do calculation. Thanks 

4 REPLIES 4
RSreeSurya
9 - Comet

Hi @Dataguy777 ,

 

Could you please share your sample data file. 

Yoshiro_Fujimori
15 - Aurora

@Dataguy777 ,

 

Average, Median, Std are applicable to quantitative data, but not to categorical data.

So if you want to deal with them, you would need to convert the strings to numeric values in some way.

Good luck.

Dataguy777
5 - Atom

Thank you for your reply. Please see the file here. Thanks for the help. Basically I am very new to the Alteryx and need to calculate these on this data set.

Null Detection
Blank Detection
Zero Detection
Uniqueness (Excludes blanks,  nulls and zeros)
Net Uniqueness (Excludes blanks,  nulls and zeros)
Average character count
Mean Character Count (Mean and Ave is the same)
Average Value
Median Value
Std Deviation Character count
Std Deviation
Special Character 
Unique Defined Sets
Frequency
Yoshiro_Fujimori
15 - Aurora

Thanks for the data.

You may want to check the tools in Data Investigation category. 

 

Here are good articles on these tools.

Pre-Predictive: Using the Data Investigation Tools - Part 1 of 4 

Pre-Predictive: Using the Data Investigation Tools - Part 2 of 4 

Pre-Predictive: Using the Data Investigation Tools - Part 3 of 4 

Pre-Predictive: Using the Data Investigation Tools - Part 4 of 4 

 

These tools are purposed to serve the data investigation before analysis.

If you do not find what you need, you may DIY it with other tools.