python行列转换

行列转换.
2014-11-01 15719 abc 111
2014-11-02 19541 hhh 222
2014-11-03 20331 ddd 333
2014-11-04 18777 dee 444
........   ...    ...
行数跟列数都是N...
求python代码.


结果要:
2014-11-01  2014-11-02 ...

15719   15719  ...

...

....

解决方案：

#/usr/bin/python
#coding:utf-8
#Filename:rank.py

import math

filename='filename.data'
f=file(filename)
s=f.read()
f.close()
s0=s.replace(' ','\n')
s0=s0.split('\n')
s1=[]
del s0[len(s0)-1]
n=int(math.sqrt(len(s0)))

for j in range(0,n):
    for i in range(0,len(s0)):
        if i%n==j:
            s1.append(s0[i])

'''
for i in range(1,n+1):
    print s1[n*(i-1):i*n]
'''

j=0
for i in s1:
    print i+'\t',
    j+=1
    if j==n:
        print '\n',
        j=0