How to get Derby database table in Jupyter notebook dataframe and update table using Python

Question

I want to get my Derby database table into Jupyter dataframe and want to write data back to table. I searched but could not find connection string specific for derby.

Say database name is MyDatabase and there is a table employee with Fname, Lname and HireDate fields.

To access sqlite database, connection string could be something like conn_str = sqlalchemy.create_engine('sqlite:///MyDatabase.db') pd.read_sql('employee', conn_str)

How I will do for Derby table and if the database located at C:\MyProjects\MyDatabase.

Thanks.