PowerQuery Guide to Pandas
Minimum price
Suggested price

PowerQuery Guide to Pandas

A Comparative Approach to Learn Pandas

About the Book

PowerQuery Guide to Pandas is designed to make readers familiar with the syntax and core concepts of Python language and the Pandas library by relating readers to familiar concepts in PowerQuery for Excel and PowerBI. With this book, I'll provide a comparative approach to learning Pandas and hopefully serve as good introduction to the Python language.

Learn the following concepts and topics in this book

* Data Types

* Input and Output

* Control Structures

* Structured Data Records

* Data Wrangling

* Dealing with Missing Data

* Grouping Data

* Combining Data

* ... and much more!

PowerQuery is great tool and should be part of every accountant's toolbox. However, Python is more mature and has wider reach in data analytics, processing, and automation. Level up your skills by learning Python and Pandas with the help of this book!

Today's business environment is becoming more and more data-driven. Stay relevant.

Buy this book and jump-start your Python journey!

NOTE! This book is written the Agile Way. That means the book is currently unfinished and in-progress. As I continue to complete the chapters, we will re-publish the book with the new and updated content. Readers will receive an email once a new version is published!

Send any questions, comments, or feedback about this book to my Linkedin or Twitter accounts. Thank you!

About the Author

Kenneth Infante
Kenneth Infante

Kenneth Infante is a Certified Public Accountant with expertise in data analysis and data visualization. He is also a Certified Microsoft Excel Expert and a self-taught Python programmer.

Kenneth is passionate with accounting-related technologies that enable accountant to turn data into insights and insights into business actions. He believes that Data Science is the future of accounting industry and hence every accountant should learn how to program.

In his spare time, he likes watching sci-fi movies, reading books, and learning new skills. And yes, he's your Geek Accountant.

Table of Contents

  • 1. Introduction
  • 2. About the Book
    • 2.1 Why did I write this book
    • 2.2 Who is the Target Audience
    • 2.3 Prerequisites
    • 2.4 Conventions in the Book
    • 2.5 Feedback
  • 3. The Basics
    • 3.1 Version
    • 3.2 Case Sensitivity
    • 3.3 Indentation
    • 3.5 Variables
    • 3.6 The Help System
    • 3.7 Coding Tools
  • 4. Input and Output
    • 4.1 Input
    • 4.2 Output
  • 5. Data Types
    • 5.1 Built-in Data Types
    • 5.2 Field Data Types
  • 6. Control Structures
    • 6.1 Conditional Statements
    • 6.2 Loops
  • 7. Error Handling
    • 7.1 If Statement
    • 7.2 Try Statement
  • 8. Functions
    • 8.1 Function Basics
    • 8.2 Optional Parameters & Default Values
    • 8.3 Return Multiple Values
    • 8.4 Type Hinting
  • 9. Classes
    • 9.1 Basics
  • 10. Strings
    • 10.1 Basics
    • 10.2 Transforming a String Field
    • 10.3 String Slicing
  • 11. Date and Time
    • 11.1 Basics
    • 11.2 Transforming a Datetime Field
    • 11.3 Date Formatting
  • 12. Structured Data Records
    • 12.2 List
    • 12.3 Records and Dictionaries
    • 12.4 Creating a Table/Dataframe from List, Records or Dictionaries
  • 13. Introduction to Data Wrangling
    • 13.2 Rename Columns
    • 13.3 Reorder Columns
    • 13.4 Sorting
    • 13.5 Unique Values
    • 13.6 Dealing with Duplicates
    • 13.7 Getting Info
  • 14. Adding Columns
    • 14.1 Duplicating a Column
    • 14.2 Extracting Values from a Column
    • 14.3 Conditional Column
    • 14.4 Index Column
    • 14.5 Thru a Formula
  • 15. Subsetting Data
    • 15.1 Selecting Columns and Rows
    • 15.2 loc and iloc (Pandas only)
    • 15.3 Removing Columns and Rows
  • 16. Dealing with Missing Data
    • 16.1 Fill Forward and Fill Backward
    • 16.2 Recode/Replace Values
    • 16.3 Dropping Missing Data
  • 17. Grouping Data
    • 17.1 Aggregate a Single Column
    • 17.2 Aggregate Multiple Columns
  • 18. Pivoting and Unpivoting Data
    • 18.1 Pivot
    • 18.2 Unpivot/Melt
  • 19. Combining Data
    • 19.1 Merge
    • 19.2 Append
  • 20. Conclusion

The Leanpub 60-day 100% Happiness Guarantee

Within 60 days of purchase you can get a 100% refund on any Leanpub purchase, in two clicks.

See full terms

80% Royalties. Earn $16 on a $20 book.

We pay 80% royalties. That's not a typo: you earn $16 on a $20 sale. If we sell 5000 non-refunded copies of your book or course for $20, you'll earn $80,000.

(Yes, some authors have already earned much more than that on Leanpub.)

In fact, authors have earnedover $12 millionwriting, publishing and selling on Leanpub.

Learn more about writing on Leanpub

Free Updates. DRM Free.

If you buy a Leanpub book, you get free updates for as long as the author updates the book! Many authors use Leanpub to publish their books in-progress, while they are writing them. All readers get free updates, regardless of when they bought the book or how much they paid (including free).

Most Leanpub books are available in PDF (for computers) and EPUB (for phones, tablets and Kindle). The formats that a book includes are shown at the top right corner of this page.

Finally, Leanpub books don't have any DRM copy-protection nonsense, so you can easily read them on any supported device.

Learn more about Leanpub's ebook formats and where to read them

Write and Publish on Leanpub

You can use Leanpub to easily write, publish and sell in-progress and completed ebooks and online courses!

Leanpub is a powerful platform for serious authors, combining a simple, elegant writing and publishing workflow with a store focused on selling in-progress ebooks.

Leanpub is a magical typewriter for authors: just write in plain text, and to publish your ebook, just click a button. (Or, if you are producing your ebook your own way, you can even upload your own PDF and/or EPUB files and then publish with one click!) It really is that easy.

Learn more about writing on Leanpub