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 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
Sometimes, the task is to analyze a dataset and use the data from a TSV (Tab Separated Values) file. For this, the TSV file is sometimes converted to a dataframe. A dataframe is a labeled two-dimensional structure that has different types of columns. In this article, using two different examples, this Python library called pandas is used with Python code to read a TSV file and load it into a dataframe. 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 ... Read More
Introduction Immunology is basically the study of immune system of an organism which protects the organism from physical, chemical and biological invasions. Immunity: Immunity is our body’s protective mechanism against pathogens which includes the disease inducing micro-organisms like bacteria, virus, fungi, protozoa etc. We do need immunity as our body constantly attacked by several pathogens in a day to day life. How Does Our Immune System Works? Immune system includes a complex set of tissues, cells and specialized molecules which protects our body from any foreign particles like microorganisms that enter our body. For effective functioning of our ... Read More