用panda打开Excel文件时出现问题

Question

我在尝试用以下代码打开excel文件时遇到了这个问题：

#===================================
#different import 
import numpy as np
from matplotlib import pyplot as plt
import pandas as pd
section_copper = 50.11*8.04#[mm2]
section_alu = 50.18*5.07 #[mm2]
section_composite = 53.24*4.49 #[mm2]
section_steel = 50.35*10.23 #[mm2]
length = 400 #[mm]
data_steel = pd.read_excel(r"C:UsersAlexDownloadsMAPR2481-Lab1.xlsx",sheet_name=0)
data_aluminium = pd.read_excel(r"C:UsersAlexDownloadsMAPR2481-Lab1.xlsx",sheet_name=1)
data_copper = pd.read_excel(r"C:UsersAlexDownloadsMAPR2481-Lab1.xlsx",sheet_name=2)
data_composite = pd.read_excel(r"C:UsersAlexDownloadsMAPR2481-Lab1.xlsx",sheet_name=3)

可以在控制台中找到以下消息：

runfile('C:/Users/Alex/.spyder-py3/lab 1.py', wdir='C:/Users/Alex/.spyder-py3')
Traceback (most recent call last):
File "<ipython-input-16-9c6aa501dded>", line 1, in <module>
runfile('C:/Users/Alex/.spyder-py3/lab 1.py', wdir='C:/Users/Alex/.spyder-py3')
File "C:UsersAlexAnaconda3libsite-packagesspyder_kernelscustomizespydercustomize.py", line 827, in runfile
execfile(filename, namespace)
File "C:UsersAlexAnaconda3libsite-packagesspyder_kernelscustomizespydercustomize.py", line 110, in execfile
exec(compile(f.read(), filename, 'exec'), namespace)
File "C:/Users/Alex/.spyder-py3/lab 1.py", line 3, in <module>
import numpy as np
File "C:UsersAlexAppDataRoamingPythonPython37site-packagesnumpy__init__.py", line 143, in <module>
from . import _distributor_init
File "C:UsersAlexAppDataRoamingPythonPython37site-packagesnumpy_distributor_init.py", line 26, in <module>
WinDLL(os.path.abspath(filename))
File "C:UsersAlexAnaconda3libctypes__init__.py", line 364, in __init__
self._handle = _dlopen(self._name, mode)
OSError: [WinError 193] %1 is not a valid  Win32 application 

如果有人能帮助我，我将不胜感激！

Answer 1

请在此处检查此答案

我想你在用蟒蛇。

您安装了错误版本的python，就像您安装了32位系统，而u安装了64位版本的python一样。

解决方案：以管理员身份重新安装Anaconda(但首先删除第一个和所有与其相关的文件(。

希望这能解决你的问题。