Getting to know Python in Excel

Summary

You have learned a lot and worked through a lot of examples in this chapter. You started by learning where Python in Excel is available and how to access it. Through simple Python examples, you have explored how the Excel frontend differs from other platforms. You have seen how Python objects are created and how to view their properties. You have worked your way from simple Python objects to arrays, and you have extracted Excel entities. You have learned how to troubleshoot the errors encountered when using Python in Excel. Finally, you have become familiar with more Python syntax.

We decided to divide the introduction to Python objects in this way because the star of the show is the way that Python interacts with Excel data. You have learned enough about Python objects and constructs to move on to more complex Python code, and you are ready for the examples in the rest of the book. Even if you plan to use AI to write Python code, you must understand what is being created so that you can troubleshoot and adapt the code produced to tell the story of the data.

In the next chapter, you will learn about some Python libraries that the Python community has created to help you perform advanced data analysis by using tried and tested modules of Python code.