Skip to content

Python In Office

Use Python to automate office tasks

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

Latest Posts

How to Filter Pandas Dataframe by Date

March 1, 2022 Jay Python

There are a few ways to filter a pandas dataframe by date. Some methods are easier while others are more[…]

Read more

How to Fix ValueError: [day,month,year] is missing

March 1, 2022 Jay Python

You might see this error message “ValueError: to assemble mappings requires at least that [year, month, day] be specified: [day,month,year][…]

Read more

How to Convert Column to Datetime in Pandas

March 1, 2022 Jay Python

There are two ways we can convert a column to datetime in pandas. Datetime is a data type that represents[…]

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

Python Remove Excel Protection

February 26, 2022 Jay Python

This short tutorial will show you how to protect & unprotect Excel sheets and workbooks using Python. By the end[…]

Read more
Read Encrypted Excel Pandas

Remove Password For Encrypted Excel Files Using Python

February 25, 2022 Jay Intermediate, Office Automation, Python

Password encrypted Excel files are annoying, in this tutorial I’ll show you how to use Python to remove Excel password.[…]

Read more
Read Encrypted Excel Pandas

Read Encrypted Excel File Using Pandas

February 25, 2022 Jay Python

If you are trying to use pandas to read a password encrypted Excel file, and got the following message: Then[…]

Read more

Pandas cheat sheet

February 24, 2022 Jay Python

This is a pandas cheat sheet that I recently created. Feel free to grab it. I’m still looking for a[…]

Read more

Predicting Bitcoin Price Using Stock To Flow Model & Linear Regression

February 22, 2022 Jay Python

In this article, I will walk through how I built a Bitcoin price prediction in Python using stock to flow[…]

Read more

Mail Merge Send Mass Email In Python

February 17, 2022 Jay Python

In this tutorial, we’ll learn how to use the Mail Merge, aka send mass email using Python. Mail Merge is[…]

Read more

Posts pagination

«Previous Posts 1 … 8 9 10 11 12 … 18 Next Posts»
Follow @jayzpio

Join our mailing list!

Recent Posts

  • How to Calculate Cosine Similarity in Python
  • How to Use LangChain and ChatGPT in Python – An Overview
  • Create A Mortgage Calculator using Python Pynecone and Plotly
  • Chatgpt in VScode
  • I migrated my WordPress site from Bluehost to Linode

Categories

  • Advanced
  • Beginner
  • Bot automation
  • Career Development
  • Computer Vision
  • data visualization
  • Database
  • Finance & Investing
  • Intermediate
  • machine learning
  • Office Automation
  • Python
  • R Programming
  • Web Development
  • Web Scraping
WordPress Theme: Poseidon by ThemeZee.
Go to mobile version