!pip install mysqlclient
import pandas as pd
from sqlalchemy import create_engine
# Step 1: Read the CSV file into a DataFrame
path = "baby_names_2021.csv"
df = pd.read_csv(path)
print(df.shape) # To check the shape of the DataFrame
# Step 2: Create a connection to the database
username = "username"
password = "piece_of_pork"
hostname = "ssss.mysql.pythonanywhere-services.com"
databasename = "database"
# Create the database engine
engine = create_engine(f'mysql://{username}:{password}@{hostname}/{databasename}')
# Step 3: Upload the DataFrame to the SQL table
df.to_sql('baby_data', engine, if_exists='append', index=False)
NameError: name '_mysql' is not defined
1条答案
按热度按时间yuvru6vn1#
mysqlclient
安装有问题。检查你是否有一个可用的轮子为您的操作系统和您的python版本,特别是为Windows。也许你必须从源代码构建库。查看
MySQLdb
的常见问题:如果您看到这一点,很可能是您在安装MySQLdb时做错了什么;阅读(或阅读)README。_mysql是与MySQL客户端库接口的低级C模块。
编辑:
在您的安装目录(例如
venv/lib/python-<version>/site-packages/MySQLdb
),检查是否有如下文件: