AI协助下菜鸟又变态的2种调试程序方法2024.6.12

# -*- coding: utf-8 -*-
"""
Created on Wed Jun 12 11:25:42 2024

@author: Administrator
"""

import pandas as pd
import pysnooper

def write_numbers_to_excel():
    # 创建一个包含1到100的数字列表
    numbers = list(range(1, 101))
    print(f"Numbers: {numbers}")  # 打印变量 numbers

    # 将列表转换为DataFrame
    df = pd.DataFrame(numbers, columns=['Number'])
    print(f"DataFrame:\n{df}")  # 打印变量 df

    # 将DataFrame写入Excel文件
    output_path = 'numbers_1_to_100.xlsx'  # 添加文件扩展名
    print(f"Output path: {output_path}")  # 打印变量 output_path
    df.to_excel(output_path, index=False)
    print("Excel file saved successfully")  # 确认保存成功

write_numbers_to_excel()

runfile('C:/Users/Administrator/Desktop/调试2024.6.12.py', wdir='C:/Users/Administrator/Desktop')
Source path:... C:\Users\Administrator\Desktop\调试2024.6.12.py
11:29:08.813790 call        12 def write_numbers_to_excel():
11:29:08.814790 line        14     numbers = list(range(1, 101))
New var:....... numbers = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, ... 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100]
11:29:08.814790 line        17     df = pd.DataFrame(numbers, columns=['Number'])
New var:....... df =     Number0        11        22        33       ...     9898      9999     100[100 rows x 1 columns]
11:29:08.814790 line        20     output_path = 'numbers_1_to_100.xlsx'
New var:....... output_path = 'numbers_1_to_100'
11:29:08.817789 line        21     df.to_excel(output_path, index=False)
11:29:08.820789 exception   21     df.to_excel(output_path, index=False)
Exception:..... ValueError: No engine for filetype: ''
Call ended by exception
Elapsed time: 00:00:00.011999
Traceback (most recent call last):

  File d:\Users\Administrator\anaconda3\lib\site-packages\pandas\io\excel\_base.py:827 in __new__
    engine = config.get_option(f"io.excel.{ext}.writer", silent=True)

  File d:\Users\Administrator\anaconda3\lib\site-packages\pandas\_config\config.py:243 in __call__
    return self.__func__(*args, **kwds)

  File d:\Users\Administrator\anaconda3\lib\site-packages\pandas\_config\config.py:115 in _get_option
    key = _get_single_key(pat, silent)

  File d:\Users\Administrator\anaconda3\lib\site-packages\pandas\_config\config.py:101 in _get_single_key
    raise OptionError(f"No such keys(s): {repr(pat)}")

OptionError: "No such keys(s): 'io.excel..writer'"


The above exception was the direct cause of the following exception:

Traceback (most recent call last):

  File ~\Desktop\调试2024.6.12.py:25
    write_numbers_to_excel()

  File d:\Users\Administrator\anaconda3\lib\site-packages\pysnooper\tracer.py:305 in simple_wrapper
    return function(*args, **kwargs)

  File ~\Desktop\调试2024.6.12.py:21 in write_numbers_to_excel
    df.to_excel(output_path, index=False)

  File d:\Users\Administrator\anaconda3\lib\site-packages\pandas\core\generic.py:2284 in to_excel
    formatter.write(

  File d:\Users\Administrator\anaconda3\lib\site-packages\pandas\io\formats\excel.py:834 in write
    writer = ExcelWriter(  # type: ignore[abstract]

  File d:\Users\Administrator\anaconda3\lib\site-packages\pandas\io\excel\_base.py:831 in __new__
    raise ValueError(f"No engine for filetype: '{ext}'") from err

ValueError: No engine for filetype: ''

import pandas as pd
import pysnooper

@pysnooper.snoop()
def write_numbers_to_excel():
    # 创建一个包含1到100的数字列表
    numbers = list(range(1, 101))

    # 将列表转换为DataFrame
    df = pd.DataFrame(numbers, columns=['Number'])

    # 将DataFrame写入Excel文件
    output_path = 'numbers_1_to_100.xlsx'  # 添加 .xlsx 扩展名
    df.to_excel(output_path, index=False)

    print(f"Excel file saved to {output_path}")

write_numbers_to_excel()

runfile('C:/Users/Administrator/Desktop/调试2024.6.12.py', wdir='C:/Users/Administrator/Desktop')
Source path:... C:\Users\Administrator\Desktop\调试2024.6.12.py
11:29:08.813790 call        12 def write_numbers_to_excel():
11:29:08.814790 line        14     numbers = list(range(1, 101))
New var:....... numbers = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, ... 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100]
11:29:08.814790 line        17     df = pd.DataFrame(numbers, columns=['Number'])
New var:....... df =     Number0        11        22        33       ...     9898      9999     100[100 rows x 1 columns]
11:29:08.814790 line        20     output_path = 'numbers_1_to_100.xlsx'
New var:....... output_path = 'numbers_1_to_100'
11:29:08.817789 line        21     df.to_excel(output_path, index=False)
11:29:08.820789 exception   21     df.to_excel(output_path, index=False)
Exception:..... ValueError: No engine for filetype: ''
Call ended by exception
Elapsed time: 00:00:00.011999
Traceback (most recent call last):