各位大神好：
本人是一枚python初学者，最近在练习编码的时候用的是pycharm，同样写了一段简单的代码，就是把两个表格进行拼接合并，pandas库也进行了安装，写好之后，在pycharm上运行，一堆报错的，但是在其他程序上代码是可以正常运行的，感觉像是哪的环境没有搭配好。
自己也尝试了百度搜索答案，在pycharm里面配置了本地的python程序，可是还是不行。期望各位大神和老师有空了能给些指点！非常感谢了。
图片说明

    代码如下：
    #data1和data2两个表格进行拼接合并

import pandas as pd
data1 = pd.read_excel(
r"C:\Users\cui\Desktop\测试\2\客户资金对帐2019601-20190619_001.xlsx",
sheet_name=0,
header=0,
dtype='str')
data2 = pd.read_excel(
r"C:\Users\cui\Desktop\测试\2\客户资金对帐2019601-20190619_002.xlsx",
sheet_name=0,
header=0,
dtype='str')
data3 = pd.concat([data1, data2])
data3.to_excel(excel_writer=r"C:\Users\cui\Desktop\测试\汇总输出\huizong.xlsx")

![图片说明](https://img-ask.csdn.net/upload/201906/25/1561425996_709591.png)


报错的代码如下：报错的内容比写的代码都长
Python 3.7.0 (v3.7.0:1bf9cc5093, Jun 27 2018, 04:06:47) [MSC v.1914 32 bit (Intel)] on win32
runfile('C:/Users/cui/PycharmProjects/untitled/ceshi1.py', wdir='C:/Users/cui/PycharmProjects/untitled')
Traceback (most recent call last):
  File "<input>", line 1, in <module>
  File "C:\Program Files\JetBrains\PyCharm 2019.1.3\helpers\pydev\_pydev_bundle\pydev_umd.py", line 197, in runfile
    pydev_imports.execfile(filename, global_vars, local_vars)  # execute the script
  File "C:\Program Files\JetBrains\PyCharm 2019.1.3\helpers\pydev\_pydev_imps\_pydev_execfile.py", line 18, in execfile
    exec(compile(contents+"\n", file, 'exec'), glob, loc)
  File "C:/Users/cui/PycharmProjects/untitled/ceshi1.py", line 2, in <module>
    import pandas as pd
  File "C:\Program Files\JetBrains\PyCharm 2019.1.3\helpers\pydev\_pydev_bundle\pydev_import_hook.py", line 21, in do_import
    module = self._system_import(name, *args, **kwargs)
  File "C:\Users\cui\.virtualenvs\untitled\lib\site-packages\pandas\__init__.py", line 42, in <module>
    from pandas.core.api import *
  File "C:\Program Files\JetBrains\PyCharm 2019.1.3\helpers\pydev\_pydev_bundle\pydev_import_hook.py", line 21, in do_import
    module = self._system_import(name, *args, **kwargs)
  File "C:\Users\cui\.virtualenvs\untitled\lib\site-packages\pandas\core\api.py", line 7, in <module>
    from pandas.core.arrays.integer import (
  File "C:\Program Files\JetBrains\PyCharm 2019.1.3\helpers\pydev\_pydev_bundle\pydev_import_hook.py", line 21, in do_import
    module = self._system_import(name, *args, **kwargs)
  File "C:\Users\cui\.virtualenvs\untitled\lib\site-packages\pandas\core\arrays\__init__.py", line 2, in <module>
    from .base import (ExtensionArray,    # noqa
  File "C:\Program Files\JetBrains\PyCharm 2019.1.3\helpers\pydev\_pydev_bundle\pydev_import_hook.py", line 21, in do_import
    module = self._system_import(name, *args, **kwargs)
  File "C:\Users\cui\.virtualenvs\untitled\lib\site-packages\pandas\core\arrays\base.py", line 21, in <module>
    from pandas.core import ops
  File "C:\Program Files\JetBrains\PyCharm 2019.1.3\helpers\pydev\_pydev_bundle\pydev_import_hook.py", line 21, in do_import
    module = self._system_import(name, *args, **kwargs)
  File "C:\Users\cui\.virtualenvs\untitled\lib\site-packages\pandas\core\ops.py", line 16, in <module>
    from pandas._libs import algos as libalgos, lib, ops as libops
ImportError: cannot import name 'ops' from 'pandas._libs' (C:\Users\cui\.virtualenvs\untitled\lib\site-packages\pandas\_libs\__init__.py)

图片说明

图片说明

python模块的安装问题求大神指点

fangju2013

1个回复