Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
A diversity of statistical methods is available in MS Excel to generate the descriptive summary of data. Two-factor ANOVA is a paramount technique utilized by research scholars and data analysts to verify whether the relevant output is to be generated or not after performing a few tests. It would be possible to evaluate the means of more than one set of values using an analysis of variance. The major variations of ANOVA are unidirectional ANOVA and two-way ANOVA. The F-test is the statistical significance test for ANOVA. To perform ANOVA two-factor with Replication in Excel Step 1 − Assume ... Read More
Sometimes users enter data in the wrong column, due to this user need to swap the available contents between the two cells. This can be done in many possible ways. In this article, we will swap the contents of the two cells in Excel by using the normal drag and drop facility, and by using the VBA code. Both the provided examples are accurate, precise, and thorough. By following all the guided steps, the user can easily swap the contents of the two cells. After swapping the values will move back to their original supposed location or cell in the ... Read More
Pandas is one of the libraries in python which is used to perform data analysis and data manipulation. The data can have created in pandas in two ways one is as DataFrame and the other way is Series. The DataFrame is the two dimensional labeled data structure in python. It is used for data manipulation and data analysis. It accepts different data types such as integer, float, strings etc. The label of the column is unique whereas the row is labeled with the unique index value which helps in accessing the defined row. DataFrame is used in machine ... Read More
NumPy is one of the popular libraries in python which is used to perform numerical calculations, scientific computations. It also allows us to work with large multi-dimensional arrays and matrices. There are many functions and modules in-built in the numpy library which are used to work with the different dimensional arrays. Converting a dictionary into a NumPy array We can convert a dictionary into a NumPy array by using the different modules and functions available in Numpy library. Let's see each way one by one. Using the numpy.array() function In NumPy, we have the function namely array(), which is used ... Read More
The Instance variables are generally used to represent the state or attributes of an object. Each instance of a class can have its own set of instance variables, which can store unique values. An instance variable is defined within the methods of a class and is accessible throughout the instance's lifespan. Accessing the instance variable in python The flexibility that comes with usage of instance variables allows each instance to maintain its own set of variables, enabling customized behaviour and data storage for different objects. Thus, accessing instance variables in python is a useful step.There are different ways to ... Read More
Sorting refers as the technique to arrange the elements in the defined order. There are different ways to sort the dictionary by keys in python. In this article we are going to learn those. Using sorted() function The sorted() function is used to sort the elements in the iterable data structures like tuple, dictionary, list etc. This function takes the iterable as the argument and returns the new sorted list containing the sorted elements as the output. Following is the syntax for using the sorted() function on dictionary. sorted(dictionary.keys()) Where, sorted is the function used to sort ... Read More
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