Excel Gets a Python Boost for Data Analysis and Visualizations

The well-known spreadsheet program Excel now has a new feature that lets users run Python code inside of it.

[{"selector":"#anim-1b29f6ad-65c6-4ca4-a836-1c9c067eaeab","keyframes":{"transform":["translate3d(-132.20974%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f480b02e-4776-4505-8f40-929e7dfda7e5","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8e74c50d-f899-4dbf-8cf5-8d7933e7d2f1","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

Data analysis and visualization tasks are simple to complete with the robust programming language Python.

[{"selector":"#anim-ab5a99a3-96d9-4ee6-82ea-11a0961a9dcf","keyframes":{"transform":["translate3d(-122.10526%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2ec9ba7b-7f2d-4203-b161-d7918484a618","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ed48703e-3415-459d-a5a5-5823238bfb65","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

Excel users can use a range of Python libraries and tools with this functionality to improve their worksheets.

[{"selector":"#anim-cd6891cd-f0b0-45a2-b82f-d8366f903878","keyframes":{"transform":["translate3d(-131.69811%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-aef96d68-651d-40f8-af73-4b18efcbdbf9","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-df4124ec-9d7a-4330-baf3-a348d963beca","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

Users could use sci-kit-learn to implement machine learning algorithms, matplotlib to make charts and graphs, or pandas to work with data frames.

[{"selector":"#anim-92f002d3-5129-461a-a67e-5ffe54d29e8a","keyframes":{"transform":["translate3d(-120.13652%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fc3f77c0-d130-4fba-be0a-eb1d4b284480","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2ee6c3df-437f-4025-b3a3-3339b5fca2ad","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

A game-changer for data aficionados looking to combine the best of both worlds is Excel's Python boost.

[{"selector":"#anim-edb651de-7dae-4942-aa0a-d929052af459","keyframes":{"transform":["translate3d(-126.39405%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-da9cec1f-74e8-4582-806c-0ebbb8b3e572","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d3322b0a-d526-4d49-9cd4-48e3ee06a3a9","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

Excel Gets a Python Boost for Data Analysis and Visualizations

The well-known spreadsheet program Excel now has a new feature that lets users run Python code inside of it.

Data analysis and visualization tasks are simple to complete with the robust programming language Python.

Excel users can use a range of Python libraries and tools with this functionality to improve their worksheets.

Users could use sci-kit-learn to implement machine learning algorithms, matplotlib to make charts and graphs, or pandas to work with data frames.

A game-changer for data aficionados looking to combine the best of both worlds is Excel's Python boost.

Read More Stories