我不确定这是否是正确的问题,但基本上我有一个.txt文件,其中包含来自 2 个独立传感器的值。 一些数据的示例:
{"t":3838202,"s":0,"n":"x1","v":-1052}
{"t":3838203,"s":0,"n":"y1","v":44}
{"t":3838204,"s":0,"n":"z1","v":-84}
{"t":3838435,"s":0,"n":"x1","v":-1052}
{"t":3838436,"s":0,"n":"y1","v":36}
{"t":3838437,"s":0,"n":"z1","v":-80}
{"t":3838670,"s":0,"n":"x1","v":-1056}
{"t":3838671,"s":0,"n":"y1","v":52}
{"t":3838672,"s":0,"n":"z1","v":-88}
{"t":3838902,"s":0,"n":"x1","v":-1052}
{"t":3838903,"s":0,"n":"y1","v":48}
{"t":3838904,"s":0,"n":"z1","v":-80}
{"t":3839136,"s":0,"n":"x1","v":-1056}
{"t":3839137,"s":0,"n":"y1","v":40}
{"t":3839138,"s":0,"n":"z1","v":-80}
x2:-944
y2:108
z2:-380
{"t":3839841,"s":0,"n":"x1","v":-1052}
{"t":3839842,"s":0,"n":"y1","v":44}
{"t":3839843,"s":0,"n":"z1","v":-80}
x2:-948
y2:100
z2:-380
{"t":3840541,"s":0,"n":"x1","v":-1052}
{"t":3840542,"s":0,"n":"y1","v":40}
{"t":3840543,"s":0,"n":"z1","v":-84}
{"t":3840774,"s":0,"n":"x1","v":-1052}
{"t":3840775,"s":0,"n":"y1","v":40}
{"t":3840776,"s":0,"n":"z1","v":-84}
x2:-948
y2:108
z2:-368
我正在尝试将数据放入 excel,以便对于 x1y1z1 部分中的每个"块"数据,我获取最后一组记录的数据并丢弃其余数据并将其与下一组 x2y2z2 数据"配对"。我不认为我解释得很好,但我基本上想拿那个文本文件并在 excel 中获取它:
+---------+-------+----+-----+------+-----+------+
| t | x1 | y1 | z1 | x2 | y2 | z2 |
+---------+-------+----+-----+------+-----+------+
| 3839138 | -1056 | 40 | -80 | -944 | 100 | -380 |
| 3839843 | -1052 | 44 | -80 | -948 | 100 | -380 |
| 3840776 | -1052 | 40 | -84 | -948 | 108 | -368 |
+---------+-------+----+-----+------+-----+------+
我真的不知道我应该从哪里开始
我像程序员一样思考,所以我会分步解决这个问题。 如果你不是程序员,这可能对你没有那么大帮助,我很抱歉。
- 首先,定义数据。 如何读取和理解每行数据。
- 其次,编写一个解析实用程序。 一段代码,用于在读取数据时解释数据,并将其以所需的输出形式存储
- 第三,将数据导入Excel。
因此,根据您提供的有限数据,我不确定您如何确定每个 t 的 x1,y1,z1,x2,y2,z2,z2,但我假设大括号中的值与基于我在那里看到的 s、n 和 v 的值有关。 因此,首先您需要清楚地确定读取数据的方式。 一次一行,并确定如何根据每行数据构建输出表。 例如,我假设您会将大括号括起来的行与具有独立 x/y/z 值的行区别对待。
我希望这能为你指明正确的方向。