Teaching analytics with modern Excel
xlwings add-in for ExcelMany packages exist for working with Python and Excel, but xlwings may be the most powerful all-around due to its many reading and writing features. This versatility, however, comes at the cost of …
Continue Reading about How to install the xlwings add-in for Excel →
I've mentioned a few times on this blog (example) about the growing possibility for Python <> Excel interoperability. Here's a simple task done in a way I wasn't aware of (h/t -- where else? -- …
Continue Reading about How to list the worksheet names of an Excel workbook using Python Pandas →
1 hour to Power Query in Excel (PDQ = Pretty Darn Quick!) It's the most exciting Excel development in a generation... but you'd be forgiven for not knowing about it! Overview This one-hour …
What makes data clean? You may not be able to name those qualities, but you likely know messy data when you see it. In this blog post, we'll look at a frequent offender: unpivoted data. You'll learn …
Continue Reading about How to unpivot a dataset in Excel Power Query vs R vs Python →
A major reason I think it’s easier for Excel users to pick up R versus Python is that these tools tend to "think" more similarly than Python. See what I mean here: let's take a range of numbers and …
Continue Reading about Python was not designed for data analysis (and why that’s OK) →
Python has become in many ways the lingua franca of computing, with the open source language being used in everything from web development to artificial intelligence to... why, yes... data analytics. …
Continue Reading about Free checklist: 30 days to Python programmer →
