Skip to content

Python In Office

Use Python to automate office tasks

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

Tag: Excel

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 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

How To Truncate Dataframe In Pandas

April 21, 2022 Jay Intermediate, machine learning, Office Automation, Python

Sometimes we might want to truncate a dataframe to remove excessive data, we can do this by calling the truncate()[…]

Read more

Pandas – How To Calculate Difference Between Rows

April 20, 2022 Jay Intermediate, machine learning, Office Automation, Python

Sometimes we want to calculate the difference between rows in a pandas dataframe, instead of looping through the rows, we[…]

Read more

Create A Thinkorswim Trade Summary With Python

March 30, 2022 Jay Finance & Investing, Intermediate, Office Automation, Python

It’s tax season so I made a Python script to help create a trade summary for my thinkorswim (ToS) trading[…]

Read more

Use Python to Delete Excel Rows & Columns

March 18, 2022 Jay Intermediate, Office Automation, Python

This tutorial will show you how to use the Python openpyxl library to delete rows or columns from existing Excel[…]

Read more

Python openpyxl – Excel Formatting Cells

March 18, 2022 Jay Intermediate, Office Automation, Python

This tutorial will show you how to use the Python openpyxl library to customize Excel formatting such as cell color,[…]

Read more

Python & Excel – Number Format

March 17, 2022 Jay Intermediate, Office Automation, Python

This is a guide on Excel number format using the Python openpyxl library. The Excel program provides dozens of different[…]

Read more

Adjust Excel Fonts using Python openpyxl

March 17, 2022 Jay Intermediate, Office Automation, Python

This tutorial will show you how to adjust Excel fonts including size, color, bold, etc. using the Python openpyxl library.[…]

Read more

Python openpyxl – How to Insert Rows, Columns in Excel

March 17, 2022 Jay Intermediate, Office Automation, Python

This tutorial will show you how to use the Python openpyxl library to insert rows, columns and merge cells in[…]

Read more

Posts navigation

1 2 3 … 6 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