文件解析后逆分组扩展
【问题】
I have a tab-delimited file with three columns (Name Nr1 Nr2) like the following:
ABC 201 215
DEF 301 320
GHI 350 375
I would like to transfer the last file into the following format:
ABC 201 201 #taking the value from the first value from the second column and continue line by line till the second value in the third line as the following
ABC 202 202
ABC 203 203
......and so on till the third column value
ABC 215 215
DEF 301 301 ....and so on till the third column value
DEF 320 320
GHI 350 350
GHI 351 351
GHI 351 351
....
GHI 375 375
is that possible in python?
I would really appreciate your help in this Thanks in advance
【回答】
循环源文件每条记录，从第2个到第3个字段循环当前记录，再合并各组记录。上述算法涉及多层循环，用SPL更简单，只要两行：
A |
|
1 |
=file("d:/file.txt").import() |
2 |
=A1.news(to(#2,#3);A1.#1,~,~) |
A1：读取file.txt文件内容。
A2：针对A1每条记录从第2个到第3个字段循环当前记录，再合并各组记录。
