## Replicate Excel VLOOKUP, HLOOKUP, XLOOKUP in Python (DAY 30!!)

Excel LOOKUP formulas are probably one of the most used formulas (at least for me). So today we’ll replicate the[…]

Read moreSkip to content# Category: machine learning

## Replicate Excel VLOOKUP, HLOOKUP, XLOOKUP in Python (DAY 30!!)

## Create complex calculated columns using applymap()

## Save Python plots into Excel file

## Find and replace Excel data using Python

## How to create a pandas dataframe

## Sort Excel data using Python

## Split text to columns in Python

## Create calculated columns in a dataframe

## Remove duplicates from a data table

## Filter a pandas dataframe – OR, AND, NOT

Use Python to automate office tasks

Excel LOOKUP formulas are probably one of the most used formulas (at least for me). So today we’ll replicate the[…]

Read moreWe previously talked about how to create calculated columns in pandas, and walked through some simple examples. We can create[…]

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

Read moreToday we’ll learn how to replicate a common Excel task – find and replace data in Python. This tutorial is[…]

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

Read moreSorting table is a common task in Excel. We sort a table in order to help us view or use[…]

Read moreHow many times have you had to split a text in Excel? I bet too many to count. Most Excel[…]

Read moreIn Excel, we can create a calculated column by first write a formula (in a cell), then drag down the[…]

Read moreIn Excel, we can “easily” remove duplicates from a table by clicking on the “Remove Duplicates” button from the Data[…]

Read moreThis is the second part of the Filter a pandas dataframe tutorial. Today we’ll be talking about advanced filter in[…]

Read more