-
Book Overview & Buying
-
Table Of Contents
Python in Excel for Data Analytics
By :
In the previous chapter, we worked through sending simple, single-cell values into Python in Excel and getting a feel for how the Python in Excel environment behaves.
In practice, though, you'll almost always be working with data that's richer than that. So in this chapter, we'll step up to a more realistic scenario: handling a proper tabular dataset with rows and columns, the kind of data you actually see in real Excel workbooks.
While it's possible to read this data directly from a raw Excel range, I strongly recommend converting it into a table first. This conversion will help Python better understand the underlying data and ensure it is structured correctly when imported. It will also make the dataset more extensible and dynamic, should you need to modify it by adding columns or rows.
Another reason to put your data into a table is that it makes everything much easier once you start using Copilot's Advanced Analysis features...