Skip to content

Python In Office

Use Python to automate office tasks

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

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

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

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

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

How to create a pandas dataframe

September 2, 2020 Jay Beginner, machine learning, Python

We have seen many different ways to load data into Python using pandas, such as .read_csv() or .read_excel(). Those methods[…]

Read more

Posts pagination

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