matlab 日期排序_将表转换为时间表 - MATLAB table2timetable - MathWorks 中国

将包含日期和时间的表转换为时间表。

将电力中断数据从文件 outages.csv 读取到表中。该表包含中断时间和恢复时间。

T = readtable('outages.csv');

T(1:5,:)

ans=5×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' }

{'West' } 2004-04-06 05:44 434.81 3.4037e+05 2004-04-06 06:10 {'equipment fault'}

{'MidWest' } 2002-03-16 06:18 186.44 2.1275e+05 2002-03-18 23:23 {'severe storm' }

将该表转换为时间表。第一个含有时间的变量 OutageTime 成为 TT 的时间向量。

TT = table2timetable(T);

TT(1:5,:)

ans=5×5 timetable

OutageTime Region Loss Customers RestorationTime Cause

________________ _____________ ______ __________ ________________ ___________________

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

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

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

2004-04-06 05:44 {'West' } 434.81 3.4037e+05 2004-04-06 06:10 {'equipment fault'}

2002-03-16 06:18 {'MidWest' } 186.44 2.1275e+05 2002-03-18 23:23 {'severe storm' }

使用 TT 的时间向量的行时间对其进行索引。您可以将行时间视为用于指定行的标签。

TT('2003-02-07 21:15',:)

ans=1×5 timetable

OutageTime Region Loss Customers RestorationTime Cause

________________ _____________ _____ __________ ________________ ________________

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

计算电力中断的持续时间。使用圆点语法将行时间提取为向量。

TT.OutageDuration = TT.RestorationTime - TT.OutageTime;

TT(1:5,:)

ans=5×6 timetable

OutageTime Region Loss Customers RestorationTime Cause OutageDuration

________________ _____________ ______ __________ ________________ ___________________ ______________

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

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

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

2004-04-06 05:44 {'West' } 434.81 3.4037e+05 2004-04-06 06:10 {'equipment fault'} 00:26:00

2002-03-16 06:18 {'MidWest' } 186.44 2.1275e+05 2002-03-18 23:23 {'severe storm' } 65:05:00