Data Science

The Data Science field uses scientific methods, processes, and algorithms to extract meaningful information from structured and unstructured data. Find everything you need to know about Data Science, all in one spot. Get started on your Data Science journey, now!

Joins and Its Types in SQL

Joins and Its Types in SQL

Overview Joins in SQL are used for retrieving data from several relations. A join is formed whenever multiple relations are listed in the same SQL statement. There are four kinds of joins in SQL-inner, left outer, right outer, and full outer join. In this article, we shall learn about all

Blog | Board Infinity
Blog | Board Infinity
Data Science
reset index pandas illustration

Learn about Reset Index Pandas

Introduction In this article, we will learn about reset index pandas on pandas DataFrame with several examples. We have previously learned that Pandas is a Python library used for working with data sets. It offers tools for data exploration, cleaning, analysis, and manipulation. To reset the index on the pandas

Blog | Board Infinity
Blog | Board Infinity
Data Science
How to Get Column Names in Pandas?

How to Get Column Names in Pandas?

Introduction In this article, we will learn how to get the column name from a given dataset in pandas. We have previously learned that Pandas is a Python library used for working with data sets. It offers tools for data exploration, cleaning, analysis, and manipulation. How to get or print

Blog | Board Infinity
Blog | Board Infinity
Data Science
A-Z about Python Variables

A-Z about Python Variables

Python Variables 101 The management of several values is required while creating a program. Variables are used to store values. A variable in Python is a label to which a value may be assigned. And a value is always connected to a variable. Consider this: message = 'Hello from Board Infinity!

Blog | Board Infinity
Blog | Board Infinity
Python
how correlated subqueries work in sql

Working of Correlated SubQueries in SQL

Overview In this article, we shall learn about correlated subqueries in SQL. A correlated query is a query nested within another query, such that the outer query is dependent upon the result produced by the inner query after its execution. Scope In this article we shall LEARN ABOUT: * SQL correlated

Blog | Board Infinity
Blog | Board Infinity
Data Science
matrix multiplication with python

How to perform Matrix Multiplication with Numpy Python

Introduction A double rectangular array of data represented in rows and columns is known as a Python matrix. A matrix's data might consist of letters, integers, strings, formulas, symbols, etc. One of the crucial data structures that may be employed in calculations in math and science is the matrix. By

Blog | Board Infinity
Blog | Board Infinity
Data Science
nested queries in sql

Nested Queries in SQL - Query In Query

Overview S.Q.L. (Structured Query Language) is a language used to operate R.D.B.M.s (Relational Database Management System). A handy feature in SQL is nesting a query within another. The nested query is also referred to as a subquery. This article aims at shedding some light

Blog | Board Infinity
Blog | Board Infinity
Data Science
rollback vs commit in sql

Understanding the Difference between Rollback and Commit

Introduction COMMIT and ROLLBACK are the two most common terms during transactional statements which are performed by the SQL transaction. For performing one complete SQL transaction, different transaction statements like COMMIT, SAVEPOINT, and ROLLBACK are used in that transaction. This article mainly explains the difference between COMMIT and ROLLBACK present

Blog | Board Infinity
Blog | Board Infinity
Data Science
illustration of how pivot works in sql

How to Perform Pivot in SQL?

Introduction SQL has relational operators like PIVOT and UNPIVOT. These relational operators help in transforming the table into a simple version and for a clear view of the data. PIVOT operator in SQL converts the row data of the table into column data. In contrast, UNPIVOT operator in SQL is

Blog | Board Infinity
Blog | Board Infinity
SQL
matplotlib pyplot

How to Plot in Python using Pyplot?

Introduction Matplotlib is the package used for data visualization and is one of the most popular packages in python. As the name suggests Matplotlib works like MATLAB. Pyplot is a cluster of functions that makes matplotlib like MATLAB. Each pyplot function takes is used to make some changes to a

Blog | Board Infinity
Blog | Board Infinity
Python