Sort Excel data using Python
Sorting table is a common task in Excel. We sort a table in order to help us view or use[…]
Read moreCategory: Office Automation
We provide a series of tutorials on how to automate office tasks such as data manipulation in Excel, sending Outlook emails, or creating Word documents.
Replicate Excel Goal Seek in Python
Excel provides an excellent feature – Goal Seek, which allows back-solving an input value when given the end result. It[…]
Read moreSplit text to columns in Python
How many times have you had to split a text in Excel? I bet too many to count. Most Excel[…]
Read moreCreate calculated columns in a dataframe
In Excel, we can create a calculated column by first write a formula (in a cell), then drag down the[…]
Read moreRemove duplicates from a data table
In Excel, we can “easily” remove duplicates from a table by clicking on the “Remove Duplicates” button from the Data[…]
Read moreFilter a pandas dataframe – OR, AND, NOT
This is the second part of the Filter a pandas dataframe tutorial. Today we’ll be talking about advanced filter in[…]
Read moreFilter a pandas dataframe (think Excel filters but more powerful)
Being able to slice and dice the data is essential for working with data. Similar to the filter in Excel,[…]
Read moreRename pandas dataframe columns
There are many reasons to rename pandas dataframe columns. For example, maybe you want the column names to be more[…]
Read moreDelete columns from a pandas dataframe
In this tutorial, we’ll learn how to drop/delete columns from a pandas dataframe. We are going to walk through three[…]
Read moreDelete rows from a dataframe
Deleting rows is a common task in Excel, in this tutorial, we’ll learn a few techniques to delete rows from[…]
Read more