Skip to content

Python In Office

Use Python to automate office tasks

  • Home
  • About
  • Beginner
  • Intermediate
  • Advanced
  • Resources
  • Privacy Policy

Category: 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.

Use Python Xlwings to Open Excel Files

October 26, 2022 Jay Office Automation, Python

This tutorial will walk through how to use Python xlwings to open Excel files. Xlwings is THE best python library[…]

Read more

Python Set Sensitivity Label In Excel

October 7, 2022 Jay Office Automation, Python

This tutorial will show you how to use Python to set the Sensitivity Label in Excel. My company recently added[…]

Read more

How To Use Python Visual Inside PowerBI

July 13, 2022 Jay data visualization, Intermediate, Office Automation, Python

This tutorial will walk through how to use Python visual inside PowerBI. Microsoft’s PowerBI comes with roughly 30 “core” data[…]

Read more

Fixing Selenium AttributeError: ‘WebDriver’ object has no attribute ‘find_element_by_xpath’

July 8, 2022 Jay Intermediate, Office Automation, Python

If you are trying to fix the Selenium AttributeError: ‘WebDriver’ object has no attribute ‘find_element_by_xpath’, then you are at the[…]

Read more

How To Split An Excel File Into Multiple Files Using Python

July 4, 2022 Jay Intermediate, machine learning, Office Automation, Python

I will show you how to split an Excel file into multiple files using Python in this short tutorial. Splitting[…]

Read more

How To Generate Random Data In Python

July 1, 2022 Jay Beginner, Database, machine learning, Office Automation, Python

This tutorial will show you how to generate random and unique data in Python easily and we will use a[…]

Read more

Use Pandas Pivot to Turn A DataFrame From Long to Wide Format

June 12, 2022 Jay Intermediate, machine learning, Office Automation, Python

The pandas pivot() method can help turn a dataframe from a long to a wide format. We’ll demonstrate how to[…]

Read more

Turn Pandas DataFrame From Wide to Long Format

June 12, 2022 Jay Intermediate, machine learning, Office Automation, Python

Sometimes we might need to turn a pandas dataframe from a wide format to a long format. This can be[…]

Read more

Binning Data With Pandas Between Method

May 26, 2022 Jay Intermediate, machine learning, Office Automation, Python

Sometimes we need to perform data binning and the pandas method between() can help us achieve that goal. Data binning[…]

Read more

Binning Data With Pandas Cut Method

May 25, 2022 Jay Intermediate, machine learning, Office Automation, Python

Sometimes we need to perform data binning and pandas provides a convenient method cut for exactly that purpose. Essentially we[…]

Read more

Posts navigation

1 2 3 … 7 Next Posts»
Follow @jayzpio

Join our mailing list!

Recent Posts

  • I migrated my WordPress site from Bluehost to Linode
  • Stock Price Prediction with LSTM in Python
  • Building A Stable Diffusion Discord Bot
  • Python Closures
  • Building A Simple Python Discord Bot with DiscordPy in 2022/2023

Categories

  • Advanced
  • Beginner
  • Bot automation
  • Career Development
  • Computer Vision
  • data visualization
  • Database
  • Finance & Investing
  • Intermediate
  • machine learning
  • Office Automation
  • Python
  • R Programming
  • Web Scraping
WordPress Theme: Poseidon by ThemeZee.
Go to mobile version