Pandas 数据框中的单元格具有 Excel 工作簿中不存在的异常符号

pandas 如何处理和解释 excel 文件的字符编码是一个问题。不确定 ['com_it'] 中的数据类型。最初导入 Excel 工作簿时，请尝试以下两个选项。我相信选项 1 将解决您的问题。如果没有，请尝试选项 2。

选项 1

尝试在创建数据帧时将引擎定义为 openpyxl。

onmouseenter

确保你的 pandas/numpy 是最新的并且你已经安装了 openpyxl。

   array_x = np.array([1,2,3])
   array_y = np.array([1,3])
   array_z = np.array([1,3])
   array3D = something
   for ix,x in enumerate(array_X):
       for iy,y in enumerate(array_y):
           for iz,z in enumerate(array_z):
               array3D[ix][iy][iz] *= x*y*z

PyPi openpyxl

选项 2

在创建数据帧文件时传递字符编码。

import pandas as pd 

com = pd.read_excel(excel_file_path,ENGIne='openpyxl')
pano2 = pd.read_excel(excel_file_path,ENGIne='openpyxl')

非常感谢您！我一直在使用 tk 接口来自动拉取文件，而不是直接将它们输入到代码中。当我使用它运行选项 2 时，它产生了一个错误。我已经粘贴了下面的代码。还有另一种编码 UTF-8 的方法吗？

import pandas as pd
import numpy as np
import openpyxl
from openpyxl.workbook import Workbook
from openpyxl.utils.dataframe import dataframe_to_rows
from openpyxl import load_workbook
from openpyxl.worksheet.table import Table
import tkinter as tk
from tkinter import filedialog
from tkinter import messagebox
import xlrd
import test_functions as tf 
import String


## UI - Asking user for their input and output files
root = tk.Tk()
root.withdraw()
root.pano2 =  filedialog.askopenfilename(initialdir = "C:/",@R_673_10283@e = "SELEct the LOCATIOn of your Pano file",filetypes = (("Excel Files","*.xLSX"),("all files","*.*")))
root.com = filedialog.askopenfilename(initialdir = "C:/",@R_673_10283@e = "SELEct the LOCATIOn of your Com file","*.*")))
root.save_LOCATIOn = filedialog.asksaveasfilename(initialdir = "C:/",@R_673_10283@e = "Input name of file to be saved",defaultextension = ".xLSX","*.*")))

# ## ImporTing datasets
pano2 = pd.read_excel(root.pano2,encoding = 'utf-8') 
com = pd.read_excel(root.com,encoding = 'utf-8')