Pandas idxmax method – How To Get First Row In Dataframe Based On Criteria (With Examples)
The pandas idxmax() method can make some operations really simple. For example, getting the first row in a dataframe based[…]
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.
How To Round Values In Pandas
In this tutorial we’ll cover how to round values up, down, to the nearest numbers in pandas. Let’s use the[…]
Read moreHow To Truncate Dataframe In Pandas
Sometimes we might want to truncate a dataframe to remove excessive data, we can do this by calling the truncate()[…]
Read morePandas – How To Calculate Difference Between Rows
Sometimes we want to calculate the difference between rows in a pandas dataframe, instead of looping through the rows, we[…]
Read moreCreate A Thinkorswim Trade Summary With Python
It’s tax season so I made a Python script to help create a trade summary for my thinkorswim (ToS) trading[…]
Read moreHow to Run Excel VBA Macro From Python
Sometimes we might want to run Excel VBA Macro from Python. This is useful when we want to run existing[…]
Read moreUse Pandas to Interpolate Missing Values
Sometimes we might want to interpolate and fill missing data as opposed to dropping them, and the pandas library offers[…]
Read moreUse Python to Delete Excel Rows & Columns
This tutorial will show you how to use the Python openpyxl library to delete rows or columns from existing Excel[…]
Read morePython openpyxl – Excel Formatting Cells
This tutorial will show you how to use the Python openpyxl library to customize Excel formatting such as cell color,[…]
Read morePython & Excel – Number Format
This is a guide on Excel number format using the Python openpyxl library. The Excel program provides dozens of different[…]
Read more