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: Integrate Python With Excel
Python Xlsxwriter Create Excel Part 2 (Formula, Link & Named Range)
Xlsxwriter is a powerful library that can recreate most of the features of Excel, including formula, link, and named range.[…]
Read moreUse Python Xlsxwriter To Create Excel Spreadsheet
In this tutorial, we’ll use Python to create a high-fidelity Excel spreadsheet. “High-fidelity” means that the Python-generated Excel spreadsheet will[…]
Read moreHow 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 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 moreHow to use Python lambda, map and filter functions
Python lambda function, aka anonymous function. Unlike how we create a function with def … statement, where we can name[…]
Read moreLooping with list comprehension
It’s hard to talk about Python without mentioning list comprehension, which is a looping technique in Python. The standard way[…]
Read moreCashflow projection in Python
Folks work in the finance industry deal with cashflow projection everyday, but mostly in Excel. Indeed, Excel is easy to[…]
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 more