Jupyter Notebook is one of the most popular IDE. It has some great features. Python learners generally prefer Jupyter IDE over others. As Jupyter Notebook can directly open in desktop browers, it becomes very easy to operate through. Chrome which
Pyspark is becoming popular among Data Scientists. For doing data processing for large datasets, running machine learning algorithms etc. Pyspark has many use cases. Of course, for any Pyspark learning enthusiast having the coding language installed in local laptop becomes
For doing data analysis, group by remains one of the key process to follow. Data preparation and exploration stage requires multiple level of aggregation. This article covers how to Group By data in Python. Aggregation can be a done at
Anyone working on Excel would have used Count many times. COUNTIF function is popular to do single criteria based counting. In case the requirement is counting of cells with multiple condition checks, then COUNTIFS is the go to function. COUNTIFS
Data storing can take place in many format in Microsoft Excel. One of the well known format is XLS or XLSX format, popularly know as Excel format. It is easier to import CSV file in python as discussed in the
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
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,
Calculating sum remains an important requirement in analysis in excel. Although doing simple sum is easy, many a times user need summation with criteria’s. For example sum is required for certain categories, sum is required at specific group level. This