removevars
Delete variables from table or timetable
Syntax
Description
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:14
Input 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
, and
Elevation
.
Example: vars = vartype('numeric'); T =
removevars(T,vars)
removes all of the numeric variables in
T
.
Extended Capabilities
The
removevars
function fully supports tall arrays. For more information,
see Tall Arrays.
Usage notes and limitations:
The
vars
input argument does not support pattern expressions.
This function fully supports thread-based environments. For more information, see Run MATLAB Functions in Thread-Based Environment.
This function fully supports distributed arrays. For more information, see Run MATLAB Functions with Distributed Arrays (Parallel Computing Toolbox).
Version History
Introduced in R2018a
MATLAB Command
You clicked a link that corresponds to this MATLAB command:
Run the command by entering it in the MATLAB Command Window. Web browsers do not support MATLAB commands.
Website auswählen
Wählen Sie eine Website aus, um übersetzte Inhalte (sofern verfügbar) sowie lokale Veranstaltungen und Angebote anzuzeigen. Auf der Grundlage Ihres Standorts empfehlen wir Ihnen die folgende Auswahl: United States.
Sie können auch eine Website aus der folgenden Liste auswählen:
So erhalten Sie die bestmögliche Leistung auf der Website
Wählen Sie für die bestmögliche Website-Leistung die Website für China (auf Chinesisch oder Englisch). Andere landesspezifische Websites von MathWorks sind für Besuche von Ihrem Standort aus nicht optimiert.
Amerika
- América Latina (Español)
- Canada (English)
- United States (English)
Europa
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom (English)