Skip to content

Python In Office

Use Python to automate office tasks

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

Category: Beginner

How to Make a WordCloud in Python

June 1, 2022 Jay Beginner, data visualization, machine learning, Python

This tutorial will show you how to make a wordcloud in Python. Wordcloud is a type of visualization for text[…]

Read more

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

How to Access Excel File In Python

March 9, 2022 Jay Beginner, Office Automation, Python

Sometimes we want to access just certain data in an Excel file in Python instead of reading the whole spreadsheet/table[…]

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

Send Gmail Notification Using Python

October 19, 2021 Jay Beginner, Bot automation, Python

We will create a Python program to automatically send ourselves an email/Gmail notification when our Amazon price notification bot finds[…]

Read more

Python Data Visualization & Exploration With Plotly

October 4, 2021 Jay Beginner, data visualization, Python

We’ll talk about data visualization & exploration with a Python library called plotly. There are many plotting libraries within the[…]

Read more

Use Python Xlsxwriter To Create Excel Spreadsheet

September 20, 2021 Jay Beginner, Office Automation, Python

In this tutorial, we’ll use Python to create a high-fidelity Excel spreadsheet. “High-fidelity” means that the Python-generated Excel spreadsheet will[…]

Read more

How to find similar strings using Python

November 22, 2020 Jay Beginner, Python

When we deal with data from different sources, we often encounter one problem – some strings could be spelled differently,[…]

Read more

Plot graphs in Python

September 4, 2020 Jay Beginner, data visualization, Python

Excel makes plotting a graph very easy. So does Python! Today we’ll take a quick look at how to plot[…]

Read more

Find and replace Excel data using Python

September 3, 2020 Jay Beginner, machine learning, Office Automation, Python

Today we’ll learn how to replicate a common Excel task – find and replace data in Python. This tutorial is[…]

Read more

Posts navigation

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