-
Book Overview & Buying
-
Table Of Contents
Python in Excel for Data Analytics
By :

https://packt.link/EarlyAccessCommunity
In the previous chapter, you learned how to write Python code in Excel and load data into pandas DataFrames. Here, you will build on that foundation to perform real analysis. The goal is simple: take the kinds of tasks you already do in Excel and execute them faster, more flexibly, and more reproducibly, using pandas.
pandas is the core tool for data manipulation in Python, and it will be your primary engine throughout this book. If Excel is your workspace for viewing and presenting data, pandas is what powers the underlying transformations, letting you filter, sort, group, and summarize data efficiently.
The focus in this chapter is practical. You will select rows and columns, create new fields, and aggregate data to answer specific questions. Where relevant, each technique is paired with its Excel equivalent so you can clearly see how your existing skills carry over into pandas.
In this chapter, you will cover...