[R-br] Editar dados em arquivo *txt em um data frame

[ASANTOS]

Prezados membros do r-br,


Eu gostaria de criar um data frame à partir de output de uma análise em 
*txt, sendo:


#Arquivo original
https://www.dropbox.com/s/pncmjwl3camap6d/log.txt?dl=0

#Faço a leitura do arquivo
myfile<-read.table("log.txt", sep="\t", quote="", comment.char="")


#Estrutura parcial do arquivo myfile
#
obj
Learning Rate: 0.001, Momentum: 0.9, Decay: 0.0005
Resizing
416
Loaded: 0.062388 seconds
Region 82 Avg IOU: 0.254732, Class: 0.000000, Obj: 0.575008, No Obj: 
0.417811, .5R: 0.000000, .75R: 0.000000,  count: 4
Region 94 Avg IOU: -nan, Class: -nan, Obj: -nan, No Obj: 0.496387, .5R: 
-nan, .75R: -nan,  count: 0
Region 106 Avg IOU: -nan, Class: -nan, Obj: -nan, No Obj: 0.415856, .5R: 
-nan, .75R: -nan,  count: 0
Region 82 Avg IOU: 0.263274, Class: 0.000000, Obj: 0.306391, No Obj: 
0.418069, .5R: 0.000000, .75R: 0.000000,  count: 4
Region 94 Avg IOU: 0.435966, Class: 0.000000, Obj: 0.207774, No Obj: 
0.496172, .5R: 0.000000, .75R: 0.000000,  count: 1
Region 106 Avg IOU: -nan, Class: -nan, Obj: -nan, No Obj: 0.413582, .5R: 
-nan, .75R: -nan,  count: 0
Region 82 Avg IOU: 0.303235, Class: 0.000000, Obj: 0.424457, No Obj: 
0.418686, .5R: 0.000000, .75R: 0.000000,  count: 4
Region 94 Avg IOU: -nan, Class: -nan, Obj: -nan, No Obj: 0.496352, .5R: 
-nan, .75R: -nan,  count: 0
Region 106 Avg IOU: 0.579218, Class: 0.000000, Obj: 0.502197, No Obj: 
0.415232, .5R: 1.000000, .75R: 0.000000,  count: 1
Region 82 Avg IOU: 0.187162, Class: 0.000000, Obj: 0.501398, No Obj: 
0.416089, .5R: 0.000000, .75R: 0.000000,  count: 5
Region 94 Avg IOU: -nan, Class: -nan, Obj: -nan, No Obj: 0.496362, .5R: 
-nan, .75R: -nan,  count: 0
Region 106 Avg IOU: -nan, Class: -nan, Obj: -nan, No Obj: 0.414499, .5R: 
-nan, .75R: -nan,  count: 0
Region 82 Avg IOU: 0.271427, Class: 0.000000, Obj: 0.481964, No Obj: 
0.417647, .5R: 0.166667, .75R: 0.000000,  count: 6
Region 94 Avg IOU: -nan, Class: -nan, Obj: -nan, No Obj: 0.495838, .5R: 
-nan, .75R: -nan,  count: 0
Region 106 Avg IOU: -nan, Class: -nan, Obj: -nan, No Obj: 0.415899, .5R: 
-nan, .75R: -nan,  count: 0
Region 82 Avg IOU: 0.285605, Class: 0.000000, Obj: 0.469981, No Obj: 
0.417026, .5R: 0.000000, .75R: 0.000000,  count: 3
Region 94 Avg IOU: -nan, Class: -nan, Obj: -nan, No Obj: 0.494833, .5R: 
-nan, .75R: -nan,  count: 0
Region 106 Avg IOU: -nan, Class: -nan, Obj: -nan, No Obj: 0.413943, .5R: 
-nan, .75R: -nan,  count: 0
Region 82 Avg IOU: 0.300229, Class: 0.000000, Obj: 0.313481, No Obj: 
0.416831, .5R: 0.000000, .75R: 0.000000,  count: 6
Region 94 Avg IOU: -nan, Class: -nan, Obj: -nan, No Obj: 0.495936, .5R: 
-nan, .75R: -nan,  count: 0
Region 106 Avg IOU: -nan, Class: -nan, Obj: -nan, No Obj: 0.413855, .5R: 
-nan, .75R: -nan,  count: 0
Region 82 Avg IOU: 0.384617, Class: 0.000000, Obj: 0.398042, No Obj: 
0.418052, .5R: 0.333333, .75R: 0.000000,  count: 3
Region 94 Avg IOU: -nan, Class: -nan, Obj: -nan, No Obj: 0.496205, .5R: 
-nan, .75R: -nan,  count: 0
Region 106 Avg IOU: 0.144387, Class: 0.000000, Obj: 0.349722, No Obj: 
0.414624, .5R: 0.000000, .75R: 0.000000,  count: 1
1: 799.219543, 799.219543 avg, 0.000000 rate, 654.661284 seconds, 24 images
Loaded: 0.000042 seconds
Region 82 Avg IOU: 0.308919, Class: 0.000000, Obj: 0.264983, No Obj: 
0.418332, .5R: 0.250000, .75R: 0.000000,  count: 4
Region 94 Avg IOU: 0.204282, Class: 0.000000, Obj: 0.167168, No Obj: 
0.495162, .5R: 0.000000, .75R: 0.000000,  count: 2
Region 106 Avg IOU: -nan, Class: -nan, Obj: -nan, No Obj: 0.415848, .5R: 
-nan, .75R: -nan,  count: 0
Region 82 Avg IOU: 0.274081, Class: 0.000000, Obj: 0.471111, No Obj: 
0.418323, .5R: 0.000000, .75R: 0.000000,  count: 3
Region 94 Avg IOU: -nan, Class: -nan, Obj: -nan, No Obj: 0.495826, .5R: 
-nan, .75R: -nan,  count: 0
...
55: 1025.803833, 1181.399658 avg, 0.000000 rate, 919.132681 seconds, 
1320 images
Loaded: 0.000050 seconds
#

Agora, eu quero criar um data frame onde eu não preciso de toda essa 
informação e eu sei que cada linha que eu preciso está acima de linha 
que começam com a expressão "Loaded:", sendo as minhas linhas de 
interesse caracterizadas pela estrutura "1: 799.219543, 799.219543 avg, 
0.000000 rate, 654.661284 seconds, 24 images".

Eu preciso que seja criada alguma regra (informação desnecessária começa 
com a expressão "Region" e ocorre a cada 24 linhas) para que eu consiga 
inicialmente isolar a informação pertinente, ficando meu output 
processado com 55 linhas:

#
1: 799.219543, 799.219543 avg, 0.000000 rate, 654.661284 seconds, 24 images
2: 799.555359, 799.253113 avg, 0.000000 rate, 672.519735 seconds, 48 images
...
55: 1025.803833, 1181.399658 avg, 0.000000 rate, 919.132681 seconds, 
1320 images
#

e após com alguma manipulação a mais de modo a reorganizar a informação 
isolada, conseguir gerar o meu data frame final, que seria:

#
iteration  total_loss      loss_error     rate time               n_images
1               799.219543  799.219543  0.000000  654.661284 24
2               799.555359  799.253113  0.000000  672.519735 48
...
55            1025.803833 1181.399658 0.000000  919.132681  1320
#

Alguém que trabalha com manipulação de tabelas em R teria alguma dica 
para dar?

Obrigado,

Alexandre


-------------- Próxima Parte ----------
Um anexo em HTML foi limpo...
URL: <http://listas.inf.ufpr.br/pipermail/r-br/attachments/20200325/7163ce19/attachment.html>