我是Python新手,但遇到了一个数据挑战。我希望我能在这里为这个挑战找到帮助
我需要清理并协调包含多个动态长度数据帧的txt日志文件。数据帧存储在彼此下方。实际上,我需要一种人工索引来过滤一个数据帧的内容,以便清理和格式化数据帧
问题:我需要过滤日志文件以从每个帧中提取单个KPI。因此,我需要对十六进制数和一些数字的科学书写进行预处理和清理。您能帮我创建一个新列,该列的索引只包含表名(请参阅右数据框和列索引)。索引的名称仅在两列和特定行中。目前我不知道如何将它们正确地添加为表标识
请帮帮我
致意
好奇的数据科学家
0 0 0 0 0 0 0
Table COST
REAL REAL REAL REAL
IDnxska52P 154564564 421564564 364564564 456456 35635
Table Instruments 421564564 364564564 456456 53536
STRING REAL REAL REAL REAL REAL REAL
IDnxska52P 3,5 50 3,5 50 3,5 50
IDnxska53P 6,5 7,5 6,5 7,5 6,5 7,5
IDnxska54P 3,5 50 3,5 50 3,5 50
IDnxska55P 6,5 7,5 6,5 7,5 6,5 7,5
IDnxska56P 3,5 50 6,5 7,5 7,5 7,5
Table PC 50 6,5 7,5 7,5 7,5
STRING REAL REAL REAL REAL REAL REAL
HTZ30 0.000000000000000E+00 0.000000000000000E+00 0.000000000000000E+00 0.000000000000000E+00 0.000000000000000E+00 0.000000000000000E+00
HTZ31 0.000000000000000E+01 0.000000000000000E+01 0.000000000000000E+00 0.000000000000000E+01 0.000000000000000E+01 0.000000000000000E+01
HTZ30 0.000000000000000E+02 0.000000000000000E+02 0.000000000000000E+00 0.000000000000000E+02 0.000000000000000E+02 0.000000000000000E+02
HTZ31 0.000000000000000E+03 0.000000000000000E+03 0.000000000000000E+00 0.000000000000000E+03 0.000000000000000E+03 0.000000000000000E+03
HTZ32 0.000000000000000E+04 0.000000000000000E+04 0.000000000000000E+00 0.000000000000000E+04 0.000000000000000E+04 0.000000000000000E+04
HTZ33 0.000000000000000E+05 0.000000000000000E+05 0.000000000000000E+00 0.000000000000000E+05 0.000000000000000E+05 0.000000000000000E+05
HTZ34 0.000000000000000E+06 0.000000000000000E+06 0.000000000000000E+00 0.000000000000000E+06 0.000000000000000E+06 0.000000000000000E+06
HTZ35 0.000000000000000E+07 0.000000000000000E+07 0.000000000000000E+00 0.000000000000000E+07 0.000000000000000E+07 0.000000000000000E+07
HTZ36 0.000000000000000E+08 0.000000000000000E+08 0.000000000000000E+00 0.000000000000000E+08 0.000000000000000E+08 0.000000000000000E+08
HTZ37 0.000000000000000E+09 0.000000000000000E+09 0.000000000000000E+00 0.000000000000000E+09 0.000000000000000E+09 0.000000000000000E+09
HTZ38 0.000000000000000E+10 0.000000000000000E+10 0.000000000000000E+00 0.000000000000000E+10 0.000000000000000E+10 0.000000000000000E+10
HTZ39 0.000000000000000E+11 0.000000000000000E+11 0.000000000000000E+00 0.000000000000000E+11 0.000000000000000E+11 0.000000000000000E+11
HTZ40 0.000000000000000E+12 0.000000000000000E+12 0.000000000000000E+00 0.000000000000000E+12 0.000000000000000E+12 0.000000000000000E+12
HTZ41 0.000000000000000E+13 0.000000000000000E+13 0.000000000000000E+00 0.000000000000000E+13 0.000000000000000E+13 0.000000000000000E+13
HTZ42 0.000000000000000E+14 0.000000000000000E+14 0.000000000000000E+00 0.000000000000000E+14 0.000000000000000E+14 0.000000000000000E+14
HTZ43 0.000000000000000E+15 0.000000000000000E+15 0.000000000000000E+00 0.000000000000000E+15 0.000000000000000E+15 0.000000000000000E+15
HTZ44 0.000000000000000E+16 0.000000000000000E+16 0.000000000000000E+00 0.000000000000000E+16 0.000000000000000E+16 0.000000000000000E+16
目前没有回答
相关问题 更多 >
编程相关推荐