4.69 sddsrowstats

• description: sddsrowstats analyzes data across columns on a row-by-row basis to find minima, maxima, averages, standard-deviations, etc. The output is a copy of the input with additional columns that contain the desired statistics.
• examples: Find the mean x and y orbits from PAR beam-position-monitor data collected with one set of x and y values (in 32 columns) per row.

  sddsrowstats par.bpm par.bpm1 -mean=xMean,P?P?x -mean=yMean,P?P?y

• synopsis:

  sddsrowstats [-pipe=[input][,output]] [input] [output] [-nowarnings] [-mean=newName,[,limitOps],columnNameList] [-rms=newName,[,limitOps],columnNameList] [-median=newName[,limitOps],columnNameList] [-minimum=newName[,limitOps],columnNameList] [-maximum=newName[,limitOps],columnNameList] [-standardDeviation=newName[,limitOps],columnNameList] [-sigma=newName[,limitOps],columnNameList] [-mad=newName[,limitOps],columnNameList] [-sum=newName[,limitOps][,power=<integer>],columnNameList] [-drange=newName[,limitOps],columnNameList] [-qrange=newName[,limitOps],columnNameList] [-smallest=newName[,limitOps],columnNameList] [-largest=newName[,limitOps],columnNameList] [-count=newName[,limitOps],columnNameList]

  where columnList is a comma-separated list of one or more optionally wildcarded names and limitOps is of the form [topLimit=value,][bottomLimit=value].

• switches:
  • -pipe=[input][,output] — The standard SDDS Toolkit pipe option.
  • -mean, -rms, median, minimum, maximum, standardDeviation, sigma, mad, drange, qrange, smallest, largest, count — Compute indicated statistic across the columns specified in columnList. If limitOps are given, then values above the topLimit or below the bottomLimit are excluded from computations. sigma is the standard deviation of the mean. mad is the mean-absolute-deviation. smallest (largest) is the minimum (maximum) absolute value. drange and qrange are the decile and quartile ranges, respectively.
  • -sum=newName[,power=integer],columnNameList — Specifies creation of a new column newName containing the row-by-row sums of the columns specified in columnList. The values are summed after being raised to the given power, which is 1 by default.
• see also:
  • Data for Examples
  • sddschanges
  • sddsenvelope
  • sddsprocess
• author: M. Borland, ANL/APS.