Use Python Xlwings to Open Excel Files
This tutorial will walk through how to use Python xlwings to open Excel files. Xlwings is THE best python library[…]
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.
Python Set Sensitivity Label In Excel
This tutorial will show you how to use Python to set the Sensitivity Label in Excel. My company recently added[…]
Read moreHow To Use Python Visual Inside PowerBI
This tutorial will walk through how to use Python visual inside PowerBI. Microsoft’s PowerBI comes with roughly 30 “core” data[…]
Read moreFixing Selenium AttributeError: ‘WebDriver’ object has no attribute ‘find_element_by_xpath’
If you are trying to fix the Selenium AttributeError: ‘WebDriver’ object has no attribute ‘find_element_by_xpath’, then you are at the[…]
Read moreHow To Split An Excel File Into Multiple Files Using Python
I will show you how to split an Excel file into multiple files using Python in this short tutorial. Splitting[…]
Read moreHow To Generate Random Data In Python
This tutorial will show you how to generate random and unique data in Python easily and we will use a[…]
Read moreUse Pandas Pivot to Turn A DataFrame From Long to Wide Format
The pandas pivot() method can help turn a dataframe from a long to a wide format. We’ll demonstrate how to[…]
Read moreTurn Pandas DataFrame From Wide to Long Format
Sometimes we might need to turn a pandas dataframe from a wide format to a long format. This can be[…]
Read moreBinning Data With Pandas Between Method
Sometimes we need to perform data binning and the pandas method between() can help us achieve that goal. Data binning[…]
Read moreBinning Data With Pandas Cut Method
Sometimes we need to perform data binning and pandas provides a convenient method cut for exactly that purpose. Essentially we[…]
Read more