Skip to content

Python In Office

Use Python to automate office tasks

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

Tag: Integrate Python With Excel

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

How to Run Excel VBA Macro From Python

March 26, 2022 Jay Office Automation

Sometimes we might want to run Excel VBA Macro from Python. This is useful when we want to run existing[…]

Read more

Use Pandas to Interpolate Missing Values

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

Sometimes we might want to interpolate and fill missing data as opposed to dropping them, and the pandas library offers[…]

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 pagination

«Previous Posts 1 2 3 4 … 8 Next Posts»
Follow @jayzpio

Join our mailing list!

Recent Posts

  • How to Calculate Cosine Similarity in Python
  • How to Use LangChain and ChatGPT in Python – An Overview
  • Create A Mortgage Calculator using Python Pynecone and Plotly
  • Chatgpt in VScode
  • I migrated my WordPress site from Bluehost to Linode

Categories

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