Python in Excel Step-by-Step

INDEX

Note: Page numbers in italics refers to figures.

A

• accessor, 138
• additional column handling, 186–187
• AdventureWorks data analysis, 102, 159, 208
• aesthetic, 207
• aggregating
  • multiple columns, 192–194, 193–194
  • one column, 189–191, 190–192
• artificial intelligence (AI), 1
  • advanced analysis mode, 245–246
  • confident of, 247
  • Copilot in Excel, 244–249
  • correction, 248
  • default mode, 245
  • double-check, 248
  • Excel pane, 245
  • generated Python in Excel code, 247
  • hallucinations, 248
  • recognizing dataset, 246
  • segmentation analysis, 246
  • steps for clustering with k-means, 247
  • trust but verify work, 248
  • vibing, 246
• assignment, 20
• assign() method, 161–162, 162
  • adding columns, 164–167, 166, 167
  • changing columns, 162–164, 163, 164
  • data wrangling, 167–169, 168–169
• Azure cloud, 2–4, 3, 16

B

• bar charts, 206–209, 207–210
• beginning index, 58
• binary predictions, 242
• boolean logic, 26, 30
• booleans, 26–31, 27
  • checking equivalence, 27–29, 28
  • definition of, 26–27
  • logical comparisons, 29
  • logical operators, 30–31
  • zeros and ones, 29–30
• boolean values, 26, 27, 152
• bundle, 96

C

• calculating elapsed time, 153–155, 154
• calculation order, 95, 162, 204
• case folding, 137
• casting, 19
• categorical visualizations, 203–225, 203, 204
  • bar charts, 206–209, 207–208
  • column charts, 221–225, 223, 224
  • faceted bar charts, 211–221, 212–214, 216–218, 220–222
  • initial data wrangling, 204–206
  • proportional bar charts, 209–211
• cat() method, 139–140, 140
• changing dataframes, 159–171
  • adding columns with assign(), 164–167, 166 ...