Data Analyst

You are given a string 'S'. Your task is to check whether the string is palindrome or not. For checking palindrome, consider alphabets and numbers only and ignore the symbols and whitespaces.

Note :

String 'S' is NOT case sensitive.

Example :

Let S = “c1 O$d@eeD o1c”.
If we ignore the special characters, whitespaces and convert all uppercase letters to lowercase, we get S = “c1odeedo1c”, which is a palindrome. Hence, the given string is also a palindrome.

Write an SQL query to get the current date.

Write an SQL query to create a new table that contains both the data and structure copied from another table.

Write an SQL query to find all the employees whose salary is between 50,000 and 100,000.

How to Freeze the Top Row and First Column in Excel?

What is conditional formatting in Excel?

Which process do you use to clean unwanted data from a large dataset?

You are given an N x M integer matrix. Your task is to modify this matrix in place so that if any cell contains the value 0, then all cells in the same row and column as that cell should also be set to 0.

Requirements:

• If a cell in the matrix has the value 0, set all other cells in that cell's row and column to 0.
• You should perform this modification in place (without using additional matrices).

You must do it in place.

For Example:

If the given grid is this:
[7, 19, 3]
[4, 21, 0]

Then the modified grid will be:
[7, 19, 0]
[0, 0,  0]

You are given three rods (numbered 1 to 3), and ‘N’ disks initially placed on the first rod, one on top of each other in increasing order of size ( the largest disk is at the bottom). You are supposed to move the ‘N’ disks to another rod(either rod 2 or rod 3) using the following rules and in less than 2 ^ (N) moves.

1. You can only move one disk in one move. 
2. You can not place a larger disk on top of a smaller disk.
3. You can only move the disk at the top of any rod.    

Note :

You may assume that initially, the size of the ‘i’th disk from the top of the stack is equal to ‘i’, i.e. the disk at the bottom has size ‘N’, the disk above that has size ‘N - 1’, and so on. The disk at the top has size 1.

Example :

What is the order of appearance of the common clauses in a SELECT query?

Write an SQL query to retrieve the last N rows from the SQL table.

What is dictionary comprehension? Give an example.

How do you differentiate between a List and a Tuple? (Learn)
What is a docstring in Python? (Learn)

Why can't we use linear regression for a classification task? (Learn)

What are some of the hyperparameters of the Random Forest Regressor that help avoid overfitting?

Explain some methods for handling missing values in that data. (Learn)