Skip to content

Python In Office

Use Python to automate office tasks

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

Latest Posts

How To Find The Closest Value To An Input In Pandas

May 8, 2022 Jay Python

This tutorial will show you how to find the closest value to a given input in pandas. Sometimes we try[…]

Read more

Calculate Option Implied Volatility In Python

April 30, 2022 Jay Finance & Investing, Python

This tutorial covers two methods on how to calculate option implied volatility using Python: brute force and Newton Raphson Method.[…]

Read more

Calculate Black Scholes Option Price In Python

April 24, 2022 Jay Python

This tutorial will walk through how to calculate the Black Scholes Merton (BSM) model option price in Python. We are[…]

Read more

How To Round Values In Pandas

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

In this tutorial we’ll cover how to round values up, down, to the nearest numbers in pandas. Let’s use the[…]

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

How To Shift A Column In Pandas DataFrame

April 19, 2022 Jay Python

Sometimes we need to shift a column inside a pandas dataframe, the shift() method provides a convenient way to achieve[…]

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

How to Create the Bar Chart Race Plot in Python

March 24, 2022 Jay data visualization, Python

This tutorial will teach you how to create a bar chart race using the Python matplotlib library, which is an[…]

Read more

Posts pagination

«Previous Posts 1 … 4 5 6 7 8 … 18 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