Python Xlsxwrite Create Excel Part 3 (Format, Sparkline & Chart)
Building upon our previous file, we’ll use Python xlsxwriter library to beautify our boring-looking Excel spreadsheet by adding formatting, sparkline,[…]
Read moreTag: pandas
How To Use Pandas Groupby To Summarize Data
In Python, the pandas groupby() function provides a convenient way to summarize data in any way we want. The function[…]
Read moreUse fuzzy string matching in pandas
If your job requires working with large amount of data in Excel, and needing to match up certain records from[…]
Read moreReplicate Excel VLOOKUP, HLOOKUP, XLOOKUP in Python (DAY 30!!)
Excel LOOKUP formulas are probably one of the most used formulas (at least for me). So today we’ll replicate the[…]
Read moreCreate complex calculated columns using applymap()
We previously talked about how to create calculated columns in pandas, and walked through some simple examples. We can create[…]
Read moreSave Python plots into Excel file
We briefly talked about how to create a graph in Python using web data, but it’s not so useful if[…]
Read morePlot 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 moreFind 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 more