SQLITE fetching vs pandas read_sql_query

Q&A DQ Courses
, ,
#1

Screen Link:
https://app.dataquest.io/m/256/querying-sqlite-from-python/8/fetching-a-specific-number-of-results

My Code:

So my code is fine. i understand how to connect and fetch query values , but i don’t understand why would anyone use this method vs importing queries into pandas.

Can someone give me a little bit of insight on use cases? Thanks!

#2

I guess one would use this method when not planning to use pandas later on and use pure python instead or some other library.