johnwengler

You are quite possibly right but I can think of several reasons why total non-programmer might want to learn some basic coding. First, you learn the exact discipline and kind of thinking that improves what you ask AI to do. Second, if you are using AI to create logic in a corporation, you will need to defend the script when internal audit comes a-knocking. Finally, you will need to know a little code to debug or deal with edge cases. It's like Google can help you translate and survive a one-week visit to Paris but you really need to know some actual French if you moved there for a year.

Yes, actual programmers don't need this book. But their non-programming roommates or relatives might!

The word "tedious" totally jumped out at me! The vast majority of corporate desk jockeys (like myself) use Excel as part of a tedious daily workflow. Python is the perfect de-tedious-ification tool. And easy to learn to boot.

Titles are incredibly hard to get right... but the spirit is about automating what you do with Excel. To the absolute beginner, writing a Python script to ingest a spreadsheet into a dataframe, doing all the manual copy/paste blah blah blah, and the saving back out to an Excel file DOES qualify as automation!

Yeah... I wondered about the title "Automate Excel with Pandas" but Excel users would have no idea what I was talking about. Those who never leave the safe harbor of Microsoft will have heard distant rumblings about Python but not specific modules. Forgive me for sort of equating "Python" with "Pandas" but if it gets more folks using Python then I hope the ends justify the means.

Yup... I wrote this book for folks who love Excel but no programming experience.