Skip to content

Python In Office

Use Python to automate office tasks

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

Tag: pandas

Faster Than Pandas

August 15, 2022 Jay Advanced, Python

Do you find the pandas library slow when handling large amounts of data and want to make your programs go[…]

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

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

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

Posts navigation

1 2 3 … 5 Next Posts»
Follow @jayzpio

Join our mailing list!

Recent Posts

  • I migrated my WordPress site from Bluehost to Linode
  • Stock Price Prediction with LSTM in Python
  • Building A Stable Diffusion Discord Bot
  • Python Closures
  • Building A Simple Python Discord Bot with DiscordPy in 2022/2023

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