将 dataframe 类型数据的某一列转换为列表

import pandas as pd
import pymysql

conn = pymysql.connect(host='xxxx', user='xxx', password='xxx', database='xxx')
cursor = conn.cursor()
s_sql = 'select * from book'
df = pd.read_sql(s_sql, conn)
print(df['count'])  # ------> 是Series数据类型，可以直接tolist()
print(df['count'].tolist())
# 0    2
# 1    3
# 2    1
# 3    5
# Name: count, dtype: int64
# [2, 3, 1, 5]

s_sql = 'select count from book'
df = pd.read_sql(s_sql, conn)
print(df)    # -----> 是Dataframe数据类型，不可以直接进行tolist()
#    count
# 0      2
# 1      3
# 2      1
# 3      5