matlab 中的指针重命名,重命名表或时间表中的变量

该内容展示了如何使用MATLAB从CSV文件中读取电子表格数据,并将特定列转换为字符串数组。通过T=readtable命令读取'outages.csv'文件,然后使用renamevars函数将'Loss'、'OutageTime'和'RestorationTime'列重命名为'TotalCost'、'StartofOutage'和'Restoration',从而完成变量名的更新。
摘要由CSDN通过智能技术生成

从电子表格中读取表。电子表格为每个表变量提供一个名称。(将包含文本的列读入字符串数组形式的表变量中。)

T = readtable('outages.csv','TextType','string')

T=1468×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"

"West" 2003-06-18 02:49 0 0 2003-06-18 10:54 "attack"

"West" 2004-06-20 14:39 231.29 NaN 2004-06-20 19:16 "equipment fault"

"West" 2002-06-06 19:28 311.86 NaN 2002-06-07 00:51 "equipment fault"

"NorthEast" 2003-07-16 16:23 239.93 49434 2003-07-17 01:12 "fire"

"MidWest" 2004-09-27 11:09 286.72 66104 2004-09-27 16:37 "equipment fault"

"SouthEast" 2004-09-05 17:48 73.387 36073 2004-09-05 20:46 "equipment fault"

"West" 2004-05-21 21:45 159.99 NaN 2004-05-22 04:23 "equipment fault"

"SouthEast" 2002-09-01 18:22 95.917 36759 2002-09-01 19:12 "severe storm"

"SouthEast" 2003-09-27 07:32 NaN 3.5517e+05 2003-10-04 07:02 "severe storm"

"West" 2003-11-12 06:12 254.09 9.2429e+05 2003-11-17 02:04 "winter storm"

"NorthEast" 2004-09-18 05:54 0 0 NaT "equipment fault"

更改变量 Loss、OutageTime 和 RestorationTime 的名称。

T = renamevars(T,["Loss","OutageTime","RestorationTime"], ...

["Total Cost","Start of Outage","Restoration"])

T=1468×6 table

Region Start of Outage Total Cost Customers Restoration 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"

"West" 2003-06-18 02:49 0 0 2003-06-18 10:54 "attack"

"West" 2004-06-20 14:39 231.29 NaN 2004-06-20 19:16 "equipment fault"

"West" 2002-06-06 19:28 311.86 NaN 2002-06-07 00:51 "equipment fault"

"NorthEast" 2003-07-16 16:23 239.93 49434 2003-07-17 01:12 "fire"

"MidWest" 2004-09-27 11:09 286.72 66104 2004-09-27 16:37 "equipment fault"

"SouthEast" 2004-09-05 17:48 73.387 36073 2004-09-05 20:46 "equipment fault"

"West" 2004-05-21 21:45 159.99 NaN 2004-05-22 04:23 "equipment fault"

"SouthEast" 2002-09-01 18:22 95.917 36759 2002-09-01 19:12 "severe storm"

"SouthEast" 2003-09-27 07:32 NaN 3.5517e+05 2003-10-04 07:02 "severe storm"

"West" 2003-11-12 06:12 254.09 9.2429e+05 2003-11-17 02:04 "winter storm"

"NorthEast" 2004-09-18 05:54 0 0 NaT "equipment fault"

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值