时序分析- PI数据
时序分析- PI数据
提问于 2015-02-11 05:43:16
我有一个非常大的时间序列数据集，格式如下。
"Tag.1","1/22/2015 11:59:54 PM","570.29895",
"Tag.1","1/22/2015 11:59:56 PM","570.29895",
"Tag.1","1/22/2015 11:59:58 PM","570.29895",
"Tag.1","1/23/2015 12:00:00 AM","649.67133",
"Tag.2","1/22/2015 12:00:02 AM","1.21",
"Tag.2","1/22/2015 12:00:04 AM","1.21",
"Tag.2","1/22/2015 12:00:06 AM","1.21",
"Tag.2","1/22/2015 12:00:08 AM","1.21",
"Tag.2","1/22/2015 12:00:10 AM","1.21",
"Tag.2","1/22/2015 12:00:12 AM","1.21",我想将其分成一个数据帧，其中一个公共列用于时间戳，另一列用于标记。
Date.Time, Tag.1, Tag.2, Tag.3...
1/22/2015 11:59:54 PM,570.29895, 如有任何建议，我们将不胜感激！
回答 1
Stack Overflow用户
发布于 2015-02-11 06:20:24
也许是这样的：cast(df,V2~V1,mean,value='V3') V2 Tag.1 Tag.2 1 1/22/2015 11:59:54 PM 570.2989 NaN 2 1/22/2015 11:59:56 PM 570.2989 NaN 3 1/22/2015 11:59:58 PM 570.2989 NaN 4 1/22/2015 12:00:02 AM NaN 1.21 5 1/22/2015 12:00:04 AM NaN 1.21 6 1/22/2015 12:00:06 AM NaN 1.21 7 1/22/2015 12:00:08 AM NaN 1.21 8 1/22/2015 12:00:10 AM NaN 1.21 9 1/22/2015 12:00:12 AM NaN 1.21 10 1/23/2015 12:00:00 AM 649.6713 NaN
cast是reshape Bests的一部分
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/28442386
复制相关文章
相似问题
腾讯云开发者
