xxxxxxxxxx
from pandasql import sqldf
import pandas as pd
# Create helper function for easier query execution
execute = lambda q: sqldf(q, globals())
# Load your CSV files into DataFrames
df1 = pd.read_csv("file1.csv")
df2 = pd.read_csv("file2.csv")
# Execute query with a join and store the result
query = """
SELECT *
FROM df1
JOIN df2 ON df1.common_column = df2.common_column
"""
result_df = execute(query)
# Show results
result_df.head()