Profile Summary
Generated 04-Jun-2021 04:11:04 using performance time.
Function NameCallsTotal TimeSelf Time*Total Time Plot
(dark band = self time)
script9173.079 s0.876 s
computecost37766.469 s19.468 s
tabular.subsref113477146.358 s6.178 s
tabular.subsrefDot102642524.885 s15.699 s
tabular.subsrefParens7059512.657 s6.344 s
categorical.subsref6183107.295 s2.260 s
categorical.parenReference7577046.282 s5.143 s
...mension>tabularDimension.subs2inds2254604.484 s1.770 s
categorical.ne2691153.332 s1.832 s
varNamesDim>varNamesDim.subs2inds1104292.802 s0.809 s
tabular.subsrefBraces377542.654 s0.721 s
@categorical\private\reconcileCategories3438051.976 s1.976 s
...ension>tabularDimension.selectFrom1088591.941 s1.666 s
table.table>table.cloneAsEmpty705951.728 s0.811 s
isScalarInt10264181.625 s1.625 s
varNamesDim>varNamesDim.selectFrom382641.071 s0.260 s
categorical.eq746901.029 s0.553 s
table.table>table.table713900.960 s0.319 s
parenReference_1D6183100.790 s0.790 s
getrowmostcost40.730 s0.216 s
tabular.tabular>tabular.tabular713900.616 s0.493 s
tabular.subsasgn13070.598 s0.018 s
readtable20.481 s0.006 s
...ExecutableFunction.validateAndExecute20.473 s0.004 s
tabular.subsasgnBraces7850.457 s0.069 s
ReadTable>ReadTable.execute20.398 s0.005 s
getrowcost20.380 s0.115 s
computenumber20.363 s0.110 s
parenReference_2D1393940.348 s0.348 s
tabular.subsasgnParens12920.341 s0.144 s
tabular.numArgumentsFromSubscript1755560.322 s0.322 s
rowNamesDim>rowNamesDim.orientAs1847010.243 s0.243 s
...ptions>DetectImportOptions.execute20.225 s0.003 s
getneighborsof20.225 s0.037 s
...etectImportOptionsSpreadsheet.execute20.221 s0.005 s
categorical.ismatrix1398950.218 s0.218 s
varNamesDim>varNamesDim.orientAs1486950.186 s0.186 s
...rtOptionsSpreadsheet.getOptsFromSheet20.185 s0.022 s
isColon1512410.157 s0.157 s
...gt;ReadTableWithImportOptions.execute20.153 s0.001 s
...larDimension.validateNativeSubscripts56680.152 s0.098 s
...eWithImportOptionsSpreadsheet.execute20.152 s0.001 s
...eadTableWithImportOptions.executeImpl20.151 s0.001 s
...hImportOptionsSpreadsheet.executeImpl20.150 s0.012 s
repmat8130.145 s0.052 s
tabular.subsasgnDot8000.143 s0.055 s
isUniqueNumeric386340.125 s0.125 s
...adCompatibility.saveLoadCompatibility713900.123 s0.123 s
tabular.height567540.104 s0.104 s
ReadTable>ReadTable.validate20.069 s0.001 s
...tions>DetectImportOptions.validate20.068 s0.003 s
readSpreadsheet20.067 s0.009 s
isText56930.057 s0.057 s
ReadTable>ReadTable.buildTableFromData20.055 s0.005 s
...t;SpreadsheetImportOptions.getNumVars100.052 s0.001 s
...>ImportOptions.get.VariableOptions100.051 s0.001 s
FastVarOpts>FastVarOpts.getVarOpts100.050 s0.008 s
tabular.sortrows30.042 s0.006 s
...nction>ExecutableFunction.validate20.042 s0.002 s
...;ExecutableFunction.validateArguments20.040 s0.007 s
varNamesDim>varNamesDim.lengthenTo7850.036 s0.026 s
...ns>ImportOptions.set.VariableTypes20.034 s0.001 s
...eadsheetInputs.set.VariableNamesRange20.034 s0.001 s
tabular.horzcat20.034 s0.015 s
varNamesDim>varNamesDim.makeValidName15860.033 s0.016 s
FastVarOpts>FastVarOpts.setTypes40.033 s0.006 s
...mension>tabularDimension.setLabels330.033 s0.006 s
table.table>table.init20.031 s0.003 s
ismember130.030 s0.006 s
makeUniqueStrings490.029 s0.015 s
...;AcceptsReadableFilename.set.Filename20.028 s0.001 s
...gt;HasPropertiesAsNVPairs.parseInputs470.028 s0.016 s
tabular.tabular>tabular.initInternals100.026 s0.003 s
...eptsReadableFilename.validateFilename20.026 s0.002 s
FastVarOpts>getTypedOpts300.026 s0.003 s
readSpreadsheet>handleDataRange20.025 s0.005 s
...ension>tabularDimension.createLike220.023 s0.003 s
...ategorical>categorical.categorical30.023 s0.011 s
ismember>ismemberR2012a130.023 s0.005 s
tabular.sortrowsFlagChecks30.020 s0.005 s
...portOptions.TextVariableImportOptions300.019 s0.004 s
validateFileName20.019 s0.003 s
tabular.size39370.018 s0.018 s
readSpreadsheetVariable110.018 s0.002 s
...t;varNamesDim.validateAndAssignLabels140.017 s0.005 s
varNamesDim>varNamesDim.createLike120.017 s0.002 s
validatestring230.017 s0.002 s
...Dim>varNamesDim.checkReservedNames23830.017 s0.011 s
ismember>ismemberClassTypes30.016 s0.005 s
...eType>AcceptsFileType.set.FileType20.015 s0.001 s
...tOptions.NumericVariableImportOptions150.015 s0.003 s
tabular.setProperty120.015 s0.008 s
makeValidName60.014 s0.003 s
tabular.getVarOrRowLabelIndices30.014 s0.002 s
unique90.014 s0.007 s
...riable>readTextSpreadsheetVariable80.014 s0.008 s
validatestring>checkString230.013 s0.003 s
...Spreadsheet.setNonDetectionProperties20.013 s0.001 s
fullfile40.013 s0.005 s
categorical.parenAssign5070.012 s0.012 s
detectTypes20.012 s0.005 s
...mportOptions.SpreadsheetImportOptions20.012 s0.002 s
readSpreadsheet>readDataFromSheet20.012 s0.005 s
cell.ismember20.012 s0.003 s
FastVarOpts>FastVarOpts.get.Names200.012 s0.002 s
UsesWorksheet>UsesWorksheet.openBook20.012 s0.002 s
setxor20.010 s0.001 s
...n)makeValid(n,@replaceWithUnderscore)50.010 s0.001 s
attributes20.010 s0.002 s
createWorkbook20.010 s0.002 s
setxor>setxorR2012a20.009 s0.002 s
categorical.iscolumn53900.009 s0.009 s
...me>getMakeValidFcnHandle/makeValid50.009 s0.005 s
...ons>ImportOptions.getVarOptsStruct40.008 s0.001 s
categorical.size5130.008 s0.008 s
cell.unique60.008 s0.004 s
makeUniqueStrings>makeUnique330.008 s0.008 s
...ts>SpreadsheetInputs.set.DataRange20.008 s0.001 s
createWorkbook>constructWorkbook20.008 s0.008 s
FastVarOpts>FastVarOpts.getVarOptsStruct40.007 s0.003 s
...e>AcceptsFileType.getFileTypeFirst20.007 s0.003 s
...eadsheetInputs.set.VariableUnitsRange20.007 s0.001 s
metaDim>metaDim.checkAgainstVarLabels140.007 s0.001 s
...t;SpreadsheetInputs.validateDataRange20.007 s0.001 s
unique>uniqueR2012a90.007 s0.007 s
...t;SpreadsheetInputs.set.RowNamesRange20.007 s0.001 s
fileparts80.006 s0.003 s
readSpreadsheet>handleReplacement20.006 s0.001 s
substruct7880.006 s0.006 s
categorical.cellstr2780.006 s0.006 s
...bularDimension.checkReservedNamesImpl23940.006 s0.006 s
...r>ArgumentParser.canonicalizeNames40.005 s0.004 s
...t;rowNamesDim.validateAndAssignLabels160.005 s0.003 s
...eet>handleReplacement/processRules10.005 s0.003 s
...tabularDimension.checkDuplicateLabels240.005 s0.005 s
rowNamesDim>rowNamesDim.lengthenTo7850.005 s0.005 s
...rtOptionsSpreadsheet>getHeaderRows20.005 s0.003 s
...gt;AcceptsSheetNameOrNumber.set.Sheet40.005 s0.001 s
...tInputs.set.VariableDescriptionsRange20.005 s0.001 s
strcat20.005 s0.004 s
...tectImportOptions.set.EmptyColumnType20.005 s0.001 s
...tParser>ArgumentParser.extractArgs20.005 s0.005 s
varNamesDim>varNamesDim.assignInto40.004 s0.001 s
ismember>ismemberBuiltinTypes130.004 s0.004 s
...ons>ImportOptions.set.NumVariables20.004 s0.001 s
cell.unique>celluniqueR2012a60.004 s0.004 s
validateVariableNameLength16010.004 s0.004 s
metaDim>metaDim.validateAndAssignLabels30.004 s0.002 s
attributes>checkAttrs20.004 s0.002 s
tabular.tabular>tabular.createVariables20.004 s0.002 s
...rtOptions>ImportOptions.setvartype20.004 s0.002 s
HasPropertiesAsNVPairs>getParserByClass470.004 s0.004 s
...leImportOptions.VariableImportOptions450.004 s0.002 s
...xtVariableImportOptions.getOptsStruct50.004 s0.000 s
VarOptsInputs>VarOptsInputs.set.Type300.004 s0.002 s
...tInputs>SpreadsheetInputs.setSheet40.004 s0.001 s
...gt;AcceptsSheetNameOrNumber.get.Sheet80.004 s0.004 s
SpreadsheetInputs>validateRange100.004 s0.002 s
mode40.004 s0.004 s
fileparts>legacyPCExecution80.004 s0.004 s
attributes>checkInputs20.003 s0.001 s
...;VariableImportOptions.makeOptsStruct50.003 s0.001 s
FastVarOpts>FastVarOpts.FastVarOpts20.003 s0.002 s
tabular.lengthenTo7850.003 s0.003 s
...Strings>validateExclStrOrElemToChk320.003 s0.002 s
readSpreadsheet>readRowNames10.003 s0.001 s
tabular.getProperty60.003 s0.003 s
...Inputs>VarOptsInputs.set.FillValue150.003 s0.001 s
tabular.dotParenReference60.003 s0.002 s
readSpreadsheet>readVariableMetadata20.003 s0.001 s
compose240.003 s0.003 s
readSpreadsheet>parseArguments20.003 s0.002 s
...;DetectImportOptions.setVariableProps20.003 s0.002 s
erase50.003 s0.002 s
varNamesDim>varNamesDim.moveProps40.003 s0.002 s
processRawFill30.003 s0.002 s
FastVarOpts>getOptsStructWithDefaults120.003 s0.003 s
repmat>checkSizesType16160.003 s0.003 s
parseArgsTabularConstructors20.003 s0.003 s
ismissing20.003 s0.001 s
metaDim>metaDim.metaDim20.002 s0.001 s
...ble>readNumericSpreadsheetVariable30.002 s0.002 s
tabular.tabular>tabular.countVarInputs80.002 s0.002 s
...sion>tabularDimension.assignLabels240.002 s0.002 s
generateArgumentDescriptor20.002 s0.002 s
isCharString890.002 s0.002 s
...>NumericVarOptsInputs.setFillValue150.002 s0.001 s
readSpreadsheet>getDataRange20.002 s0.001 s
rowNamesDim>rowNamesDim.makeValidName80.002 s0.001 s
VarOptsInputs>VarOptsInputs.get.Type450.002 s0.002 s
parseArgs30.002 s0.002 s
ismissingKernel20.002 s0.001 s
...eadsheet>checkWrongParamsWrongType20.002 s0.001 s
...Inputs>VarOptsInputs.VarOptsInputs450.002 s0.001 s
...ionsSpreadsheet.getRangeFromUsedRange20.002 s0.002 s
strip20.002 s0.001 s
tabular.horzcat>getTemplate40.002 s0.001 s
...ptions>ImportOptions.ImportOptions20.002 s0.001 s
...eNamesInput.set.PreserveVariableNames40.002 s0.001 s
fullfile>refinePath40.002 s0.001 s
FastVarOpts>FastVarOpts.fixSelection40.002 s0.002 s
...ableImportOptions.addTypeSpecificOpts50.002 s0.002 s
validateNVPairs20.002 s0.001 s
tabular.matchPropertyName180.002 s0.001 s
VarOptsInputs>VarOptsInputs.set.Name300.002 s0.002 s
...portOptionsSpreadsheet>getCellName40.001 s0.001 s
tabular.subsasgnBraces>@(x)size(x,2)7850.001 s0.001 s
...re>FunctionStore.getFunctionByName20.001 s0.001 s
assertUnsupportedParamsForFileType40.001 s0.001 s
makeUniqueStrings>truncateString260.001 s0.001 s
tabular.mergeArrayProps40.001 s0.001 s
...ctedScalartext',msgId,argname,argpos)20.001 s0.000 s
subRange100.001 s0.001 s
readtable>@()func.WorkSheet.clear()20.001 s0.001 s
...etaDataFromDetection.setMetaLocations20.001 s0.001 s
ReadTable>ReadTable.getExtensions20.001 s0.000 s
varNamesDim>varNamesDim.setUnits20.001 s0.001 s
makeValidName>getMakeValidFcnHandle50.001 s0.001 s
fullfile>ensureTrailingFilesep40.001 s0.000 s
detectTypes>getDominantType20.001 s0.001 s
...>metaDim.fixLabelsForCompatibility30.001 s0.001 s
varNamesDim>varNamesDim.setDescrs20.001 s0.001 s
warningWithoutTrace20.001 s0.001 s
validatestring>checkInputs230.001 s0.001 s
median20.001 s0.001 s
tabularDimension>tabularDimension.init20.001 s0.001 s
...ns>ImportOptions.get.VariableNames80.001 s0.000 s
tabular.getVarOrRowLabelData30.001 s0.001 s
...tsInputs>TextVarOptsInputs.setType150.001 s0.000 s
attributes>checkClass20.001 s0.001 s
...Dim>rowNamesDim.checkReservedNames80.001 s0.001 s
ArgumentParser>ArgumentParser.checkAlias20.001 s0.001 s
...Type>AcceptsFileType.getExtensions20.001 s0.000 s
...ableNamesInput.set.VariableNamingRule40.001 s0.001 s
strfun\private\isTextStrict310.001 s0.001 s
columnLetter50.001 s0.001 s
...nsion>tabularDimension.emptyLabels20.001 s0.001 s
...)max([0,find(~blanks(i,:),1,'last')])3210.001 s0.001 s
FunctionStore>accessMap20.001 s0.001 s
...etectImportOptions.set.NumHeaderLines20.001 s0.001 s
cellstr20.001 s0.001 s
validateFileName>localUnique40.001 s0.001 s
attributes>valueAttributor20.001 s0.000 s
str...te\convertStringToOriginalTextType70.001 s0.001 s
...mportOptions>getSuppliedProperties40.001 s0.001 s
partialMatchString80.001 s0.001 s
...portOptions.get.SelectedVariableNames20.001 s0.001 s
...nputs>NumericVarOptsInputs.setType150.001 s0.001 s
attributes>findSupportedAttr20.001 s0.001 s
istabular100.001 s0.001 s
UsesWorksheet>UsesWorksheet.clear20.001 s0.001 s
fullfile>addTrailingFileSep40.001 s0.001 s
...ricVarOptsInputs.NumericVarOptsInputs150.001 s0.001 s
fullfile>fixIRI40.001 s0.001 s
...gt;ExecutableFunction.get.NumRequired40.001 s0.001 s
isIntegerVals20.001 s0.001 s
UsesWorksheet>UsesWorksheet.openSheet20.001 s0.001 s
...ns>ImportOptions.useGeneratedNames20.001 s0.001 s
...t;ImportOptions.setUnboundedSelection20.001 s0.001 s
str2double10.001 s0.001 s
...ension>tabularDimension.assignInto40.001 s0.001 s
...eadsheet>checkWrongParamsWrongType20.001 s0.000 s
...sNVPairs.assertNoAdditionalParameters470.001 s0.001 s
...mportOptionsSpreadsheet.usingRowNames10.001 s0.001 s
getExtension20.001 s0.000 s
...eNamesInput.get.PreserveVariableNames80.001 s0.001 s
...rtiesAsNVPairs.HasPropertiesAsNVPairs470.001 s0.001 s
categorical.countcats60.001 s0.001 s
varNamesDim>varNamesDim.setCustomProps60.001 s0.001 s
SpreadsheetInputs>SingleRecordNumVars20.001 s0.001 s
SpreadsheetInputs>NumVars20.000 s0.000 s
...uts>TextVarOptsInputs.getFillValue50.000 s0.000 s
...t;SpreadsheetInputs.SpreadsheetInputs20.000 s0.000 s
...ogicalScalar(rhs,'ReadVariableNames')20.000 s0.000 s
FastVarOpts>FastVarOpts.setVarNames20.000 s0.000 s
metaDim>metaDim.checkReservedNames30.000 s0.000 s
...;FileExtensions.getExtensionsFromType20.000 s0.000 s
...ImportOptionsSpreadsheet.setFileProps20.000 s0.000 s
isScalarText180.000 s0.000 s
...eValidFcnHandle/replaceWithUnderscore50.000 s0.000 s
...leExtensions.getFileTypeFromExtension20.000 s0.000 s
...ayProps>mergeNonemptyScalarStructs40.000 s0.000 s
iskeyword70.000 s0.000 s
columnNumber10.000 s0.000 s
...queStrings>validateMaxStringLength260.000 s0.000 s
...VariableNamesInput.validateNamingRule40.000 s0.000 s
FastVarOpts>FastVarOpts.numVars20.000 s0.000 s
SpreadsheetInputs>SingleVariable10.000 s0.000 s
ismissingKernel>arraySwitch20.000 s0.000 s
...arOpts>CommonVarOpts.CommonVarOpts450.000 s0.000 s
missing>missing.string20.000 s0.000 s
isdatetime30.000 s0.000 s
...|(ischar(x)&&size(x,1)<=1)20.000 s0.000 s
...eatAsMissingInput.TreatAsMissingInput450.000 s0.000 s
blanks20.000 s0.000 s
FastVarOpts>FastVarOpts.get.Types20.000 s0.000 s
validateNVPairs>isNonEmptyScalarText10.000 s0.000 s
createWorkbook>initLibrary20.000 s0.000 s
DetectImportOptions>validateScalarInt20.000 s0.000 s
isduration30.000 s0.000 s
varNamesDim>fillEmptyNames20.000 s0.000 s
iscategorical30.000 s0.000 s
mustBeNonnegative20.000 s0.000 s
tabular.width20.000 s0.000 s
validateLogical60.000 s0.000 s
ArgumentParser>matchPartial20.000 s0.000 s
categorical.categories80.000 s0.000 s
....categorical>categorical.castCodes30.000 s0.000 s
...;AcceptsReadableFilename.get.Filename40.000 s0.000 s
...nputs>NumericVarOptsInputs.getType300.000 s0.000 s
tabular.sortrowsFlagChecks>msgidHelper30.000 s0.000 s
categorical.categorical>removeUtil20.000 s0.000 s
fullfile>@(x)~iscell(x)&&isempty(x)40.000 s0.000 s
makeValidName>@(token_1)upper(token_1)110.000 s0.000 s
...ns>ImportOptions.namesAreGenerated20.000 s0.000 s
pwd40.000 s0.000 s
readSpreadsheet>validateLogicalScalar80.000 s0.000 s
categorical.categorical>isNVpair10.000 s0.000 s
...t;TextVarOptsInputs.TextVarOptsInputs300.000 s0.000 s
...dateLogicalScalar(rhs,'ReadRowNames')20.000 s0.000 s
...eArgumentDescriptor>isCharOrString60.000 s0.000 s
mustBeNumericOrLogical30.000 s0.000 s
...validateLogicalScalar(rhs,'UseExcel')20.000 s0.000 s
...lSeparatorInput.DecimalSeparatorInput150.000 s0.000 s
...LogicalScalar(rhs,'FixVariableNames')20.000 s0.000 s
missing>missing.missing20.000 s0.000 s
...>tabularDimension.tabularDimension20.000 s0.000 s
metaDim>metaDim.orientAs20.000 s0.000 s
...tsInputs>TextVarOptsInputs.getType150.000 s0.000 s
...NamesInput.PreserveVariableNamesInput20.000 s0.000 s
Saveable>Saveable.Saveable20.000 s0.000 s
...NameOrNumber.AcceptsSheetNameOrNumber20.000 s0.000 s
...orRulesInputs.MissingErrorRulesInputs20.000 s0.000 s
ReadTable>ReadTable.usingRequired60.000 s0.000 s
supportedTypeNames20.000 s0.000 s

Self time is the time spent in a function excluding the time spent in its child functions. Self time also includes overhead resulting from the process of profiling.