Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Worksheets without any blank rows mean an Excel sheet that does not contains any blank row. But while mapping any data to reality the same thing is not possible. So, it is better to remove the blank rows from Excel before printing the worksheets. The same task can be done in two ways, first method is to remove the blank rows, from the Excel sheet by using the VBA code, while the second method describes the process of using kutools to perform the same task. This article provides two general examples, to demonstrate the process of achieving the same task, ... Read More
In Microsoft Excel, a formula can be defined as an expression that performs calculations, manipulates data, or returns a specific value based on the inputs provided. Formulas in Excel typically start with an equal sign (=) and can contain a combination of numbers, operators, functions, cell references, and constants. To understand more precisely consider the below given Excel formula elements: Numbers: these values can be directly written in a formula. An example includes any number such as 5, 1. 5, -3, etc. Operators: these can be defined as the mathematical symbols used to perform calculations. Examples include addition (+), ... Read More
In this article, the user will learn the process of locking and protecting some selected cells in Excel. Locking and protecting nonempty cells in a selected range with the "Protect Sheet" feature in spreadsheet applications like Excel or Google Sheets provides an additional layer of security to prevent accidental or unauthorized modifications to important data. By using the "Protect Sheet" feature and locking selected cells, the user can add an extra level of control and safeguard to the user spreadsheet, promoting data integrity, collaboration, and data security. In this article, two examples are provided. The first example, allow the ... Read More
One of the most popular ways to manage and distribute Python packages is through the Anaconda distribution, which is a free and open-source distribution of Python. Installing Python packages in Anaconda is a simple process that can be done through various methods, such as using the conda command, pip, or the Anaconda Navigator. In this guide, we will explore the different methods for installing Python packages in Anaconda and explain how to use each one. Whether you are a beginner or an experienced Python developer, this guide will provide you with the knowledge you need to effectively manage and distribute ... Read More
OpenCV provides us the function cv.rotate() to rotate an image (NumPy array) in multiples of 90 degrees. This function rotates an image in three possible ways: 90, 180, and 270 degrees clockwise. We use the following syntax − Syntax cv2.rotate(img, rotateCode) rotateCode is a rotate flag specifying how to rotate the array. The three rotate flags are as below − cv2.ROTATE_90_CLOCKWISE cv2.ROTATE_180 cv2.ROTATE_90_COUNTERCLOCKWISE Steps To rotate an input image, you could follow the steps given below − Import the required libraries OpenCV and matplotlib. Make sure you have already installed them. Read the input image using ... Read More
A variable is a way of storing values in the Python programming language so they can be used later in the program. These variables frequently find use within functions, necessitating the need to access a variable from another function. We shall examine Python's methods for calling a variable from another function in this article. In Python, calling a variable from another function can be done in one of two ways − Global Variables Return Statement Let's take a closer look at each of these techniques − Global Variables A global variable is a special kind of computer variable ... Read More
We can install Selenium Webdriver with Python with the following steps.In Linux or MacOS, Python is installed by default. However, in Windows, we have to download Python from the link https://www.python.org/downloads/.Click on "Download Python " button. Once the download is completed, the Python executable file gets saved in our system. Click on this file, and the Python installation landing page gets opened. Then, click on Install Now.Once the installation is completed, Python gets downloaded in the path −C:\Users\\AppData\Local\Programs\Python\PythonWe have to configure the path of the Python folder along with the Scripts folder (generated within the Python folder) in the Environment ... Read More
Using Pandas, we can create a dataframe and can set the index for datetime. Using gcf().autofmt_xdate(), we will adjust the date on the X-axis.StepsMake the list of date_time and convert into it in date_time using pd.to_datetime().Consider data = [1, 2, 3]Instantiate DataFrame() object, i.e., DF.Set the DF['value'] with data from step 2.Set DF.index() using date_time from step 1.Now plot the data frame i.e., plt.plot(DF).Get the current figure and make it autofmt_xdate().Using plt.show() method, show the figure.Exampleimport pandas as pd import matplotlib.pyplot as plt date_time = ["2021-01-01", "2021-01-02", "2021-01-03"] date_time = pd.to_datetime(date_time) data = [1, 2, 3] DF = ... Read More
In this article, we will show you how to perform square root without using a math module in Python. Below are the various methods to accomplish this task: Using exponential operator ** Using Mathematical Logic Using exponential operator ** Without using the math module, the simplest approach to find the square root of a number in Python is to use the built-in exponential operator ** (It is an exponent operator because it calculates the power of the first operand to the power of the second operand). Algorithm (Steps) Following are the Algorithm/steps to be followed to perform the desired ... Read More
The "+" sign to the left of the row numbers will display your compressed rows when you click on it. By doing this, the rows will be expanded so that one can see the embedded data. Simply select the "-" symbol to expand the rows once more. Click Collapse to make the present item's details invisible. Click Collapse Entire Field to conceal the details for every object in a field. Click Expand Entire Field to view the details for every object in a field. In this article, the user will expand or collapse the items in a pivot ... Read More