Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Pandas is one of the popular libraries used to perform data analysis and data manipulation. There are many advanced features to work with the tabular data such as join multiple data frames into one depending upon the common columns or indices of columns. In python, there are different types of joins available which can be performed by using the merge() function along with the how parameter of the pandas library. Following are the different joins. Inner Join Outer Join Left Join Right Join Cross Join Inner Join An Inner Join in the pandas library will return the rows ... Read More
Pandas and Matplotlib are the libraries available in python to perform data analysis and visualization for the given input data. Following are some different plots that can be plotted using the pandas and matplotlib libraries. Using Line Plot The line plot is the simplest plot to visualize the data over the time; this plot can be plotted using the pandas and matplotlib libraries. We have the plot() function available in the matplotlib library to plot the line plot. Following is the syntax. import matplotlib.pyplot as plt plt.plot(x, y) Where, matplotlib.pylot is the library. plt is the alias ... Read More
Input and Output are the important operations to be performed in the programming language which allows the users to interact with program. Input implies the data or information provided to the program from the external source. Output is the way we display the processed data or information generated by the program to the given input data. There are different techniques in python for using the input and output, let’s see them one by one. Different types of Input Techniques The following are the input techniques that we can use to pass the input to the python program. Standard Input The ... Read More
Assignment statement in python is the statement used to assign the value to the specified variable. The value assigned to the variable can be of any data type supported by python programming language such as integer, string, float Boolean, list, tuple, dictionary, set etc. Types of assignment statements The different types of assignment statements are as follows. Basic assignment statement Multiple assignment statement Augmented assignment statement Chained assignment statement Unpacking assignment statement Swapping assignment statement Let’s see about each one in detail. Basic Assignment Statement The most frequently and commonly used is the basic assignment statement. In ... Read More
RDD is abbreviated as Resilient Distributed Dataset, which is PySpark fundamental abstraction (Immutable collection of objects). The RDD’s are the primary building blocks of the PySpark. They split into smaller chunks and distributed among the nodes in a cluster. It supports the operations of transformations and actions. Dataframe in PySpark DataFrame is a two dimensional labeled data structure in python. It is used for data manipulation and data analysis. It accepts different datatypes such as integer, float, strings etc. The column labels are unique, while the rows are labeled with a unique index value that facilitates accessing specific rows. ... Read More
In today's digital era, Excel has become an indispensable tool for countless individuals and businesses who rely on it for organizing and analyzing massive amounts of data. One often-underutilized feature of this powerful software is the Frequency array function. While many are familiar with other array functions like Offset, and Index, they can bring tremendous benefits when used within an Excel workbook too. The frequency function is one of the most powerful functions, that unravel the mystery of the complex numerical array problems. Features of Frequency Function The Frequency function works with the numbers only and contains two arguments ... Read More
Microsoft Excel is undoubtedly one of the most powerful tools for organizing and analysing data. With its extensive range of features, it often becomes challenging to uncover all its hidden tips and tricks. In this article, we will explore a simple yet effective technique to use the Double unary operator in the Excel Array formula. For intricate scenarios, AND and OR operators proved to be more powerful and defined along with the SUM function to perform the complex task. The double unary operator transforms the Boolean values that are True/False into the binary form (0 or 1) which is understandable ... Read More
Array Constant comprises static numeric values that mean these values cannot be modified once the user copies the formula to another location in the worksheet. The array elements would contain numbers, text, and decimal values. Users must use either the F9 key or ctrl+shift+Enter keys to compute the array formula. A diversity of inbuilt array functions like the Transpose function, LINEST, and AGGREGATE functions are available in MS Excel. Various types of Array constants are Horizontal Array Constants Vertical Array Constants Two-Way Array Constants Utilizing Horizontal Array Constants It is also known as Row Array constants. The ... Read More
Introduction The internet underbelly, regularly alluded to as the "Dark Web, " has captured the interest of numerous, advertising a cryptic world covered up underneath the surface of the ordinary web. Exploring the Dark Web requires cautious thought because it could be a domain known for its unlawful exercises. In any case, for those who look for to get to it securely and dependably, understanding its flow, focal points, and pitfalls is vital. This article digs into the domain of the Dim Web, sketching out strategies for secure getting to, examining its merits and demerits, investigating its applications and challenges, and ... Read More
Introduction In the dynamic domain of artificial intelligence, chatbots have developed as trans-formative devices, redefining client intuitive and benefit conveyance. Among the assorted cluster of chatbot approaches, Generative Chatbots and Rule-Based Chatbots stand out as excellent techniques. This article embraces an in-depth investigation of the polarity between these two categories, shedding light on their fundamental mechanics, identifying their multifaceted focal points, portraying their inborn disadvantages, revealing their flexible applications, and eventually, diving into their overarching centrality and the challenges they show. As we dismember the one of a kind traits of Generative and Rule-Based Chatbots, we reveal the significant effect ... Read More