Windos下创建的excel表格怎么使用python读取

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.结果如下图：