removevars - Delete variables from table or timetable - MATLAB (original) (raw)
Delete variables from table or timetable
Syntax
Description
T2 = removevars([T1](#d126e1562065),[vars](#d126e1562084)) deletes the table variables specified by vars and copies the remaining variables to T2. You can specify variables by name, by position, or using logical indices.
For example, to remove table variable var3, use T2 = removevars(T1,'var3').
Examples
Create a table and remove variables one at a time. You can specify variables by name or by position in the table.
Read data from a spreadsheet into a table. Display the first three rows.
T1 = readtable('outages.csv'); head(T1,3)
Region OutageTime Loss Customers RestorationTime Cause
_____________ ________________ ______ __________ ________________ ________________
{'SouthWest'} 2002-02-01 12:18 458.98 1.8202e+06 2002-02-07 16:50 {'winter storm'}
{'SouthEast'} 2003-01-23 00:49 530.14 2.1204e+05 NaT {'winter storm'}
{'SouthEast'} 2003-02-07 21:15 289.4 1.4294e+05 2003-02-17 08:14 {'winter storm'}Remove the variable that is named Region.
T2 = removevars(T1,'Region'); head(T2,3)
OutageTime Loss Customers RestorationTime Cause
________________ ______ __________ ________________ ________________
2002-02-01 12:18 458.98 1.8202e+06 2002-02-07 16:50 {'winter storm'}
2003-01-23 00:49 530.14 2.1204e+05 NaT {'winter storm'}
2003-02-07 21:15 289.4 1.4294e+05 2003-02-17 08:14 {'winter storm'}Remove the fourth variable from T2.
T3 = removevars(T2,4); head(T3,3)
OutageTime Loss Customers Cause
________________ ______ __________ ________________
2002-02-01 12:18 458.98 1.8202e+06 {'winter storm'}
2003-01-23 00:49 530.14 2.1204e+05 {'winter storm'}
2003-02-07 21:15 289.4 1.4294e+05 {'winter storm'}Remove multiple table variables using the removevars function. You can specify variables by name or by position.
Read data from a spreadsheet into a table.
T1 = readtable('outages.csv'); head(T1,3)
Region OutageTime Loss Customers RestorationTime Cause
_____________ ________________ ______ __________ ________________ ________________
{'SouthWest'} 2002-02-01 12:18 458.98 1.8202e+06 2002-02-07 16:50 {'winter storm'}
{'SouthEast'} 2003-01-23 00:49 530.14 2.1204e+05 NaT {'winter storm'}
{'SouthEast'} 2003-02-07 21:15 289.4 1.4294e+05 2003-02-17 08:14 {'winter storm'}Remove the variables named Loss and Customers. Specify names using a cell array of character vectors.
T2 = removevars(T1,{'Loss','Customers'}); head(T2,3)
Region OutageTime RestorationTime Cause
_____________ ________________ ________________ ________________
{'SouthWest'} 2002-02-01 12:18 2002-02-07 16:50 {'winter storm'}
{'SouthEast'} 2003-01-23 00:49 NaT {'winter storm'}
{'SouthEast'} 2003-02-07 21:15 2003-02-17 08:14 {'winter storm'}Remove the first and fourth variables, using a numeric array to indicate their positions in T2.
T3 = removevars(T2,[1 4]); head(T3,3)
OutageTime RestorationTime
________________ ________________
2002-02-01 12:18 2002-02-07 16:50
2003-01-23 00:49 NaT
2003-02-07 21:15 2003-02-17 08:14Input Arguments
Input table, specified as a table or timetable.
Variables in the input table, specified as a string array, character vector, cell array of character vectors, pattern scalar, numeric array, logical array, or subscript object.
You can specify vars as a subscript object that detects variables of a specified data type by using the vartype function.
Example: T2 = removevars(T1,2) removes the second table variable.
Example: T2 = removevars(T1,'Date') removes the table variable named Date.
Example: T2 = removevars(T1,{'Latitude','Longitude','Elevation'}) removes the table variables named Latitude,Longitude, andElevation.
Example: vars = vartype('numeric'); T = removevars(T,vars) removes all of the numeric variables inT.
Extended Capabilities
Theremovevars function fully supports tall arrays. For more information, see Tall Arrays.
Usage notes and limitations:
- The
varsinput argument does not support pattern expressions.
Version History
Introduced in R2018a