This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English version of the page.

Note: This page has been translated by MathWorks. Click here to see
To view all translated materials including this page, select Country from the country navigator on the bottom of this page.

removevars

Delete variables from table or timetable

Syntax

T2 = removevars(T1,vars)

Description

example

T2 = removevars(T1,vars) deletes the table variables specified by vars and copies the remaining variables to T2 (see diagram). You can specify variables by name, by position, or using logical indices.

Examples

collapse all

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)
ans=3×6 table
      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)
ans=3×5 table
       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)
ans=3×4 table
       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)
ans=3×6 table
      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)
ans=3×4 table
      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)
ans=3×2 table
       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:14

Input Arguments

collapse all

Input table, specified as a table or timetable.

Variables in the input table, specified as a character vector, cell array of character vectors, string array, numeric array, or logical array.

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, and Elevation.

Extended Capabilities

Introduced in R2018a