Skip to content

Python In Office

Use Python to automate office tasks

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

Latest Posts

sumif countif python

SUMIF And COUNTIF In Pandas

February 12, 2022 Jay Intermediate, machine learning, Office Automation, Python

This tutorial will walk through how to perform the SUMIF and COUNTIF Excel functions using the Python pandas library. SUMIF[…]

Read more
combine excel sheets python

Combine Excel Sheets Using Python

February 9, 2022 Jay Intermediate, machine learning, Office Automation, Python

In this tutorial, we’ll combine sheets from different Excel files into a single workbook but still separate sheets using Python.[…]

Read more
excel pixel art python

Create Excel Pixel Art With Python

February 1, 2022 Jay Python

In this tutorial, I’ll show you how to create Excel pixel art with Python. With a little technical skill, you[…]

Read more
change column order

Change Column Order In Pandas DataFrame

January 31, 2022 Jay Python

In this tutorial, we’ll learn how to change column order in a pandas dataframe. Some might think that the order[…]

Read more

Extracting Bitcoin Blockchain Data With Python, RPC, Bitcoind, And Bitcoin Core

January 28, 2022 Jay Advanced, Database, Finance & Investing, Python

Wondering how to get Bitcoin blockchain data with Python, and Bitcoind/RPC? Look no further, you’ll find the answer here! It[…]

Read more

My Plan To Become A Data Scientist In 1 Year

January 24, 2022 Jay Career Development, Python

I want to share my plan to become a data scientist in 1 year. My definition of “becoming a data[…]

Read more

Automate Word Document (.docx) With Python-docx And pywin32

January 15, 2022 Jay Python

This tutorial will walk through how to automate Word documents using python-docx and sending emails with win32com libraries. Imagine that[…]

Read more
streamlit

248,306 Visitors In 2021 – A Streamlit Tutorial

January 9, 2022 Jay data visualization, Intermediate, Python

248,306 Python lovers from 214 countries visited this site in 2021 and let’s visualize the traffic data in this streamlit[…]

Read more
python dash

Python Dash Web App Tutorial

January 3, 2022 Jay data visualization, Intermediate, Python

In this tutorial, we’ll use Python Dash to create an interactive web application that will update graphs based on user[…]

Read more
Exploratory Data Analysis With Dtale

Exploratory Data Analysis with Python Dtale

December 16, 2021 Jay Advanced, data visualization, Python

In this tutorial, we’ll learn exploratory data analysis (EDA) with a Python library called dtale. I first came across this[…]

Read more

Posts pagination

«Previous Posts 1 … 9 10 11 12 13 … 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