Plot graphs in Python
Excel makes plotting a graph very easy. So does Python! Today we’ll take a quick look at how to plot[…]
Read moreTag: Integrate Python With Excel
Find and replace Excel data using Python
Today we’ll learn how to replicate a common Excel task – find and replace data in Python. This tutorial is[…]
Read moreHow to create a pandas dataframe
We have seen many different ways to load data into Python using pandas, such as .read_csv() or .read_excel(). Those methods[…]
Read moreSort 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 moreReplicate 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 more