chdb-io / chdb

chDB is an in-process OLAP SQL Engine 🚀 powered by ClickHouse
https://clickhouse.com/docs/en/chdb
Apache License 2.0
2.03k stars 72 forks source link

Question About Query On Pandas DataFrame #87

Closed zhuzhuyan93 closed 1 year ago

zhuzhuyan93 commented 1 year ago

how can i deal with 2 table join operation when i query on pandas dataframe?


import pandas as pd

tbl1 = cdf.Table(dataframe=pd.DataFrame({'a': [1, 2, 3], 'b': ['a', 'b', 'c']}))
tbl2 = cdf.Table(dataframe=pd.DataFrame({'a': [4, 2, 3], 'c': ['c', 'd', 'c']}))  ```

how can i join tbl1 and tbl2 on columns 'a'?  
i cant deal with it through demo
thanks