Skip to content

Python In Office

Use Python to automate office tasks

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

Category: Intermediate

How to Make Streamlit Multiple Callback

June 4, 2022 Jay data visualization, Intermediate, Python

This tutorial will walk through how to create multiple callback with streamlit, which is a library that makes awesome web-based[…]

Read more

How to Use Streamlit Session State

June 4, 2022 Jay data visualization, Intermediate, machine learning, Python

This tutorial will introduce you to the streamlit session state. Streamlit is super powerful and easy to use for creating[…]

Read more

Create A Stock Market Heat Map Using Python

May 30, 2022 Jay data visualization, Finance & Investing, Intermediate, Python

In this tutorial we’ll go through step by step how to create a stock market heat map using the Python[…]

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

How To Make Waterfall Chart In Python Matplotlib

May 19, 2022 Jay data visualization, Intermediate, Python

We are going to make a waterfall chart in Python, specifically using the matplotlib library. A waterfall chart shows the[…]

Read more

Pandas idxmax method – How To Get First Row In Dataframe Based On Criteria (With Examples)

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

The pandas idxmax() method can make some operations really simple. For example, getting the first row in a dataframe based[…]

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

Posts pagination

«Previous Posts 1 2 3 4 … 7 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