Python in Excel — Hands on Review
Excel is already popular spreadsheet app out their, having capabilities of various data minipulation ways, connecting any data sources, either local txt files, to databases to websites, lots of formulas such as financial, logic, date and time, lookup & math, number of charts and PivotTables.
On the other hand we have Python, though there are lots of applications which includes Data Sciences, using popular libraries like Pandas & Numpy, the data can be mined in any way. Now with Excel, it is boom for the regular office automation guys sitting in office can produce outstanding and out of the box reports using Python libraries, stuck with scripting this, no problem, because CoPilot is their to help you with python as well.
I had my eyes on it since the release of pulic review of Python in Excel in August 2023. It was already big news for me, as I already know the power of Python it self in data sciences and bulking up with excel or literly enough.
How it works
Python in Excel uses Pandas as main library to work with Excel Data. It supports two…
