Power Query Alternative Excel Adddon
Posted by Puzzleheaded_Luck641@reddit | Python | View on Reddit | 11 comments
Hi Everyone,
I am data analyst as professional.
my day to day tool is excel and it's add-ons.
I love power Query it is super compatible.
Power Query made in .net and M Code as Query language.
it is very slow compare with pandas and Polars.
I was thinking if there is a excel add-on if anyone made similar to Power Query in python.
I don't like using xlwings.
keithcu@reddit
I built a plugin for LibreOffice Writer/Calc: https://github.com/KeithCu/writeragent
I'll look into adding PowerQuery features 🤣
Puzzleheaded_Luck641@reddit (OP)
That would be awesome 😎
keithcu@reddit
Well, try out my extension and let me know what you think. It doesn't have the UI or M language, however, the LLMs should make changes to your documents for you just by asking.
I could let you generate / write Python scripts to automate it and re-use it. Unfortunately, I currently don't depend on Numpy, but I could figure out an optional way to support it without bundling it.
Puzzleheaded_Luck641@reddit (OP)
I don't have Libra, not allowed in my work
Meathixdubs@reddit
I tried forcing Excel to be the center of everything for way too long and it just got messy.
DuckDB ended up feeling way cleaner for me, especially if you’re already semi-comfortable with SQL. Less fighting the tool, more just getting stuff done.
No_Soy_Colosio@reddit
Probably not, but you can just extract the data from the file and process with Polars/DuckDB if you prefer SQL.
marr75@reddit
Just cut the Excel out.
Puzzleheaded_Luck641@reddit (OP)
😃. I wish
ianitic@reddit
Have pandas/polars or duckdb(if you know sql choose this) read in sources and export to excel to separate workbooks. If you must you could use vba within excel that calls the Python script then refreshes PQ to consume the resulting file.
Otherwise you can use PowerBI which has Python available within PowerQuery as well as r. Likely PQ will just perform better in PBI anyways though.
Otherwise there's definitely a handful of ways you can daisy chain it like the vba calling python way.
amazonv@reddit
Python in Excel from anaconda
https://www.anaconda.com/partners/python-in-excel
Puzzleheaded_Luck641@reddit (OP)
Python is Also available excel native but external Data or operation doesn't work