pandasql_sqldf_query_pandas_dataframe_with_sql_syntax.py

1from pandasql import sqldf
2import pandas as pd
3
4# Create a sample dataset
5df = pd.DataFrame({
6    "name": ["Alice", "Bob", "Charlie"],
7    "age": [25, 30, 35]
8})
9
10# Define a SQL query
11query = "SELECT * FROM df WHERE age > 27"
12
13# Execute the query against the dataframe
14result = sqldf(query, locals())
15
16print(result)