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 moreTag: Excel
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