[BangPypers] Need help Extracting data properly in python

[kamalakar06 .]

I have a file like this(Tabular data) :

0     1   CEN/4     1.0000e3    3.000e3     4.000e-3
                              1.000e-3     3.000e3     5.000e3

                  11        2.000e3      3.000e4     6.000e3
                               1.000e4      1.000e4     1.000e5

                   12       1.00e4         1.000e5      1.000e6
                                2.00e4        2.000e5      1.000e4

0     2      CEN/4    1.0000e3    3.000e3      4.000e-3
                                1.000e-3     3.000e3      5.000e3

                     41       2.000e3      3.000e4     6.000e3
                                 1.000e4      1.000e4    1.000e5

                      50      1.00e4         1.000e5      1.000e6
                                 2.00e4         2.000e5      1.000e4



I want to extract the data column wise. How do i do that

My code is like this :

import os

f1=open('newdata1.txt','w')
L = []
for index, line in enumerate(open('Trial_1.txt','r')):
    #print index
    if index < 0: #skip first 5 lines
        continue
    else:
        line =line.split()
        L.append('%s\t%s\t %s\t %s\t%s\n' %(line[0],
line[1],line[2],line[3],line[4]))


f1.writelines(L)

f1.close()



Output looks like this:

0     1   CEN/4     1.0000e3    3.000e3
1.000e-3     3.000e3     5.000e3


Now the code is not extracting the column data properly,since there is tab
space after first line . How to give tab space in python wherever space is
there to extract the data properly.Where to modify my code.