Altaxo user manual and class reference
Altaxo class reference
Altaxo Namespaces
Altaxo.Calc Namespaces
Altaxo.Calc.Regression.Multivariate
WorksheetAnalysis Class
WorksheetAnalysis Methods
CalculateAdditionalColumn Method
CalculateAdditionalColumns Method
CalculateAndStorePredictionScores Method
CalculateCrossPredictedAndResidual Method
CalculateCrossPredictedY Method
CalculateCrossPRESS Method
CalculatePredictedAndResidual Method
CalculatePredictedY Method
CalculatePredictionScores Method
CalculatePreprocessedSpectra Method
CalculateXLeverage Method
CalculateXResidual Method
CalculateYPredicted Method
CalculateYResidual Method
CreateNewRegressionObject Method
EnsureMatchingXOfX Method
ExecuteAnalysis Method
GetCalibrationModel Method
GetCrossPRESSValue_ColumnName Method
GetCrossProduct_ColumnName Method
GetMeasurementLabel_ColumnName Method
GetNumberOfFactors_ColumnGroup Method
GetNumberOfFactors_ColumnName Method
GetOriginalY Method
GetPredictionScore_ColumnGroup Method
GetPredictionScore_ColumnName Method
GetPRESSValue_ColumnName Method
GetRawSpectra Method
GetXCrossResidual_ColumnGroup Method
GetXCrossResidual_ColumnName Method
GetXLeverage_ColumnGroup Method
GetXLeverage_ColumnName Method
GetXLoad_ColumnName Method
GetXMean_ColumnName Method
GetXOfSpectra Method
GetXOfX_ColumnName Method
GetXResidual_ColumnGroup Method
GetXResidual_ColumnName Method
GetXScale_ColumnName Method
GetXScore_ColumnName Method
GetXWeight_ColumnName Method
GetXYMatricesOfSpectralColumns Method
GetYCrossPredicted_ColumnGroup Method
GetYCrossPredicted_ColumnName Method
GetYCrossResidual_ColumnGroup Method
GetYCrossResidual_ColumnName Method
GetYLoad_ColumnName Method
GetYMean_ColumnName Method
GetYOriginal_ColumnName Method
GetYPredicted_ColumnGroup Method
GetYPredicted_ColumnName Method
GetYResidual_ColumnGroup Method
GetYResidual_ColumnName Method
GetYScale_ColumnName Method
IsDimensionReductionAndRegressionModel Method
MapSpectralX Method
NotFound Method
PredictValues Method
RemoveNonNumericCells Method
StoreCalculatedColumn Method
StoreCalibrationModelInTable Method
StoreFRatioData Method
StoreNumberOfFactors Method
StoreOriginalY Method
StorePreprocessedData Method
StorePRESSData Method
StoreXOfX Method
Click or drag to resize

WorksheetAnalysisRemoveNonNumericCells Method

For given selected columns and selected rows, the procedure removes all nonnumeric cells. Furthermore, if either selectedColumns or selectedRows is empty, the collection is filled by the really used rows/columns.

Namespace: Altaxo.Calc.Regression.Multivariate
Assembly: AltaxoBase (in AltaxoBase.dll) Version: 4.8.3179.0 (4.8.3179.0)
Syntax
C#
Copy
public static void RemoveNonNumericCells(
	DataTable srctable,
	AscendingIntegerCollection selectedRows,
	AscendingIntegerCollection selectedColumns
)

Parameters

srctable  DataTable
The source table.
selectedRows  AscendingIntegerCollection
On entry, contains the selectedRows (or empty if now rows selected). On output, is the row collection.
selectedColumns  AscendingIntegerCollection
On entry, conains the selected columns (or emtpy if only rows selected). On output, contains all numeric columns.
See Also