cleaning raw text files with vertical bars and converting them into csv
up vote
0
down vote
favorite
I have a huge raw dataset( 4k lines each text file) with a lot of vertical bars and spaces. |group call| pvt call |phone call|group busy| pvt busy |phone busy| time |total |total |total |total |total |total | % period| sec cnt | sec cnt| sec cnt| sec cnt| sec cnt| sec cnt | usage 00:00 | 4323 548| 0 0| 0 0| 0 0| 0 0| 0 0| 18% 00:15 | 4125 479| 0 0| 0 0| 0 0| 0 0| 0 0| 17% 00:30 | 3071 395| 0 0| 0 0| 0 0| 0 0| 0 0| 13% 00:45 | 3514 447| 0 0| 0 0| 0 0| 0 0| 0 0| 14% 01:00 | 3081 383| 0 0| 0 0| 0 0| 0 0| 0 0| 13% I want to convert it into a csv file. The parser that I built using python and...