Sum remains one of the most used function in Excel. Many a time there is a need to do summation with multiple criteria’s. In case there are more than one condition requiring check for summation, SUMIFS is the go to
Author:
CSV files are most popular format of dataset. Most of the companies in various industries prefer CSV for storing datasets. It can be a dataset of millions of rows or limited set of rows. To start working on datafiles in
To count number of cells in excel is easy with COUNT function. When there is a need to count cells with predefined condition, then we use another function. COUNTIF function in Excel is used to count cells with pre defined
There are multiple modules available for python. Most of the modules are open source. These modules provide great features to use. Before using any module its necessary to install them on python. This article covers How to install Python module,