Python in Excel Step by Step
ISBN: 9789377068295
274 pages
Publication Year: 2026
For institution adoption: acadmktg@wiley.com
For more information write to us at: acadmktg@wiley.com
Description
This book is designed to help professionals who use Excel for data analysis tap into the advanced capabilities of Python, a powerful tool for data science. By learning Python in the context of Excel, readers will be able to perform more complex analyses, build scalable models, and future-proof their data skills in an increasingly Python-driven world.
Key Features:
- Step-by-step guidance on Python's core concepts tailored to Excel users.
- Practical applications of Python for Excel tasks like forecasting and cluster analysis.
- Extensive coverage of pandas and plotnine libraries for data manipulation and visualization in Excel.
- A roadmap for continued Python study and skill development for Excel users.
CHAPTER 1: INTRODUCING PYTHON IN EXCEL 1
1.1 Introducing Python in Excel 1
1.2 How Python in Excel Works 2
1.3 Why Python in Excel? 5
1.4 Continue Your Learning 11
CHAPTER 2: DATA TYPES 13
2.1 Integers 15
2.2 Floats 17
2.3 Strings 19
2.4 Booleans 26
2.5 Continue Your Learning 31
CHAPTER 3: DATA STRUCTURES 33
3.1 Lists 33
3.2 Dictionaries 41
3.3 Tuples 49
3.4 Sets 51
3.5 Slicing Data 55
3.6 Continue Your Learning 59
CHAPTER 4: CONTROL FLOW AND LOOPS 61
4.1 if/else Statements 61
4.2 for Loops 69
4.3 while Loops 73
4.4 Comprehensions 76
4.5 Continue Your Learning 83
CHAPTER 5: FUNCTIONS 85
5.1 Introducing Functions 85
5.2 Lambdas 96
5.3 Continue Your Learning 99
CHAPTER 6: DATA TABLE FUNDAMENTALS 101
6.1 Introducing Pandas 101
6.2 Loading Data 104
6.3 Exploring Dataframes 109
6.4 The Workbook So Far 119
6.5 Continue Your Learning 120
CHAPTER 7: WORKING WITH COLUMNS 121
7.1 Exploring Columns 121
7.2 Numeric Columns 128
7.3 String Columns 138
7.4 Datetime Columns 151
7.5 The Workbook So Far 158
7.6 Continue Your Learning 160
CHAPTER 8: WORKING WITH DATA TABLES 161
8.1 AdventureWorks Data Analysis 161
8.2 Changing Dataframes 161
8.3 Filtering Dataframes 174
8.4 Combining Dataframes 184
8.5 Pivoting Dataframes 193
8.6 The Workbook So Far 205
8.7 Continue Your Learning 207
CHAPTER 9: DATA VISUALIZATION 209
9.1 Introducing Plotnine 209
9.2 Categorical Visualizations 211
9.3 Time Series Visualizations 235
9.4 The Workbook 243
9.5 Continue Your Learning 243
CHAPTER 10: YOUR DIY DATA SCIENCE ROADMAP 245
10.1 You've Got This 245
10.2 The Roadmap 246
10.3 AI with Copilot in Excel 254
10.4 Continue Your Learning 260