In the following article, we will learn to perform different arithmetic operations by using openpyxl in Python for Data Science.
- SUM – It adds all the numbers which are in a range of cells.
OUTPUT:
- PRODUCT: It is used to multiply all the numbers in the range of cells.
OUTPUT:
- AVERAGE: It provides the arithmetic mean of all numbers that are present in the given cell range.
OUTPUT:
- QUOTIENT: This will give integer portion of a division.
OUTPUT:
- MOD: It will return the remainder after a number is divided by divisor.
OUTPUT:
- COUNT: It is there to count number of cells in a range that contains the number.
OUTPUT:
So, to learn more about excel operation in python for data science, you can check this and this as well.