Contenuto principale

Tabelle

Array in forma tabellare le cui colonne denominate possono essere di tipo diverso

table è un tipo di dati adatto per i dati orientati alle colonne o tabellari, spesso memorizzati come colonne in un file di testo o in un foglio di calcolo. Le tabelle sono costituite da righe e da variabili orientate alle colonne. Ciascuna variabile di una tabella può avere un tipo di dati diverso e una dimensione diversa, con l'unica restrizione che ogni variabile deve avere lo stesso numero di righe. Per maggiori informazioni, vedere Creazione di tabelle e assegnazione dei relativi dati o guardare Tables and Categorical Arrays (Tabelle e array categorici).

Funzioni

espandi tutto

tableTable array with named variables that can contain different types
array2tableConvert homogeneous array to table
cell2tableConvert cell array to table
struct2tableConvert structure array to table
table2arrayConvertire la tabella in array omogeneo
table2cellConvert table to cell array
table2structConvert table to structure array
table2timetableConvert table to timetable
timetable2tableConvert timetable to table
vartypeSubscript into table or timetable by variable type
convertvarsConvert table or timetable variables to specified data type

Importazione ed esportazione di base

readtableCreate table from file
writetableWrite table to file

Definizione delle regole di importazione

detectImportOptionsCreate import options based on file content
spreadsheetImportOptionsImport options object for Spreadsheets
getvaroptsGet variable import options
setvaroptsSet variable import options
setvartypeSet variable data types
previewPreview eight rows from file using import options

File Parquet

parquetreadRead columnar data from a Parquet file
parquetwriteWrite columnar data to Parquet file
parquetinfoGet information about Parquet file
summaryData summary
heightNumber of table rows
widthNumber of table variables
istableDetermine if input is table
istabularDetermine if input is table or timetable (Da R2021b)
headGet top rows of array or table
tailGet bottom rows of array or table
stackedplotStacked plot of several variables with common x-axis

Ordinamento

sortrowsSort rows of matrix or table
uniqueUnique values
issortedrowsDetermine if matrix or table rows are sorted
topkrowsTop rows in sorted order

Righe del filtro e variabili

rowfilterSelectively import rows of interest (Da R2022a)
vartypeSubscript into table or timetable by variable type

Riorganizzazione delle variabili

addvarsAdd variables to table or timetable
renamevarsRename variables in table or timetable
movevarsMove variables in table or timetable
removevarsDelete variables from table or timetable
splitvarsSplit multicolumn variables in table or timetable
mergevarsCombine table or timetable variables into multicolumn variable
convertvarsConvert table or timetable variables to specified data type

Rimodellamento

rows2varsReorient table or timetable so that rows become variables
stackStack data from input table or timetable into one variable of output table or timetable
unstackUnstack data from input table or timetable into multiple variables of output table or timetable
inner2outerInvert nested table-in-table hierarchy in tables or timetables

Personalizzazione delle proprietà

addpropAdd custom properties to table or timetable
rmpropRemove custom properties from table or timetable

Unione tramite variabili chiave

joinCombine two tables or timetables by rows using key variables
innerjoinInner join between two tables or timetables
outerjoinOuter join between two tables or timetables

Impostazione delle operazioni

unionUnion of two sets of data
intersectIntersection of two sets of data
ismemberFind set members of data
setdiffDifference of two sets of data
setxorExclusive OR of two sets of data
anymissingDetermine if any array element is missing (Da R2022a)
ismissingFind missing values
standardizeMissingInsert standard missing values
rmmissingRemove missing entries
fillmissingFill missing entries
pivotSummarize tabular data in pivoted table (Da R2023a)
groupcountsNumber of group elements
groupfilterFilter by group
groupsummaryGroup summary computations
grouptransformTransform by group
findgroupsFind groups and return group numbers
splitapplySplit data into groups and apply function
rowfunApply function to table or timetable rows
varfunApply function to table or timetable variables
vartypeSubscript into table or timetable by variable type
convertvarsConvert table or timetable variables to specified data type

App

Data CleanerPreprocess and organize column-oriented data (Da R2022a)

Attività di Live Editor

Calcolare per gruppoSummarize, transform, or filter by group in the Live Editor (Da R2021b)
Tabella PivotSummarize tabular data in pivoted table in the Live Editor (Da R2023b)
Unire le tabelleCombine two tables using key variables in the Live Editor
Sovrapporre le variabili della tabellaCombine values from multiple table variables into one table variable in the Live Editor
Divergere le variabili della tabellaDistribute values from one table variable to multiple table variables in the Live Editor

Argomenti

Esempi in primo piano