<p>如何使用熊猫作为字符串从.CSV文件直接读取度分秒(DMS)数据到数据帧中?
例如:
如果我有一个csv文件,其中有一列DMS格式的数据,那么如何将其作为字符串读取到dataframe以进行进一步计算</p>
<pre><code>76° 17' 51.2399" E
77° 26' 30.8322" E
76° 51' 29.7812" E
75° 45' 41.3540" E
76° 17' 51.2399" E
</code></pre>
<p>输入文件示例:<a href="https://wetransfer.com/downloads/adda06f30d78ed308d510669b1c21ff120200525153241/6910f5" rel="nofollow noreferrer">enter link description here</a></p>
<p>当我使用pandas.read_csv('test.csv)#test.csv是输入文件
我犯了一个错误</p>
<pre><code>Traceback (most recent call last):
File "<ipython-input-90-2af7440e7795>", line 1, in <module>
df = pd.read_csv('test.csv')
File "C:\ProgramData\Anaconda3\envs\obspy\lib\site-packages\pandas\io\parsers.py", line 676, in parser_f
return _read(filepath_or_buffer, kwds)
File "C:\ProgramData\Anaconda3\envs\obspy\lib\site-packages\pandas\io\parsers.py", line 448, in _read
parser = TextFileReader(fp_or_buf, **kwds)
File "C:\ProgramData\Anaconda3\envs\obspy\lib\site-packages\pandas\io\parsers.py", line 880, in __init__
self._make_engine(self.engine)
File "C:\ProgramData\Anaconda3\envs\obspy\lib\site-packages\pandas\io\parsers.py", line 1114, in _make_engine
self._engine = CParserWrapper(self.f, **self.options)
File "C:\ProgramData\Anaconda3\envs\obspy\lib\site-packages\pandas\io\parsers.py", line 1891, in __init__
self._reader = parsers.TextReader(src, **kwds)
File "pandas\_libs\parsers.pyx", line 529, in pandas._libs.parsers.TextReader.__cinit__
File "pandas\_libs\parsers.pyx", line 749, in pandas._libs.parsers.TextReader._get_header
UnicodeDecodeError: 'utf-8' codec can't decode byte 0xf8 in position 2: invalid start byte
</code></pre>