Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Dictionaries in python are data structures that store data in the form of key-value pairs. Each key is unique and it is associated with different values. A dictionary helps us to access and retrieve data efficiently allowing a programmer to build an optimized code. Specific key-value pairs can be extracted from a given dictionary based on different requirements. This selective item extraction helps us to produce a dictionary consisting of relevant information. In this article, we will be discussing a similar concept of item extraction from a dictionary based on a reference “substring”. Understanding the Problem We ... Read More
If you work with data in Excel, you may often need to analyse trends and patterns within your data. One important metric to consider is the number of peaks, which refers to the maximum values in a set of data. Peaks can help you identify changes in trends, detect outliers, and make important decisions. Counting the number of peaks in a column of data can be a useful technique for analysing data. However, manually identifying peaks in a large set of data can be a time-consuming and error-prone task. Fortunately, Excel provides several tools that can help you quickly and ... Read More
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