python - Type error when trying to visualize a sqlite3 query

Question

I get this error

TypeError: object of type 'sqlite3.Cursor' has no len()

when trying to visualize a sqlite3 query in Seaborn. I am using Python 3.

#query that outputs 'Contintent', 'Year', 'Avgtemperature'
temp_increase_continents = c.execute("""
                                     SELECT Region, Year, AVG(Avgtemperature)
                                     FROM city_temperature
                                     GROUP BY Year
                                     ORDER BY Region
                                     """)
c.fetchall

#lineplot for above query
sns.lineplot(data=temp_increase_continents)
plt.show()

conn.commit()
conn.close()

Output should be a lineplot of the given query's result.

question from:https://stackoverflow.com/questions/65881025/type-error-when-trying-to-visualize-a-sqlite3-query

Answer 1

Waitting for answers