Main Content

removevars

Delete variables from table or timetable

所有的页面崩溃

Syntax

T2 = removevars(T1,vars)

Description

example

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

Examples

collapse all

Open Live Script

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 tableRegion 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 namedRegion.

T2 = removevars(T1,'Region'); head(T2,3)
ans=3×5 tableOutageTime 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 fromT2.

T3 = removevars(T2,4); head(T3,3)
ans=3×4 tableOutageTime 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'}
Open Live Script

Remove multiple table variables using theremovevarsfunction. 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 tableRegion 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损失andCustomers. Specify names using a cell array of character vectors.

T2 = removevars(T1,{'Loss','Customers'}); head(T2,3)
ans=3×4 tableRegion 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 inT2.

T3 = removevars(T2,[1 4]); head(T3,3)
ans=3×2 tableOutageTime 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 string array, character vector, cell array of character vectors,patternscalar, numeric array, or logical array.

例子:T2 = removevars(T1,2)removes the second table variable.

例子:T2 = removevars(T1,'Date')removes the table variable namedDate.

例子:T2 = removevars(T1,{'Latitude','Longitude','Elevation'})removes the table variables namedLatitude,Longitude, andElevation.

Extended Capabilities

Version History

Introduced in R2018a

See Also

||||

Topics