La traducción de esta página está obsoleta. Haga clic aquí para ver la última versión en inglés.

Tablas

Arreglos en formato tabular cuyas columnas designadas pueden tener diferentes tipos de datos.

Una table (tabla) es un tipo de dato adecuado para datos orientados a columnas o datos tabulares que suelen almacenarse como columnas en un archivo de texto o en una hoja de cálculo. Las tablas constan de filas y variables orientadas a columnas. Cada variable en una tabla puede tener un tipo de datos y un tamaño diferente, con la única restricción de que cada variable debe tener la misma cantidad de filas. Para obtener más información, consulte Create Tables and Assign Data to Them o vea Tablas y arreglos categóricos.

Funciones

expandir todo

Crear tablas y convertir tipo

`table`	Table array with named variables that can contain different types
`array2table`	Convert homogeneous array to table
`cell2table`	Convert cell array to table
`struct2table`	Convert structure array to table
`table2array`	Convert table to homogeneous array
`table2cell`	Convert table to cell array
`table2struct`	Convert table to structure array
`table2timetable`	Convert table to timetable
`timetable2table`	Convert timetable to table
`vartype`	Subscript into table or timetable by variable type
`convertvars`	Convert table or timetable variables to specified data type

Leer y escribir archivos

Importación y exportación básicas

`readtable`	Create table from file
`writetable`	Write table to file

Definir reglas de importación

`detectImportOptions`	Create import options based on file content
`spreadsheetImportOptions`	Import options object for Spreadsheets
`getvaropts`	Get variable import options
`setvaropts`	Set variable import options
`setvartype`	Set variable data types
`preview`	Preview eight rows from file using import options

Información de resumen y gráfica apilada

`head`	Get top rows of table, timetable, or tall array
`tail`	Get bottom rows of table, timetable, or tall array
`summary`	Print summary of table, timetable, or categorical array
`height`	Number of table rows
`width`	Number of table variables
`istable`	Determine if input is table
`stackedplot`	Stacked plot of several variables with common x-axis

Ordenar, reorganizar y personalizar

Ordenar

`sortrows`	Sort rows of matrix or table
`unique`	Unique values in array
`issortedrows`	Determine if matrix or table rows are sorted
`topkrows`	Top rows in sorted order

Reorganizar variables

`addvars`	Add variables to table or timetable
`renamevars`	Rename variables in table or timetable
`movevars`	Move variables in table or timetable
`removevars`	Delete variables from table or timetable
`splitvars`	Split multicolumn variables in table or timetable
`mergevars`	Combine table or timetable variables into multicolumn variable
`vartype`	Subscript into table or timetable by variable type
`convertvars`	Convert table or timetable variables to specified data type

Remodelar

`rows2vars`	Reorient table or timetable so that rows become variables
`stack`	Stack data from input table or timetable into one variable in output table or timetable
`unstack`	Unstack data from single variable into multiple variables
`inner2outer`	Invert nested table-in-table hierarchy in tables or timetables

Personalizar propiedades

`addprop`	Add custom properties to table or timetable
`rmprop`	Remove custom properties from table or timetable

Operaciones de combinación y conjuntos

Combinar usando variables clave

`join`	Combine two tables or timetables by rows using key variables
`innerjoin`	Inner join between two tables or timetables
`outerjoin`	Outer join between two tables or timetables

Operaciones con conjuntos

`union`	Set union of two arrays
`intersect`	Set intersection of two arrays
`ismember`	Array elements that are members of set array
`setdiff`	Set difference of two arrays
`setxor`	Set exclusive OR of two arrays

Valores faltantes

`ismissing`	Find missing values
`standardizeMissing`	Insert standard missing values
`rmmissing`	Remove missing entries
`fillmissing`	Fill missing values

Aplicar funciones al contenido de la tabla

`varfun`	Apply function to table or timetable variables
`rowfun`	Apply function to table or timetable rows
`findgroups`	Find groups and return group numbers
`splitapply`	Split data into groups and apply function
`groupsummary`	Group summary computations
`vartype`	Subscript into table or timetable by variable type
`convertvars`	Convert table or timetable variables to specified data type

Tareas de Live Editor

Join Tables	Combine two tables using key variables in the Live Editor
Stack Table Variables	Combine values from multiple table variables into one table variable in the Live Editor
Unstack Table Variables	Distribute values from one table variable to multiple table variables in the Live Editor

Temas

Advantages of Using Tables

Use tables to store mixed-type data conveniently, access data with numeric or named indexing, and to store metadata.

Create Tables and Assign Data to Them

There are several ways to create tables and assign data to them. You can create tables from input arrays, preallocate tables and fill them in later, or import tables from text files or spreadsheets.

Access Data in Tables

Indexing into tables with parentheses, dot notation, and curly braces accesses table data in different ways. You can use indexing to create a table that is a subset of a larger table or to create an array from data in a table.

Calculations on Tables

This example shows how to perform calculation on tables.

Changes to DimensionNames Property in R2016b

Tables can raise compatibility warnings, and change dimension names, when you modify the DimensionNames property.