Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Excel is a powerful tool that is widely used for data analysis and management. One of the common tasks in data analysis is to count the number of occurrences within a specific date range. This can be particularly useful when analysing time-series data or tracking the frequency of events over time. In Excel, there are various functions and tools available that can help you easily count the number of occurrences within a given date range. In this tutorial, we will explore how to use some of these functions and tools to count the number of occurrences within a datetime range ... Read More
The task is to build an application which displays an expression and prompts for the answer. Once you enter the solution a new expression is displayed and these expressions keep on changing. After a certain amout of time the solution given for the respective application were evaluated and the total number of accurate answers were displayed. Methods (User defined) in the Game The section will walk you through the methods (and constructor) that are part of the implementation and their roles in the “Calculate Expression Game”. CalculateExpressionGame() This is the constructor of the calculateExpressionGame class. It sets up the ... Read More
Excel is a powerful tool for managing and analyzing data, and it's used by millions of people around the world. One of the most common tasks in Excel is to count the number of lines or line breaks in a cell. This is useful when you're working with text that spans multiple lines, such as addresses or multi-paragraph descriptions. In this tutorial, we will guide you step-by-step on how to count the number of lines in a cell in Excel using different methods. Whether you're a beginner or an advanced user, you'll learn how to use Excel's built-in functions and ... Read More
Excel is a powerful tool for managing and analyzing data, and being able to count the number of "Yes" or "No" responses in a dataset is a common requirement for many users. Whether you're working with survey results, feedback forms, or any other type of data that includes "Yes" or "No" responses, this tutorial will show you how to quickly and easily count the number of each type of response in Excel. We'll walk you through step-by-step instructions and provide examples along the way, so you can follow along and master this useful Excel function. So, let's get started! Count ... Read More
Custom values are specific values that are defined and selected under certain criteria. In a large and complex dataset, specification is very important for constructing an optimized program and therefore extraction of relevant data becomes very important. We can pass a reference list according to which the values can be extracted. This reference list has its own implications as it stores concise information. In this article we will be discussing a similar concept of extracting dictionary items (both keys and values) for a custom data passed through a list. Understanding the Problem We will create a dictionary consisting ... Read More
Value extraction is a very popular programming concept and it is used in a wide variety of operations. However extracting values from a JSON response is a different concept all together. It helps us to build logic and target specific values in a complex dataset. This article will explain the various methods that can be used to extract a single value from a JSON response. Before we start with value extraction, let’s focus on understanding the meaning of a JSON response. What is a JSON Response? A JSON (JavaScript Object Notation) response is a widely accepted data format through ... Read More
Python consists of numerous built-in functions that are designed to perform a wide range of operations including string manipulation, array analysis, algebraic reasoning etc. Strings in python is a data type in which characters are arranged in a sequence. These characters are indexed to acquire specific position in a sequence, we can initiate basic string operations with the help of these index values. This article will elaborate on a similar string-based operation where we will modify an input string to equalize the character frequency. Understanding the Problem Our task is to modify a string in a manner that each ... Read More
When it comes to searching for elements in a collection, Java provides different options depending on the data structure you're using. Two popular methods for searching in a list are binary search and the contains() method. In this blog post, we'll compare the performance of binary search and contains in a Java list, highlighting their differences, strengths, and best use cases. Binary Search Binary search is an efficient way for locating a specific member in a sorted list. The search space is divided in half on a regular basis until the target element is found or the search space is ... Read More
Graphical representation of the data provides an enhanced understanding of the complex sub structures of the data and it helps us to easily interpret the hidden patterns and trends. Imagine how convenient it would be if we could just draw a similar relationship programmatically? Python offers a prolific module that is precisely designed to perform such operation and it is known as “turtle”. The “turtle” module is a built-in python library that allows us to draw graphics on a “turtle graphics screen”. In this article, we will create a bar chart using this turtle module. Understanding the Turtle ... Read More
A dictionary is a unique form of array that is used to implement data structures in python. There are several characteristics associated with a dictionary that makes it a very powerful tool in Python. It stores data in the form of key-value pair where each key is a unique identifier and is used to access the corresponding value associated with it. We can perform several operations on this dictionary and manipulate the data stored in it. This article will explain one such operation where we will divide a dictionary and its key into K equal dictionaries. Understanding the ... Read More