Introduction to Generators in Python
Before diving into the concept of Generators in python, let's take make ourselves familiar with the Iterators. Iterators are python objects that can be iterated upon, meaning that we can...
Tag: data science
Find the Second Occurrence of a Substring in Python String
LAST UPDATED: August 5, 2022, 11:25 IST
In this article, we will discuss different methods (find, split and regular expression module) to find the second occurrence of a substring in a given string.
How to Delete a Column in SQL?
by Raju Kumar
LAST UPDATED: August 3, 2022, 9:32 IST
Sometimes in the dataset, you have some columns that are not of your use but when you run a query it will also get executed that leads to you increase...
Python Closure: How and Why to use
by Raju Kumar
LAST UPDATED: August 15, 2022, 19:23 IST
Closure in python is the function that remembers values in enclosing scopes even if they are not present in memory. In this article, we will discuss about python closure in...
How to use pass statement in Python
by Raju Kumar
LAST UPDATED: August 15, 2022, 19:26 IST
A pass statement in Python is a null statement that act as a placeholder for future code. In this article, we will briefly discuss how to use pass statement with...
How to use a CASE statement in SQL
by Vikram Singh
LAST UPDATED: August 1, 2022, 8:08 IST
In SQL you can apply conditions on the cell based on other cells using CASE statement. In this article we will discuss how to use a case statement in sql...
BETWEEN Operator in SQL
by Vikram Singh
LAST UPDATED: August 1, 2022, 8:08 IST
In the previous articles, we have discussed LIKE and IN operator. In this article we will discuss BETWEEN operator in SQL that is also a logical operator.
How to use SQL IN Operator
by Vikram Singh
LAST UPDATED: August 1, 2022, 8:07 IST
In the previous article, we have discussed LIKE operator. In this article, we will discuss IN operator in SQL that is also a logical operator.
LIKE Operator in SQL
by Vikram Singh
LAST UPDATED: August 1, 2022, 8:07 IST
Logical Operators in SQL are used to connect two or more expressions. In this article, we will discuss one of the logical operators i.e. LIKE operator in detail about how...
INNER JOIN in SQL
by Vikram Singh
LAST UPDATED: August 2, 2022, 16:28 IST
SQL JOINS are used to combine more than two or more tables together to extract the useful data from all the tables. In this article, we will discuss INNER JOIN...