如何使用Python拆分数据库中的一系列字符串，然后透视显示单词及其出现次数的结果

import pymysql
import pandas as pd

# 连接数据库
conn = pymysql.connect(host='localhost', user='username', password='password', database='database_name')
cursor = conn.cursor()

# 查询数据
sql = "SELECT column_name FROM table_name"
cursor.execute(sql)
results = cursor.fetchall()

# 拆分字符串并统计单词出现次数
word_count = {}
for result in results:
    words = result[0].split()
    for word in words:
        if word in word_count:
            word_count[word] += 1
        else:
            word_count[word] = 1

# 转换为DataFrame并透视显示结果
df = pd.DataFrame.from_dict(word_count, orient='index', columns=['Count'])
df = df.reset_index().rename(columns={'index': 'Word'})
df = df.sort_values(by='Count', ascending=False)

print(df)