Skip to content

Python In Office

Use Python to automate office tasks

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

Tag: Integrate Python With Excel

Python Xlsxwrite Create Excel Part 3 (Format, Sparkline & Chart)

September 30, 2021 Jay Intermediate, Office Automation, Python

Building upon our previous file, we’ll use Python xlsxwriter library to beautify our boring-looking Excel spreadsheet by adding formatting, sparkline,[…]

Read more

Python Xlsxwriter Create Excel Part 2 (Formula, Link & Named Range)

September 24, 2021 Jay Intermediate, Office Automation, Python

Xlsxwriter is a powerful library that can recreate most of the features of Excel, including formula, link, and named range.[…]

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 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

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 2 3 4 5 6 … 8 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