Ibis pandas dataframe connection

Question

How can we work with ibis and pandas dataframe?

conn = ibis.pandas.connect({'data': dataframe}) 
projection = conn.table('data')

It is throwing error :

module 'ibis' has no attribute 'pandas'

Any suggestions would be appreciated

Answer 1

ibis is a connectivity tool from you python to remote Databases.

the result would be stored in pandas

so you need to use like below

conn = ibis.sqlite.connect('data': 'data.db')
data = conn.table('table')

To know more about ibis please refer this link: https://ibis-project.org/docs/tutorial/01-Introduction-to-Ibis.html#Getting-started

Sample