我有麻烦了熊猫.read_csv在
我想阅读此文本文件(见下文)当我将此数据复制到excel中时,它将以“空格”分隔,并将其复制到“文本到列”>;中,它将为我提供所需的精确输出。在
我尝试了很多不同的方法,我认为regEx可以解释多个空格,但我没能成功。在
我尝试以下代码:
petrelTxt = pd.read_csv(petrelfile, sep = ' ', header = None)
它给了我错误
^{pr2}$当我尝试更改“sep='\s+'”时,它会使文件更深入,但仍然不起作用。在
petrelTxt = pd.read_csv(petrelfile, sep = '\s+', header = None)
CParserError: Error tokenizing data. C error: Expected 5 fields in line 3, saw 6
这是原始txt文件:
# WELL TRACE FROM PETREL
# WELL NAME: ZZ-0113
# WELL HEAD X-COORDINATE: 9999999.00000000 (m)
# WELL HEAD Y-COORDINATE: 9999999.00000000 (m)
# WELL KB: 159.00000000 (ft)
# WELL TYPE: OIL
# MD AND TVD ARE REFERENCED (=0) AT KB AND INCREASE DOWNWARDS
# ANGLES ARE GIVEN IN DEGREES
# XYZ TRACE IS GIVEN IN COORDINATE SYSTEM WGS_1924_UTM_Zone_42N
# AZIMUTH REFERENCE TRUE NORTH
# DX DY ARE GIVEN IN GRID NORTH IN m-UNITS
# DEPTH (Z, TVD) GIVEN IN ft-UNITS
#======================================================================================================================================
MD X Y Z TVD DX DY AZIM INCL DLS
#======================================================================================================================================
0.0000000000 999999.00000 9999999.0000 159.00000000 0.0000000000 0.0000005192 -0.000000000 1.3487006929 0.0000000000 0.0000000000
132.00000000 999999.08032 9999999.9116 27.000774702 131.99922530 0.0803153923 -0.088388779 139.08870069 0.3400000000 0.2575757504
221.00000000 999999.19115 9999999.8017 -61.99775149 220.99775149 0.1911487882 -0.198290891 132.93870069 0.3200000000 0.0456726104
尝试
comment="#"
使用
io
模块模拟文件的示例结果:
^{pr2}$相关问题 更多 >
编程相关推荐