代码中的错误是什么。?它没有被执行。该怎么办?

What is the error in the code.? It is not getting executed. What to do?

提问人:Marcusaurelius 提问时间:11/17/2023 最后编辑:Error_2646Marcusaurelius 更新时间:11/17/2023 访问量:46

问:

我正在使用 kaggle notebook 使用 SQL 清理数据集。 我打算转换表“housing”的“Saledate”列,该表具有时间戳到日期数据类型。 下面是代码

# This Python 3 environment comes with many helpful analytics libraries installed
# It is defined by the kaggle/python Docker image: https://github.com/kaggle/docker-python
# For example, here's several helpful packages to load

import numpy as np # linear algebra
import pandas as pd # data processing, CSV file I/O (e.g. pd.read_csv)

# Input data files are available in the read-only "../input/" directory
# For example, running this (by clicking run or pressing Shift+Enter) will list all files under the input directory

import os
for dirname, _, filenames in os.walk('/kaggle/input'):
    for filename in filenames:
        print(os.path.join(dirname, filename))

# You can write up to 20GB to the current directory (/kaggle/working/) that gets preserved as output when you create a version using "Save & Run All" 
# You can also write temporary files to /kaggle/temp/, but they won't be saved outside of the current session


# loading dataset to dataframe
dataframe=pd.read_excel('/kaggle/input/nashville-housing-data/Nashville Housing Data for Data Cleaning (reuploaded).xlsx')
dataframe

#importing create_engine from sqlalchemy module

from sqlalchemy import create_engine

#creating engine

engine=create_engine('sqlite://', echo=False)

#loading dataframe to the sql table with name "housing"
dataframe.to_sql("housing",con=engine)

sql='''
UPDATE housing
SET Saledate = CONVERT(Date, Saledate);'''

with engine.connect() as connection:
    result = connection.execute(sql)

代码未执行。 这有什么错误??有人可以帮我吗

SQL Kaggle

评论

0赞 Jonas Metzler 11/17/2023
什么数据类型有列?我猜您尝试使用不同的数据类型保存值。如果这是真的,则需要先更改该列。Saledate
0赞 Error_2646 11/17/2023
您是否收到异常消息?打印“结果”时会发生什么?python 中有一些情况,我无法与 sqlalchemy 交谈,您的代码将运行而不会失败,但是当您尝试在这种情况下访问“结果”时,您会得到异常。
0赞 Marcusaurelius 11/17/2023
@JonasMetzler,其 DATETIME 类型

答: 暂无答案