Pandas Brain Teasers: Exercise Your Mind

This book contains 25 short programs that will challenge your understanding of Pandas. Like any big project, the Pandas developers had to make some design decisions that at times seem surprising. This book uses those quirks as a teaching opportunity. By understanding the gaps in your knowledge, you'll become better at what you do. Some of the teasers are from the author's experience shipping bugs to production, and some from others doing the same. Teasers and puzzles are fun, and learning how to solve them can teach you to avoid programming mistakes and maybe even impress your colleagues and future employers.

Working with data is central to nearly everything we do, from disease contact tracing and analyzing health records to smart meters that track utility consumption behavior. With the power of Python's pandas library, you can process and analyze this data in a highly efficient and simple-to-understand way. And with 25 brain teasers designed to turn this technology's quirks into a teaching opportunity, you'll be honing your data science skills while having fun at the same time.

Following a simple format, you'll challenge yourself and your understanding of pandas. Read a short Python program that uses pandas, try to guess the output, run the code yourself, and then go to the next page for an explanation of the solution. From common pitfalls and hidden gotchas to unexpected twists and turns, you'll deepen your understanding of pandas, learn to write more efficient code, and reduce the number of bugs in the software you develop. You may even impress your colleagues and your employers, both present and future.

Learn the tricks of the trade with Python's pandas, in one of the most fun and creative ways around.

What You Need:

To run the code you'll need Python version 3.8 or upper and Pandas version 1.0 or upper installed.

We use Python version 3.8.3 and Pandas version 1.0.5; the output might change in future versions.

本書包含25個短程式，挑戰你對Pandas的理解。就像任何大型專案一樣，Pandas的開發人員必須做出一些設計決策，有時看起來令人驚訝。本書將利用這些特點作為教學機會。通過了解你知識的不足之處，你將變得更加優秀。其中一些問題是作者在將錯誤送到生產環境中的經驗，還有一些是其他人的經驗。問題和謎題很有趣，學習如何解決它們可以教你避免編程錯誤，甚至可能給同事和未來的雇主留下深刻印象。

從疾病接觸追踪和分析健康記錄到追踪公用事業消耗行為的智能電表，與數據一起工作幾乎是我們所做的一切。借助Python的pandas庫的強大功能，您可以以高效且易於理解的方式處理和分析這些數據。通過25個腦筋急轉彎的問題，將這項技術的特點轉化為教學機會，您將在玩樂的同時磨練您的數據科學技能。

按照簡單的格式，您將挑戰自己對pandas的理解。閱讀一個使用pandas的短小Python程式，試著猜測輸出結果，運行程式碼，然後翻到下一頁以獲得解決方案的解釋。從常見的陷阱和隱藏的問題到意想不到的曲折，您將加深對pandas的理解，學會撰寫更高效的程式碼，並減少您開發的軟體中的錯誤數量。您甚至可能給現在和未來的同事和雇主留下深刻印象。

以最有趣和創造性的方式之一，學習Python的pandas的訣竅。

所需材料：

要運行程式碼，您需要安裝Python 3.8或更高版本以及Pandas 1.0或更高版本。

我們使用的是Python 3.8.3和Pandas 1.0.5版本；輸出可能會在未來版本中有所變化。

Miki has a passion for teaching and mentoring. He teaches many workshops on various technical subjects all over the world and also mentored many young developers on their way to success. Miki is involved in open source, has several projects of his own, and contributed to several more - including the Python project. He has been using Python for close to 25 years and Pandas for about 10.

Miki熱衷於教學和指導。他在世界各地教授許多關於不同技術主題的工作坊，並且也指導許多年輕開發者走向成功。Miki參與了開源項目，擁有自己的幾個項目，並且也對其他項目做出了貢獻，包括Python項目。他使用Python已經接近25年，Pandas使用了大約10年。