Python In Office

SUMIF And COUNTIF In Pandas

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

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

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

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

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

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

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

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

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

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