<p><strong>使用熊猫</strong></p>
<pre><code>import pandas as pd
from io import StringIO
siteData = """cat|x|y|z
1|343741.396330097|1029255.04807763|0
2|342270.660062496|1030198.57861216|0
3|339743.874252208|1030705.47801259|0
4|343031.709457817|1027263.37839108|0
5|339453.578589758|1029954.65896125|0
6|341376.669330771|1029549.5339487|0
7|339224.904513178|1030438.74647616|0
8|340285.317292692|1029431.45860403|0
9|343135.800101739|1029804.27059289|0
10|338982.428513304|1028857.42081259|0
11|338405.612076696|1034287.30455498|0
12|338080.457138754|1034337.35427931|0
13|338944.90541069|1034519.90737124|0
14|340963.209546547|1032528.77710582|0
15|337891.948788692|1030626.74686363|0"""
# wrap the siteData string data in StringIO function
# use pandas read_csv to create DataFrame
df = pd.read_csv(StringIO(siteData), sep ="|", dtype=float).astype(int)
print(df)
</code></pre>
<p><strong>输出</strong></p>
<pre><code> cat x y z
0 1 343741 1029255 0
1 2 342270 1030198 0
2 3 339743 1030705 0
3 4 343031 1027263 0
4 5 339453 1029954 0
5 6 341376 1029549 0
6 7 339224 1030438 0
7 8 340285 1029431 0
8 9 343135 1029804 0
9 10 338982 1028857 0
10 11 338405 1034287 0
11 12 338080 1034337 0
12 13 338944 1034519 0
13 14 340963 1032528 0
14 15 337891 1030626 0
</code></pre>