I'm working with a dataset from my astronomy research. I've been calculating the median and mean for a column by counting the number of rows and summing them. Is there better way to do this?
There is also the Profile function which can be performed on any column in Xcalar Design.Here is the documentation on this function: https://www.xcalar.com/documentation/help/XD/1.2.2/Content/B_CommonTasks/E_CountOccurrencesOfValues.htm
It will calculate the mean and median for you. The median is the value for the 50% quartile.