matlab时间表,在表或时间表中移动变量

创建一个表并逐个移动变量。您可以通过名称或表中的位置指定变量。

将数据从电子表格读取到表中。显示前三行。

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'}

移动名为 Region 的变量，使其位于名为 Cause 的变量之前。

T2 = movevars(T1,'Region','Before','Cause');

head(T2,3)

ans=3×6 table

OutageTime Loss Customers RestorationTime Region Cause

________________ ______ __________ ________________ _____________ ________________

2002-02-01 12:18 458.98 1.8202e+06 2002-02-07 16:50 {'SouthWest'} {'winter storm'}

2003-01-23 00:49 530.14 2.1204e+05 NaT {'SouthEast'} {'winter storm'}

2003-02-07 21:15 289.4 1.4294e+05 2003-02-17 08:14 {'SouthEast'} {'winter storm'}

移动第四个变量，使其位于第一个变量之后。

T3 = movevars(T2,4,'After',1);

head(T3,3)

ans=3×6 table

OutageTime RestorationTime Loss Customers Region Cause

________________ ________________ ______ __________ _____________ ________________

2002-02-01 12:18 2002-02-07 16:50 458.98 1.8202e+06 {'SouthWest'} {'winter storm'}

2003-01-23 00:49 NaT 530.14 2.1204e+05 {'SouthEast'} {'winter storm'}

2003-02-07 21:15 2003-02-17 08:14 289.4 1.4294e+05 {'SouthEast'} {'winter storm'}