Traceback (most recent call last): File "C:\Users\honey\Desktop\TXT_EXCEL\TXT_EXCEL.py", line 100, in <module> _df = deal_txt(_path) ^^^^^^^^^^^^^^^

这个错误提示不完整，缺少了具体的错误信息。不过根据代码的结构来看，这个错误可能是由于deal_txt函数内部出现了错误导致的。你可以尝试打印出具体的错误信息，例如将deal_txt函数修改如下： ```python def deal_txt(path): with open(path,'rb') as f: result=chardet.detect(f.read()) try: df = pd.read_csv(path, sep='|', header=None, encoding=result['encoding'] ) except Exception as e: print(f"Error reading file {path}: {e}") return None return df ``` 这样可以将读取文件时出现的错误打印出来，方便你进行调试。

Traceback (most recent call last): File "C:\Users\honey\Desktop\TXT_EXCEL\TXT_EXCEL.py", line 105, in <module> _df.to_excel(f'./{_path.stem}.xlsx', index=False, header=False) ^^^^^^^^^^^^ AttributeError: 'NoneType' object has no attribute 'to_excel' Error reading file 9762IT.CTSM0V30_20230201_20230228.txt:'gb2312' codec can't decode byte 0xab in position 26923: illegal multibyte sequence

这个错误提示在第105行，说明是在将DataFrame转换为Excel文件时出现了错误。根据错误提示，可能是由于DataFrame为空导致的（即deal_txt返回了None）。根据deal_txt函数的代码，当读取文件出现错误时，会返回None。因此，你需要在主函数中对_df进行判断，只有当_df不为空时才进行转换为Excel文件的操作。此外，根据错误提示，文件编码为'gb2312'，但是在使用chardet.detect函数时，可能会出现误判的情况。因此，你可以在deal_txt函数中加入一个判断，如果检测到的编码不是'gb2312'，就使用'gbk'编码进行读取。修改后的代码如下： ```python def deal_txt(path): with open(path,'rb') as f: result=chardet.detect(f.read()) try: if result['encoding'] != 'gb2312': df = pd.read_csv(path, sep='|', header=None, encoding='gbk' ) else: df = pd.read_csv(path, sep='|', header=None, encoding=result['encoding'] ) except Exception as e: print(f"Error reading file {path}: {e}") return None return df for _path in Path('./').glob('*.txt'): _df = deal_txt(_path) if _df is not None: _df.to_excel(f'./{_path.stem}.xlsx', index=False, header=False) deal_style(f'./{_path.stem}.xlsx') ``` 这样就可以避免出现空DataFrame转换为Excel文件的情况，同时对于文件编码不确定的情况也进行了处理。

解释下F:\python_projects\venv\Scripts\python.exe F:\result\eye_first_move_to_objects_time.py Traceback (most recent call last): File "F:\result\eye_first_move_to_objects_time.py", line 73, in <module> coordinate_x = float(fix_record[row_index][5].value) ValueError: could not convert string to float: '.' Error in atexit._run_exitfuncs: Traceback (most recent call last): File "F:\python_projects\venv\lib\site-packages\openpyxl\worksheet\_writer.py", line 32, in _openpyxl_shutdown os.remove(path) PermissionError: [WinError 32] 另一个程序正在使用此文件，进程无法访问。: 'C:\\Users\\dell\\AppData\\Local\\Temp\\openpyxl.byyckh9l' Exception ignored in: <generator object WorksheetWriter.get_stream at 0x000001FBA5104820> Traceback (most recent call last): File "F:\python_projects\venv\lib\site-packages\openpyxl\worksheet\_writer.py", line 300, in get_stream File "src\lxml\serializer.pxi", line 1834, in lxml.etree._FileWriterElement.exit File "src\lxml\serializer.pxi", line 1570, in lxml.etree._IncrementalFileWriter._write_end_element lxml.etree.LxmlSyntaxError: inconsistent exit action in context manager Exception ignored in: <generator object WriteOnlyWorksheet._write_rows at 0x000001FBA5104270> Traceback (most recent call last): File "F:\python_projects\venv\lib\site-packages\openpyxl\worksheet\_write_only.py", line 75, in _write_rows File "src\lxml\serializer.pxi", line 1834, in lxml.etree._FileWriterElement.exit File "src\lxml\serializer.pxi", line 1568, in lxml.etree._IncrementalFileWriter._write_end_element lxml.etree.LxmlSyntaxError: not in an element Process finished with exit code 1

这是一个 Python 程序运行时出现的错误信息。其中，第一行是命令行窗口中输入的 Python 程序执行命令，指定了 Python 解释器和要执行的 Python 文件的路径。接下来是一个 traceback，它展示了程序运行时的错误信息。在这个例子中，程序在第 73 行尝试将一个字符串转换为浮点数，但该字符串是一个点，无法转换。此外，在 traceback 中还显示了一些在程序结束时出现的异常，这些异常通常与文件操作有关。在这个例子中，程序试图删除一个文件，但该文件正在被另一个程序使用，因此无法删除。最后两行 traceback 是与 lxml 库相关的异常，这些异常可能与程序中使用的 Excel 文件有关。

阅读全文

Traceback (most recent call last): File "C:\Users\honey\Desktop\TXT_EXCEL\TXT_EXCEL.py", line 100, in <module> _df = deal_txt(_path) ^^^^^^^^^^^^^^^

相关推荐

txt_excel.py

Mac下anaconda中Spyder打开报错Traceback(most recent call last)…问题

pytorch数据预处理错误的解决

D:\Python\python.exe C:\Users\wy123\Desktop\Excel\excel_concat.py Traceback (most recent call last): File "C:\Users\wy123\Desktop\Excel\excel_concat.py", line 8, in <module> result =pd.concat(dfs) File "D:\Python\lib\site-packages\pandas\core\res

Traceback (most recent call last): File "call_student.py", line 56, in <module> File "tkinter\__init__.py", line 4130, in __init__ File "tkinter\__init__.py", line 4075, in __init__ _tkinter.TclError: couldn't open "背景图片.png": no such file or directory

Traceback (most recent call last): File C:\Users\胡志成\chatgpt_academic\main.py, line 238, in <module> main() File C:\Users\胡志成\chatgpt_academic\main.py, line 4, in main import gradio

Traceback (most recent call last): File "check_excel\check_excel.py", line 13, in <module> ModuleNotFoundError: No module named 'openpyxl'

Traceback (most recent call last): File C:\Users\小杨\Desktop\Yang\Yang\lstm.py, line 78, in <module>

C:\Users\Honey\PycharmProjects\pythonProject5\venv\Scripts\python.exe C:/Users/Honey/Desktop/feiji/飞机大战/飞机大战.py Traceback (most recent call last): File "C:/Users/Honey/Desktop/feiji/飞机大战/飞机大战.py", line 2, in <module> import pygame File "C:\Users\

Exception in Tkinter callback Traceback (most recent call last): File "E:\python\lib\tkinter\__init__.py", line 1921, in __call__ return self.func(*args) File "C:\Users\lenovo\Desktop\E-book\interface.py", line 144, in on_mousewheel self.canva

大家在看

NFC_Reader.rar

KD-C50对讲机频道调节.rar

WMS软件国内主要供应商分析.pptx

pb9_pb_

Unity3d WorldComposer TerrainComposer

最新推荐

Mac下anaconda中Spyder打开报错Traceback(most recent call last)…问题

适用于XP系统的WM DRM SDK 10安装教程

兼容性不再难

企业级部署本地知识库dify

自定义星型评分控件源码的实现与应用

小栗子机器人2.9.3：终极安装与配置指南

apt install protobuf Reading package lists... Done Building dependency tree... Done Reading state information... Done No apt package "protobuf", but there is a snap with that name. Try "snap install protobuf"

老友记第九季中英文台词解析

小栗子机器人架构升级秘籍

apt install httpd-tools Reading package lists... Done Building dependency tree... Done Reading state information... Done E: Unable to locate package httpd-tools

Traceback (most recent call last): File "call_student.py", line 56, in <module> File "tkinter\init.py", line 4130, in init File "tkinter\init.py", line 4075, in init _tkinter.TclError: couldn't open "背景图片.png": no such file or directory

Exception in Tkinter callback Traceback (most recent call last): File "E:\python\lib\tkinter\init.py", line 1921, in call return self.func(*args) File "C:\Users\lenovo\Desktop\E-book\interface.py", line 144, in on_mousewheel self.canva