I've used it for data migration combined with Jupyter Notebook.

While I'm fully aware of DataFrame, I am more familiar with SQL. So I used Python scripts in Jupyter to load Excel sheets into DuckDB, and then run queries in DuckDB. Eventually I export the data back to Excel or SQL Server.

Not the most efficient way to do this I know, but it works for me.