Skip to content

Python In Office

Use Python to automate office tasks

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

Latest Posts

Freeze Your Python Code – How to Run Python Script Without Python Installed

April 3, 2021 Jay Intermediate, Python

Do you know that you can “freeze” your python code and give other people run it even if they don’t[…]

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

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

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

How to use Python lambda, map and filter functions

September 8, 2020 Jay Advanced, Python

Python lambda function, aka anonymous function. Unlike how we create a function with def … statement, where we can name[…]

Read more

Looping with list comprehension

September 7, 2020 Jay Advanced, Python

It’s hard to talk about Python without mentioning list comprehension, which is a looping technique in Python. The standard way[…]

Read more

Cashflow projection in Python

September 6, 2020 Jay Finance & Investing, Intermediate, Python

Folks work in the finance industry deal with cashflow projection everyday, but mostly in Excel. Indeed, Excel is easy to[…]

Read more

Save Python plots into Excel file

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

We briefly talked about how to create a graph in Python using web data, but it’s not so useful if[…]

Read more

Posts pagination

«Previous Posts 1 … 12 13 14 15 16 … 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