Excel weds Anaconda

Anaconda(not the 1997 film), a key distributor of Python tools, has announced a collaboration with Microsoft to integrate Python with Excel. Sounds like a killer combination, huh? The widely used spreadsheet tool that powers the whole finance industry is getting access to data analytics capabilities thanks to the new Anaconda Python Distribution for Excel, which is currently in beta. Users will now be able to prepare, manipulate, analyse, and visualise data within Excel by using Python libraries and tools because of this integration.

The community has long requested for significant Python libraries like PyTorch, matplotlib, SciPy, and Scikit-learn to be integrated into Excel, and Peter Wang, CEO and co-founder of Anaconda, believes that the collaboration addresses the request. In order to assist data scientists with their sexy jobs(as Havard Business Review once said), Anaconda provides hundreds of Python tools and a few R tools, which are currently under oxygen support. This ground-breaking integration completely changes how Excel users and Python programmers approach data analysis and introduce advanced analytics to a wider audience. This integration provides access to the vast range of Python libraries in Excel.

With powerful visualisation libraries like matplotlib and seaborn, we can easily ace our projects with an A++ and impress our arithmophobic bosses by presenting our data in a visually appealing “Accidentally Wes Anderson” way.

In-depth and Non-boring Statistical analysis:

With Python libraries such as pandas and statsmodels, we can easily elevate our data analysis game by performing complex statistical analysis within Excel itself.

.ipynb, who?

We can easily share our Excel-Python analyses with our colleagues in microsoft teams and Microsoft Outlook in Excel-friendly excel friendly format.

Furthermore, Python in Excel is not compromised with security as it runs on Microsoft Cloud. The dominating language for data research and analysis is Python, which has already knocked out SAS and R. With this integration, Microsoft further aims to enable millions of Excel users to leverage the vast number of open-source data tools available in Anaconda’s Python distribution. Corporate Vice President of Microsoft Excel Benoit Barabe believes that this partnership ushers in a new era of Excel, enabling comprehensive visualisations, extensive data manipulation, advanced analytics, and machine learning in a familiar setting.