在Pandas和pyodbc SQL Server中使用百分比(%)，没有错误

import pandas as pd

# 创建一个包含百分比数据的DataFrame
data = {'Percentage': [0.25, 0.5, 0.75]}
df = pd.DataFrame(data)

# 将百分比数据转换为浮点数类型
df['Percentage'] = df['Percentage'].astype(float)

# 计算百分比
df['Percentage'] = df['Percentage'] * 100

# 格式化输出
df['Percentage'] = df['Percentage'].round(2).astype(str) + '%'

print(df)

import pyodbc

# 连接到SQL Server数据库
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=localhost;DATABASE=mydatabase;UID=username;PWD=password')

# 创建游标
cursor = conn.cursor()

# 执行SQL查询
cursor.execute("SELECT column1, column2, column3 * 100 AS Percentage FROM mytable")

# 获取查询结果
results = cursor.fetchall()

# 输出结果
for row in results:
    print(f"Column 1: {row.column1}, Column 2: {row.column2}, Percentage: {row.Percentage}%")

# 关闭游标和连接
cursor.close()
conn.close()