python - 如何绘制从 SQL 获得的数据图表？

Question

我正在 DataQuest 中做一个练习，我试图用图形表示一组从 SQL 获得的数据。

它给我错误:

AttributeError: 'str' object has no attribute 'values'

如何在 x 轴上设置 name 并在 y 轴上设置 Pop_Density？我知道 Python 无法绘制名称，但我如何将名称与数字一起引用？我是否必须先将 DataFrame 转换为字典？有问题的行在下面评论。

import pandas as pd
import sqlite3

conn = sqlite3.connect("factbook.db")

q7 = '''
SELECT name, CAST(population as float)/CAST(area_land as float) AS Pop_Density
FROM facts
ORDER BY Pop_Density DESC
LIMIT 20
'''

density = pd.read_sql_query(q7, conn)
print(density)

%matplotlib inline

import matplotlib.pyplot as plt
import seaborn as sns

fig = plt.figure(figsize=(10,10))
ax = fig.add_subplot(111)

bar_heights = density['name'].iloc[0].values # <-- line with problem. 
bar_positions = arange(5) + 0.75
tick_positions = range(1, 20)

ax.bar(bar_positions, bar_heights, 0.5)
ax.set_xticks(tick_positions)
ax.set_xticklabels(num_cols, rotation=90)

ax.set_xlabel("Country")
ax.set_ylabel("Population Density")
ax.set_title("Countries With The Highest Population Density")

Answer 1

bar_heights = density['Pop_Density'].values
bar_positions = np.arange(len(bar_heights)) + 0.75
tick_positions = range(1, len(bar_heights) + 1)

ax.bar(bar_positions, bar_heights, 0.5)
ax.set_xticks(tick_positions)
ax.set_xticklabels(density['name'], rotation=90)