Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
A python dictionary is a data structure that can be used for numerous operations making it a prolific programming tool. It stores data in the form of key-value pairs i.e., each data can be labelled with a unique key. Keys in dictionaries are identifiers that are associated with different values, these values can be accessed, modified and deleted. Based on the task, keys can be sorted and extracted in different orders. In this article, we will be discussing a similar concept of extracting N largest dictionaries keys. We will operate on these unique keys and extract the relevant data. ... Read More
Pattern recognition is an important programming concept. It allows us to retrieve specific data that satisfies a particular condition or match a particular sequence. This principle is helpful in various fields including language and image processing. String matching helps us to extract meaningful information from a large collection of data. In this article, we will be discussing a similar concept of extracting mesh matching strings from a given list of strings. Mesh matching focuses on the extraction “similar” strings of equal length, let’s discuss this problem in detail. Understanding the Problem The main concept is to extract similar ... Read More
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