No-code BI and ETL tools are intended mainly as a replacement for Excel, not a replacement for Python.
If you are an accomplished Python programmer, you might code a solution or (e.g. if you want to do something ad hoc quickly) use a no-code tool.
If you aren't a programmer, your choice is typically: learn Python, use Excel, wait for a programmer to do it for you or use a no-code tool. A no-code tool will often be by far the best solution.