Skip to content

Python In Office

Use Python to automate office tasks

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

Tag: Data Manipulation

Python F-String Formatting

July 21, 2022 Jay Beginner, Python

This tutorial will discuss using the Python f-string formatting, also called “formatted string literals.” F-string is a great and easy[…]

Read more

How To Split An Excel File Into Multiple Files Using Python

July 4, 2022 Jay Intermediate, machine learning, Office Automation, Python

I will show you how to split an Excel file into multiple files using Python in this short tutorial. Splitting[…]

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

Use Pandas Pivot to Turn A DataFrame From Long to Wide Format

June 12, 2022 Jay Intermediate, machine learning, Office Automation, Python

The pandas pivot() method can help turn a dataframe from a long to a wide format. We’ll demonstrate how to[…]

Read more

Turn Pandas DataFrame From Wide to Long Format

June 12, 2022 Jay Intermediate, machine learning, Office Automation, Python

Sometimes we might need to turn a pandas dataframe from a wide format to a long format. This can be[…]

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

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

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

Posts navigation

1 2 3 … 5 Next Posts»
Follow @jayzpio

Join our mailing list!

Recent Posts

  • Chatgpt in VScode
  • I migrated my WordPress site from Bluehost to Linode
  • Stock Price Prediction with LSTM in Python
  • Building A Stable Diffusion Discord Bot
  • Python Closures

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