Splunk Search

Hello experts, I would like to calculate the pearson correlation between all my fields ?

New Member

I visited the documentation and I see that we can only compute the pearson correlation between two fields at a time with command |score pearsonr field_a against field_b . How can I computer the pearson correlation between all the fields in my data ? Assuming I have a dataset with 5 columns, my output should give me 32 pairs of pearson correlations.

In a programming language this can be easily coded with a double for loop. I am wondering how to do this in splunk.

Thank you

Tags (2)
0 Karma


Hi Faisal,

I managed to do that yesterday following these steps from the MLTK documentation:


Hope it helps!

0 Karma