Question

我拥有大量被制成的限定数据,这些数据分两行。我们现在看着这一点:

    Some Key    Other key   Foo Key    Bar Key
     0           5           18         12

    More Key    Dor key     Gee Key    Francis Scott  Key
     19          14          8          0

    Wa Key      Whis key    Don Key    Luh Key
     0           2           8          16

我需要这样看:

    Some Key    Other key   Foo Key    Bar Key    More Key    Dor key     Gee Key    Francis Scott  Key    Wa Key      Whis key    Don Key    Luh Key
     0           5           18         12         19          14          8          0                    0           2           8          16

我拿着几百个卷宗,每排约20个,每排30个栏,因此我要尽可能地描述我的道路。 I m using Python CSV,但我可以说明如何向它解释自己。

Answer 1

应:

import csv
import sys

keys = []
values = []

reader = csv.reader(sys.stdin, delimiter="	")
for row in reader:
    keys.extend(row)
    values.extend(next(reader))

    # skip empty line
    assert next(reader, []) == []

writer = csv.writer(sys.stdout, delimiter="	")
writer.writerow(keys)
writer.writerow(values)

除此件外,用python meie.py < 样本.csv(“mple.csv”是您的数据档案)

Answer 2

You could ssplit the contents of your file with the tab as a separator, taking every int"eger element and putting it in one array, and taking every string element and putting it in another one. Then, you put out all the strings (keys) on one line separated by tabs, and one line containing all the integers separated by tabs.

友情链接