Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Powerful spreadsheet software like Excel provides a variety of features to alter and analyse data. Finding the number of distinct values in a filtered column is a typical task that can be helpful when working with huge datasets. Excel data filtering enables you to focus on particular subsets of your data by only displaying rows that match specified criteria. The ordinary COUNT function, however, merely counts the visible cells, including any duplicates, when a column is filtered. We need to use a different strategy in order to precisely count the unique values in a filtered column. In this article, we'll ... Read More
Artificial Intelligence is at its peak nowadays, and it has ushered in a new era of possibilities in mobile app development, and iOS platforms are no exception. As we approach 2023, the integration of AI and ML is set to redefine the landscape of iOS app development. iOS application development companies work closely with organizations to create customized mobile applications. Collaboration of AI with App Development AI and Dev's technologies collaborate with businesses to understand their objectives, target audience, and unique challenges, ensuring that the resulting iOS applications align perfectly with the organization's goals. Based on reports, the Machine ... Read More
The menu is a crucial component of any website. It helps visitors find your quality material and directs them to the key portions of your website. Of course, CSS is the best language for creating stunning navigation menus. It is incredibly adaptable and can be used for any kind of website. It can be shown either horizontally or vertically before the primary content of the webpage or header. The task we are going to perform in this article is to design a vertical and horizontal menu using Pure CSS. That can be done by using the and tags. ... Read More
There are multiple ways to clear/empty an array in JavaScript. You need to use them based on the context. Let us look at each of them. Assume we have an array defined as − let arr = [1, 'test', {}, 123.43]; Substituting with a new array − arr = []; This is the fastest way. This will set arr to a new array. This is perfect if you don't have any references from other places to the original arr. If you do, those references won't be updated and those places will continue to use the old array. Setting length prop ... Read More
The Hashmap is the one kind of data structure that stores the key-value pairs of the different data. Like other programming languages, TypeScript also contains a built-in map data structure. In JavaScript, we can't define the key or value type that needs to be stored in the map. So, we need to create a map of the generic type. In TypeScript, we can define the type of the key and value to be stored in the map. Syntax Following is the syntax create the map in TypeScript − let hashMap = new Map(); Parameters key_Type − It is ... Read More
What is jQuery? jQuery is a fast and concise JavaScript library primarily designed with a nice motto − Write less, do more. The main purpose of this library is to make it easier to use JavaScript on our website. jQuery simplifies HTML document traversing, event handling, animating, and Ajax interactions for rapid web development. jQuery wraps many lines of JavaScript code into methods that we can call with a single line of code. How to link jQuery? There are two ways to link jQuery in an HTML page - By downloading the ... Read More
Here, we will create a c program to detect tokens in a C program. This is called the lexical analysis phase of the compiler. The lexical analyzer is the part of the compiler that detects the token of the program and sends it to the syntax analyzer.Token is the smallest entity of the code, it is either a keyword, identifier, constant, string literal, symbol.Examples of different types of tokens in C.ExampleKeywords: for, if, include, etc Identifier: variables, functions, etc separators: ‘, ’, ‘;’, etc operators: ‘-’, ‘=’, ‘++’, etcProgram to detect tokens in a C program−Example Live Demo#include #include ... Read More
We can change the color of the axis, ticks and labels, using ax.spines['left'].set_color('red') and ax.spines['top'].set_color('red') statements. To change the color of the axis, ticks, and labels for a plot in matplotlib, we can take the following steps −Create a new figure, or activate an existing figure, using plt.figure().Add an axis to the figure as part of a subplot arrangement, using plt.add_subplot(xyz) where x is nrows, y is ncols and z is the index. Here taking x = 1(rows), y = 2(columns) and z = 1(position).Set up X-axis and Y-axis labels using set_xlabel and set_ylabel method for creating ax using add_subplot().To ... Read More
In this program, we will see how to add two 8-bit numbers using 8085 microprocessor.Problem StatementWrite 8085 Assembly language program to add two 8-bit numbers and store the result at locations 8050H and 8051H.DiscussionTo perform this task, we are using the ADD operation of 8085 Microprocessor. When the result of the addition is the 1-byte result, then the carry flag will not be enabled. When the result is exceeding the 1-byte range, then the carry flag will be 1We are using two numbers at location 8000H and 8001H. When the numbers are 6CH and 24H, then the result will be ... Read More
You can find the minimum and maximum values of an array using for loops −ExampleLive Demopublic class MinAndMax { public int max(int [] array) { int max = 0; for(int i=0; imax) { max = array[i]; } } return max; } public int min(int [] array) { int min = array[0]; for(int i=0; i