Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
VLOOKUP is a function in Microsoft Excel mostly used to search for a specific value in the first column of a table and then retrieve a corresponding value from a different column in the same row. The name "VLOOKUP" stands for "Vertical Lookup”. This simply means that the function looks up a value vertically within a table. This article will use user defined VLOOK formula, to determine the age group for provided age data. The article briefs all the steps accurately and precisely. Grouping data in Excel allows for improving the organization of data and makes data easier to ... Read More
In this article, learners will understand the process of grouping the adjacent columns in Excel, and its associated benefits. The first and most important benefit of grouping data is that it improves the organization and makes it easier to read and analyze. Users can quickly collapse or expand the group to view the data according to the use and requirement, this will save time and make the spreadsheet professional and more efficient. Another major factor is that it makes the data manipulation easy. This means that modification and alteration of data become easy. For example, if the user wants ... Read More
Excel is a popular spreadsheet software that allows users to develop, organize and analyze data, by using different available options such as tables, charts, and graphs. The most common benefit of using the chart is that it allows the user to analyze data easily, compare data becomes easy, and make conclusions fast and easy to understand by all. Nowadays, many interactive ways are available in Excel to make a presentable chart within a few seconds. In this article, grouping axis labels in a chart by using Excel, can be done by using two examples. The first example uses a chart, ... Read More
Introduction to Industrial Waste Due to urbanization and rapid advancements in the industrialization, it has led to an increase in the production and consumption processes resulting in the generation of wastes. These waste are the unwanted and unusable matter that is discarded after its use for main purpose. Over the years, the waste gets accumulated and causes a lot of impact on the environment and health of an individual. Treatment of waste and its management is generally intended to reduce the effect of waste for mankind. Based on the physical state of material wastes are mainly classified into different types ... Read More
An Excel spreadsheet is a combination of rows and columns. Rows are the horizontal lines, on the other hand, groups are the vertical column of the worksheet. This article contains two examples. The first example is based on the use of a name box, and the second example is based on the use of a go-to dialog box. Both examples will guide the user about the process to move to any required cell and location. This example will make the provided cell location active for user editing. Users can write and use the cell according to their requirements. Example 1: ... Read More
Moving to the previous and last sheet is required when the user wants to search for any data or is willing to understand the data written on the previous and last sheet. Reconciling data from all sheets is good as it allows the user to use the whole data to generate the result. This will make data consistent and accurate. In this article, two examples are provided for the user. The first example is based on the use of VBA code, while the second example is based on the use of Kutool. Using kutool is more efficient and consumes less ... Read More
What are Biofuels? Biofuels are the fuels that are produced from organic material like biomass either directly or indirectly. Biomass used here is mostly the plants material and animal waste. Use of biofuels has been in existence even before the use of petroleum oils. USA is known to be the leading manufacturer of the biofuels. Generations of Biofuels Biofuels are currently categorized into 4 different generations. First Generation Biofuels These are the most conventional type of biofuels. It has been in use before approximately 400 years. These fuels are usually made from the derivatives of food crops like sugar cane, ... Read More
Introduction to Biochemistry and its Importance Biochemistry which is also called as biological chemistry is a branch of science which deals with the study of chemical processes within and around the living organisms. It can also be defined as a branch of biological science that deals with the study of biochemical reactions by involving biomolecules like nucleic acids, proteins, lipids and carbohydrates. It is also known to be the hybrid branch of organic chemistry that specializes in chemical processes and chemical transformation inside a living cell. A chemical process is the one in which the reactants react to form a ... Read More
For using arrays in Python, NumPy is commonly used. Sometimes, the data is stored in a multidimensional or 3D array. If loadtxt() or savetxt() functions are used to save or load the array data, it will require a 2d array. If the 3D array is used, then it will give this error – “ValueError: Expected 1D or 2D array, got 3D array instead”. So, in this Python and Numpy article, using two different examples, code is written to show the process of saving arrays and loading arrays while using savetxt() and loadtxt() functions and working with 3D arrays. In the ... Read More
In this article, the user will understand how to lowercase the column names in Pandas dataframe. Using three different examples, the ways are given for converting the dataframe columns in lowercase. For these examples, a Zomato dataset given on Kaggle is used. The kaggle dataset was available in CSV (Comma Separated Values) format so it was first downloaded and then it was converted into a dataframe by using pandas. In the first example, the python program uses a str.lower() function for the lowercase conversion of the column vales. In the second example, the map(str.lower) function is used for converting the ... Read More