Skip to content

Python In Office

Use Python to automate office tasks

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

Category: machine learning

Delete columns from a pandas dataframe

August 23, 2020 Jay Beginner, machine learning, Office Automation, Python

In this tutorial, we’ll learn how to drop/delete columns from a pandas dataframe. We are going to walk through three[…]

Read more

Delete rows from a dataframe

August 22, 2020 Jay Beginner, machine learning, Office Automation, Python

Deleting rows is a common task in Excel, in this tutorial, we’ll learn a few techniques to delete rows from[…]

Read more

How To Add A New Column in pandas DataFrame

August 21, 2020 Jay Beginner, machine learning, Office Automation, Python

In this tutorial, we’ll learn how to add a new column in pandas DataFrame. We are going to see a[…]

Read more

Insert rows into a dataframe (vs Excel table)

August 20, 2020 Jay Intermediate, machine learning, Office Automation, Python

One common task in Excel is to insert rows into a sheet. When working with data in Python, we can[…]

Read more

Get values, rows and columns in pandas dataframe

August 18, 2020 Jay Beginner, machine learning, Office Automation, Python

This article is part of the Transition from Excel to Python series. We have walked through the data i/o (reading[…]

Read more

Read multiple Excel files into Python

August 15, 2020 Jay Intermediate, machine learning, Office Automation, Python

We discussed how to read data from a single Excel file. Next we’ll learn how to read multiple Excel files[…]

Read more

Read multiple Excel sheets with Python pandas

August 14, 2020 Jay Intermediate, machine learning, Office Automation, Python

In the previous post, we touched on how to read an Excel file into Python. Here we’ll attempt to read[…]

Read more
use-excel-and-python-together

Integrate Python with Excel – from zero to hero

August 12, 2020 Jay Beginner, machine learning, Office Automation, Python

LAST UPDATED: Nov 08 2021 When I first started this blog, I had one idea in mind – to share[…]

Read more
large-elephant

How to open large csv or text files using Python

March 27, 2020 Jay Beginner, machine learning, Office Automation, Python

In this tutorial, we’ll learn how to open very large csv or text files using Python. My colleague once received[…]

Read more

Use Python to combine multiple Excel files into one master spreadsheet

March 26, 2020 Jay Beginner, machine learning, Office Automation, Python

In this short tutorial, I’ll show you how to use Python to combine multiple Excel files into one master spreadsheet.[…]

Read more

Posts navigation

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