1.转接上篇博客:https://blog.csdn.net/weixin_41869644/article/details/89213445
上篇博客使用xlrd这个模块来读取excel表的内容,这里有种简单的方法去转换数据格式。
2.首先问题是在windos10下面创建excel的表格,直接用python读取会报错。错误如下:
Traceback (most recent call last):
File "C:/Users/shengxin/.PyCharmCE2018.3/config/scratches/test.py", line 6, in <module>
data = pd.read_csv(file)
File "F:\ProgramData\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 709, in parser_f
return _read(filepath_or_buffer, kwds)
File "F:\ProgramData\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 449, in _read
parser = TextFileReader(filepath_or_buffer, **kwds)
File "F:\ProgramData\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 818, in __init__
self._make_engine(self.engine)
File "F:\ProgramData\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 1049, in _make_engine
self._engine = CParserWrapper(self.f, **self.options)
File "F:\ProgramData\Anaconda3\lib\site-packages\pandas\io\parsers.py", line 1695, in __init__
self._reader = parsers.TextReader(src, **kwds)
File "pandas/_libs/parsers.pyx", line 562, in pandas._libs.parsers.TextReader.__cinit__
File "pandas/_libs/parsers.pyx", line 790, in pandas._libs.parsers.TextReader._get_header
UnicodeDecodeError: 'utf-8' codec can't decode bytes in position 0-1: invalid continuation byte
2.我们使用editplus去转换数据格式:
excel数据如下:
使用editplus转换以下格式保存:
3.使用python的pandas读取:
import pandas as pd
file = 'C:\\Users\Desktop\kemu.txt'
data = pd.read_csv(file, sep="\t")
print(data)
4.结果如下图: