-
Appending to DataFrame | Pandas
Appending a new row to DataFrame import pandas as pd df = pd.DataFrame(columns = [‘A’, ‘B’, ‘C’]) Appending a row by a single column value: df.loc[0, ‘A’] = 1 df Appending a row, given list of values: df.loc[1] = [2, 3, 4] df Appending a row given a dictionary: df.loc[2] = {‘A’: 3, ‘C’: 9,… Read more
-
What is Exploratory Data Analysis (EDA)?
Exploratory Data Analysis (EDA) is an essential step in any data science project. It involves investigating and analyzing datasets to understand their characteristics, identify patterns, detect outliers, and uncover relationships between variables. EDA helps in gaining initial insights into the data before diving into more complex analyses. The Foremost Goals of EDA Types of EDA… Read more
-
Anomaly Detection using Gaussian Mixtures
Introduction Anomaly detection (also called outlier detection) is the task of detecting instances that deviate strongly from the norm. These instances are of course called anomalies or outliers, while the normal instances are called inliers. Anomaly detection is very useful in a wide variety of applications, for example in fraud detection, or for detecting defective… Read more
-
A Journey From Biological to Artificial Neurons
Surprisingly, ANNs have been around for quite a while: they were first introduced back in 1943 by the neurophysiologist Warren McCulloch and the mathematician Walter Pitts. In their landmark paper, “A Logical Calculus of Ideas Immanent in Nervous Activity,”. McCulloch and Pitts presented a simplified computational model of how biological neurons might work together in… Read more
-
Bayesian Gaussian Mixture Models
Rather than manually searching for the optimal number of clusters, it is possible to use instead the BayesianGaussianMixture class which is capable of giving weights equal (or close) to zero to unnecessary clusters. Just set the number of clusters n_components to a value that you have good reason to believe is greater than the optimal… Read more
-
SQL | Alias Operator
SQL Alias Syntax for Columns: Also read Alias Example Assume we have a table called “Persons” and another table called “Product_Orders”. We will give the table aliases of “p” and “po” respectively. Now we want to list all the orders that “Ola Hansen” is responsible for. We use the following SELECT statement: The same SELECT… Read more