Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
How to Remove Unwanted Text From Cell in Excel?
Millions of users across the world utilise the robust spreadsheet programme Microsoft Excel for a variety of data manipulation activities. It happens frequently while working with data that you need to clean up or extract specific information from a cell while deleting extraneous text or characters. We will examine various techniques to effectively delete undesirable content from Excel cells in this step-by-step tutorial. We can remove superfluous spaces, trim leading or trailing characters, remove particular words, or extract particular substrings for you. You will have the knowledge and abilities necessary to streamline your data and make sure that your Excel ...
Read MoreHow to Remove Time from Date in Excel?
Excel is a strong programme that is frequently used for reporting, data analysis, and data manipulation. You could frequently get into circumstances while working with date and time data where you need to split the date portion from the time portion. With the integer portion representing the date and the decimal portion indicating the time, Excel stores date and time values as serial numbers. This step-by-step tutorial will show you how to use a variety of techniques to eliminate the time element from date values in Excel. We will investigate straightforward yet efficient methods to extract only the date while ...
Read MoreHow to Remove Texts Before or After a Specific Character From Cells in Excel?
Powerful spreadsheet programmes like Excel provide a wide range of features to alter and clean up data. Getting rid of text that comes before or after a specific character in a cell is a common data cleaning activity. In this article, we'll walk you through each step of how to complete this work using the built-in functions in Excel. Excel offers the tools you need to organise your data and save time, whether you need to get rid of prefixes, suffixes, or any other undesirable text. Whether you're a novice or a seasoned Excel user, becoming proficient in text manipulation ...
Read MoreWhat are the new types introduced in HTML for input type?
There are a number of new HTML5 form input types, 13 to be exact, that make it much easier for web designers to create engaging and user-friendly web forms. In web browsers that support them, the new HTML5 input types provide data validation, date picker controls, colour picker controls, inline help text, and other features. Input types provided by HTML5 In this article we will take a look at all of the new form input types and some examples to demonstrate their usage. The colour input type allows the user to choose a colour from a colour picker and ...
Read MoreWhat are the Significant Goals of the HTML5 Specification?
The World Wide Web uses HTML5 as a markup language to organize and display content. It was the first HTML update in 14 years, and it was approved in 2014. In today's world, that's a lifetime between updates. It is the fifth and final major HTML version recommendation issued by the World Wide Web Consortium. The current specification is indeed the HTML living specification. It now includes support for multimedia, audio, video, tags and elements, improved document markup, and new APIs. HTML5's primary goal is to make it easier for web developers and browser designers to adhere to consensus-based standards ...
Read MoreHow to Use the \"required\" Attribute on the select Element in HTML5
The HTML select element represents a control that displays a menu of options. It is used to make drop-down menus so users can choose the value they want. It is a useful feature for gathering data to be sent to a server. The tag is typically used within a form element, with the items to be chosen coded within another tag, . It can also be used as a stand-alone element that is associated with a form via one of its special attributes, . The tag in HTML is associated with numerous attributes. They are discussed below. ...
Read MoreDifference between compile-time polymorphism and runtime polymorphism
Polymorphism is one of the most important OOPs concepts. Its is a concept by which we can perform single task in multiple ways. There are two types of polymorphism one is Compile-time polymorphism and another is run-time polymorphism.Method overloading is the example of compile time polymorphism and method overriding is the example of run-time polymorphism.Sr. No.KeyCompile-time polymorphismRuntime polymorphism1BasicCompile time polymorphism means binding is occuring at compile timeR un time polymorphism where at run time we came to know which method is going to invoke2Static/DynamicBindingIt can be achieved through static bindingIt can be achieved through dynamic binding4.InheritanceInheritance is not involvedInheritance is ...
Read MoreSave the plots into a PDF in matplotlib
Using plt.savefig("myImagePDF.pdf", format="pdf", bbox_inches="tight") method, we can save a figure in PDF format.StepsCreate a dictionary with Column 1 and Column 2 as the keys and Values are like i and i*i, where i is from 0 to 10, respectively.Create a data frame using pd.DataFrame(d), d created in step 1.Plot the data frame with ‘o’ and ‘rx’ style.To save the file in PDF format, use savefig() method where the image name is myImagePDF.pdf, format = ”pdf”.To show the image, use the plt.show() method.Exampleimport pandas as pd from matplotlib import pyplot as plt d = {'Column 1': [i for i in ...
Read MoreDifference between DDL and DML in DBMS
Anybody dealing with databases must comprehend the distinction between DDL and DML commands because it has an impact on how data is saved, accessed, and modified. A collection of commands called DDL are used to specify a database's structure. Database objects including tables, views, indexes, and constraints can be created, modified, and deleted using these commands. DDL statements specify how the data is arranged and accessed rather than altering the data that is stored in the database. DML, on the other hand, is a set of instructions used to work with the data that is kept in the ...
Read MoreHow to select last 10 rows from MySQL?
To select last 10 rows from MySQL, we can use a subquery with SELECT statement and Limit concept. The following is an example. Creating a table. mysql> create table Last10RecordsDemo -> ( -> id int, -> name varchar(100) -> ); Query OK, 0 rows affected (0.75 sec) Inserting records into the table. mysql> insert into Last10RecordsDemo values(1, 'John'), (2, 'Carol'), (3, 'Bob'), (4, 'Sam'), (5, 'David'), (6, 'Taylor'); Query OK, 6 rows affected (0.12 sec) Records: 6 Duplicates: 0 Warnings: 0 mysql> insert into Last10RecordsDemo ...
Read More