Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
Non-Linear SVM in Machine Learning
Introduction Support Vector Machine (SVM) is one of the most popular supervised Machine Learning algorithms for classification as well as regression. The SVM Algorithm strives to find a line of best fit between n−dimensional data to separate them into classes. a new data point can thus be classified into one of these classes. The SVM algorithm creates two hyperplanes while maximizing the margin between them. The points that lie on these hyperplanes are known as Support Vectors and hence the name Support Vector Machine. The below diagram shows the decision boundary and hyperplanes for an SVM that is used to ...
Read MoreEnsemble Classifier | Data Mining
Introduction Ensemble Classifiers are class models that combine the predictive power of several models to generate more powerful models than individual ones. A group of classifiers is learned and the final is selected using the voting mechanism. Data mining is the process of exploring and analyzing large datasets to find and explore important patterns, relationships, and information. The extracted information can then be used to solve business problems, predict trends and generate strategic plans by organizations. Ensemble classifiers are used in data mining to perform such tasks. Why do we need ensemble classifiers? Ensemble models(classifiers) can solve many problems and ...
Read MoreHow can I subtract a day from a Python date?
Introduction It is essential to have a module that can modify date and time since, as we all know, they are utilized in applications where we must keep track of date and time. A DateTime module in Python deals with dates and times (Python Date/Time Tutorial). Python comes with a built-in datetime module. Installation of two new libraries is necessary before any data modification may take place. Dates and timings are quickly retrieved using the arrow library. A DataFrame may be accessed and used thanks to the Pandas library. Go to an IDE console to install these libraries. ...
Read MoreHow to fix/convert trailing negative signs to real numbers in Excel?
In this article, the users understand “How to fix/convert the trailing negative signs to real number in excel.” The problem is that Excel does not understand negative values. Excel does not perceive some cells as a negative number if you are adding up some cells and it seems to disregard those cells. There are several possible causes for this, but the main one is that Excel misinterprets your reference to a number. For a variety of causes, Excel cells may contain trailing negative signs that need to be fixed. There some solution to fix/convert trailing negative signs are ...
Read MoreHow to find / Select minimum data / value in a range in Excel?
The term "data range" refers to a single cell, a row, a column, or a group of cells that include one or more continuous groups of cells. The range statement designates a set of data values. You can use a range expression in Excel to define the data range to extract. The given problem statement which can easily solve by using the minimum function. To search for the minimum value, open a excel worksheet where large voluminous of data in the cells are presented. Users would have to gather them all up one by one and retrieving the minimum ...
Read MoreHow to find Value with two or Multiple Criteria in Excel?
This article thoroughly describes the array formula and depicts the advanced filter to find the value with two or various constraints in excel. The criteria range for an Excel advanced filter is a collection of worksheet cells where the data filtering rules are entered. There must be a particular layout for the heading cells and criteria cells in the criteria range. The vertical and horizontal lookup functions in Microsoft Excel are special functions, but experienced users typically replace them with INDEX MATCH, which is in many respects superior to VLOOKUP and HLOOKUP. It can search up two or more ...
Read MoreHow To Combine Date And Time Columns Into One Column In Google Sheets?
Many professionals use Google Sheets to keep a record of time and date for HR and other purposes. While manually entering the values can take a lot of time, you can use the in-built features in Google Sheets to combine values in one cell. With this tutorial, we tell you how to combine date and time values in separate columns into just one with 2 very easy techniques. These methods provide flexibility and convenience, enabling you to merge date and time information into a single column quickly. Follow the steps to learn a new skill today! ...
Read MoreHow To Combine Multiple Cells Into A Cell With Space, Commas Or Other Separators In Excel?
In Microsoft Excel, combining the contents of multiple cells into a single cell with separators like spaces, commas, or other characters can be a valuable data manipulation and analysis technique. This helps the user to create concatenated strings that bring together information from different cells in a structured manner. In this tutorial, we will explore two methods—the CONCATENATE function and the ampersand (&) operator—to combine cells with various separators. Using a simple example, we demonstrate how to combine multiple cells into one cell with space, commas, and other separators. Method 1: Using the CONCATENATE Function The ...
Read MoreHow To Combine Multiple Columns Into One Single Column In Google Sheet?
A useful technique for organising and analysing data scattered in different columns is to combine them to just one column. Whether you want to merge related information or create a consolidated view, Google Sheets provides powerful tools to accomplish this task efficiently. In this tutorial we will explore two easy methods to combine multiple columns into one single column. Method 1: Using FILTER and LEN Formula You can use the combination of Google Sheets FILTER and LEN formula to return a filtered version of your data set with the specific condition of combining them in just one column. ...
Read MoreHow To Check Or Find If A Cell Contains A Specific String/Text/Word In Excel?
One of the key content inputs in Excel is strings. Strings refer to a sequence of characters or text like letters, numbers, symbols, and spaces. An Excel string can also represent a name, address, description, or any other textual information. Excel treats it as alphanumeric data rather than just numerical data, enabling it to perform manipulations and operations as the user requires. Looking for a particular text or word in Excel is very easy if you know how to use the right function and where. With the help of 2 examples, we demonstrate how to use the SEARCH and ...
Read More