SQLite table to DataFrame at Colab platform using read_sql()

import pandas as pd
df=pd.read_excel('student.xlsx',index_col='id') # DataFrame created using student file

from sqlalchemy import create_engine,text
from sqlalchemy.exc import SQLAlchemyError
path="sqlite:///my_data.db" # create a SQLite database in google colab session storage
my_conn = create_engine(path)
my_conn=my_conn.connect() # connection is established 
try:    
    result = my_conn.execute(text("select name from sqlite_master where type = 'table'"))
    for row in result:
      print(row) # Display all tables in SQLite database 
except SQLAlchemyError as e:
        error = str(e.__dict__['orig'])
        print(error)   

df.to_sql(con=my_conn,name='student',if_exists='replace') # create student table in sqlite database

try:    
    result = my_conn.execute(text("SELECT name FROM sqlite_master WHERE  type = 'table'"))
    for row in result:
      print(row) # List all tables in our SQLite database 
except SQLAlchemyError as e:
        error = str(e.__dict__['orig'])
        print(error) 

('student',)

result = my_conn.execute(text("SELECT *  FROM student"))
for row in result:
  print(row) # display row from student table. 

read_sql()

df=pd.read_sql('SELECT * FROM student',my_conn,index_col='id')
print(df) # all rows of data 

df=pd.read_sql('SELECT * FROM student WHERE class="Five"',my_conn,index_col='id')
print(df) # All rows of class = 'Five'

q="SELECT * FROM student WHERE class='Five'"
df=pd.read_sql(q,my_conn,index_col='id')
print(df)

params

q="SELECT * FROM student WHERE class=:my_class"
df=pd.read_sql(q,my_conn,index_col='id',params={'my_class':'Five'})

q="SELECT * FROM student WHERE class=:my_class AND mark >=:my_mark"
my_dict={'my_class':'Five','my_mark':80}
df=pd.read_sql(q,my_conn,index_col='id',params=my_dict)
print(df)

Questions