Skip to content

Python In Office

Use Python to automate office tasks

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

Category: Python

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

How to Create Animation with Matplotlib

March 23, 2022 Jay data visualization, Intermediate, Python

Matplotlib is a powerful Python charting library, but many people probably don’t know it can create animation plots. What Is[…]

Read more

Python Pip Install From Github

March 22, 2022 Jay Intermediate, Python

Python users are familiar with pip install, but do you know that we can actually install a library found on[…]

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

Scatter Matrix With Plotly

March 20, 2022 Jay data visualization, Intermediate, machine learning, Python

Did you know that the plotly Python library can create a scatter matrix plot as well? A scatter matrix, or[…]

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