Excel to Python Guide

ABS

Find the absolute value of a number

AVERAGE

Calculate the mean value of a set of numbers

COUNT

Count number of cells that contain numbers

COUNTIF

Count the number of cells that match a condition or criteria

EXP

Calculate the e raised to the power of a given number

MAX

Find the maximum value in a set of numbers

MEDIAN

Calculate the median value of a set of numbers

MIN

Find the minimum value in a set of numbers

MODE

Calculate the mode value of a set of numbers

ROUND

Round a number to a specified number of decimals

SIGN

Determine whether numbers are positive, negative, or zero

SQRT

Compute the non-negative square root of a number

SUM

Calculates the sum of numbers

SUMIF

Sum the values of numeric cells that match a condition or criteria

CLEAN

Remove non-printable characters from text

CONCAT

Join text together

FIND

Find the position of a substring in a string

LEFT

Extract a specified number of characters from the start (left side) of a text string

LEN

Calculate the length of a string

LOWER

Converts a text string to lowercase.

MID

Extract a specific number of characters from the middle of a string

REPLACE

Replaces characters in a string by location.

RIGHT

Extract a specified number of characters from the end (the right) of text

TRIM

Remove unwanted whitespace or characters from text data

UPPER

Convert all characters in a string to uppercase

DAY

Extract the day from a datetime

HOUR

Extract the hour from a datetime

MINUTE

Extract the minute from a datetime

MONTH

Extract the month from a datetime

SECOND

Extract the second from a datetime

TODAY

Retrieve the current date without the time component

YEAR

Extract the year from a datetime

IF

Use a conditional check to return one of two values.

IFERROR

Returns a specified value if the formula evaluates to an error

ISNA

Detect if a value is missing

HLOOKUP

Search for a value in the first row and return a value in the same column from a specified row

INDEX MATCH

Lookup a value in a table based on a given criteria and return the corresponding value from another column

VLOOKUP

Search for a value in one column and return a corresponding value from a different column

PRICE

Calculate the present value or price of a security based on its coupon payments, yield, and other parameters

OFFSET

Shift the placement of data within a dataframe

RANK

Returns the rank of a number in a list of numbers.