Attention data analyzers and code enthusiasts! Microsoft just dropped a bombshell: Python is coming to Excel. That’s right, now you can combine the robust data analysis and visualization capabilities of Python with the tried and true features of Excel.
The public preview of this groundbreaking update is now available, and it promises to redefine the way you interact with spreadsheets.
Steffan Kinnestrand, General Manager of Modern Work at Microsoft, broke the scoop in a recent blog post. “Imagine digging into your data using powerful Python libraries and then honing your knowledge using Excel formulas, charts, and PivotTables,” he explained. “Now it’s all possible from the Excel environment you’re already comfortable with.” In short, you can now activate Python from the Excel ribbon and unleash advanced data analysis without missing a beat.
Worried about having to install additional software? Don’t be. Excel has you covered with built-in connectors and Power Query, so Python integrates as easily as adding a new worksheet. Even better, the Python calculations will run in the Microsoft cloud, saving your computer any heavy lifting.
And it’s not just formulas and pivot tables; the visual storytelling game has also improved. With Python charting libraries like Matplotlib and Seaborn, your Excel sheets can now boast fancy heatmaps, violin charts, and even swarm charts.
Microsoft has even partnered with Anaconda, a big name in the data science platform space, to ensure that commonly used Python libraries are easily accessible from within Excel. From now on, it’s pretty much plug-and-play.
Early adopters take note: Microsoft is first rolling out this feature to its 365 Insiders in the Beta channel, and it’s initially for Windows users only. But don’t worry, Mac users and other operating systems, your time will come. As for pricing, the Python functionality in Excel will be part of the Microsoft 365 subscription during the preview period. However, once the public preview stage is over, you’ll need a paid license to access some of these new Python features.
There you have it! Python is moving to Excel, and data analysis will never be the same again. Whether you’re a Python veteran or an Excel aficionado, this is the perfect opportunity to combine both worlds and take your data projects to the next level. Why not try it today?
Subscribe to our latest newsletter
To read our exclusive content, sign up now. $5/Monthly, $50/Yearly
Categories: Technology
Source: vtt.edu.vn