failed to run a simple SQL query for pandas dataframe

Question

I trying to run SQL query on a Pandas dataframe using pandasql.

import pandas as pd
import pandasql.sqldf as exec_sql

df = pd.DataFrame({'a': [1, 2, 3], 'b':[7, 8, 9]})
exec_sql("select top(3) * from df")

I'm having this error, that I could not find the reason.

error message:
PandaSQLException: (sqlite3.OperationalError) near "from": syntax error
[SQL: select top(3) * from df]
(Background on this error at: http://sqlalche.me/e/e3q8)

I try to read carefully the background of the error, from the error's message here but I could not found the cause. Maybe anyone might help to give me a track, please.

I would just use vanilla pandas: df.head(3)

Quang Hoang
– Quang Hoang

2021-01-07 22:02:31 +00:00
Commented Jan 7, 2021 at 22:02 — Quang Hoang
– Quang Hoang, Commented Jan 7, 2021 at 22:02

Paul Brennan · Accepted Answer · 2021-01-07 21:50:32Z

2

this is what you want

import pandas as pd
import pandasql.sqldf as exec_sql

df = pd.DataFrame({'a': [1, 2, 3], 'b':[7, 8, 9]})
exec_sql("select * from df LIMIT 3;")

Limit 3 will give you the first 3 rows

answered Jan 7, 2021 at 21:50

Paul Brennan

2,7364 gold badges23 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

failed to run a simple SQL query for pandas dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related