Skip to content

Python In Office

Use Python to automate office tasks

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

Category: machine learning

How to Do Train Test Split in Sklearn

March 19, 2022 Jay Beginner, machine learning, Python

A common task in machine learning is to split the train and test datasets, we’ll take a look at how[…]

Read more
python concatenate excel files

Use Python To Concatenate Excel Files

February 28, 2022 Jay Intermediate, machine learning, Office Automation, Python

In this tutorial, we’ll learn how to use Python to concatenate/append/merge/combine multiple Excel files. Programming languages keep evolving, and Python/pandas[…]

Read more
sumif countif python

SUMIF And COUNTIF In Pandas

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

This tutorial will walk through how to perform the SUMIF and COUNTIF Excel functions using the Python pandas library. SUMIF[…]

Read more
combine excel sheets python

Combine Excel Sheets Using Python

February 9, 2022 Jay Intermediate, machine learning, Office Automation, Python

In this tutorial, we’ll combine sheets from different Excel files into a single workbook but still separate sheets using Python.[…]

Read more
floppy-disk

How to merge multiple Excel files in Python

November 29, 2021 Jay Beginner, machine learning, Office Automation, Python

In this tutorial, we’ll learn how to merge multiple Excel files in Python. The “merge” operation refers to combining files[…]

Read more

How To Connect And Work With SQLite Database Using Python sqlite3

September 4, 2021 Jay Database, Intermediate, machine learning, Office Automation, Python

Today we’ll talk about how to connect and work with the SQLite database using Python. In case you have never[…]

Read more

How To Use Pandas Groupby To Summarize Data

March 28, 2021 Jay Intermediate, machine learning, Python

In Python, the pandas groupby() function provides a convenient way to summarize data in any way we want. The function[…]

Read more

Use fuzzy string matching in pandas

February 8, 2021 Jay Intermediate, machine learning, Python

If your job requires working with large amount of data in Excel, and needing to match up certain records from[…]

Read more

Replicate Excel VLOOKUP, HLOOKUP, XLOOKUP in Python (DAY 30!!)

September 10, 2020 Jay Intermediate, machine learning, Office Automation, Python

Excel LOOKUP formulas are probably one of the most used formulas (at least for me). So today we’ll replicate the[…]

Read more

Create complex calculated columns using applymap()

September 9, 2020 Jay Intermediate, machine learning, Python

We previously talked about how to create calculated columns in pandas, and walked through some simple examples. We can create[…]

Read more

Posts navigation

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