Data Analyst

Tanmay and Rohit are best buddies. One day Tanmay gives Rohit a problem to test his intelligence and skills. He gives him an array of N natural numbers and asks him to solve the following queries:-

Query 0 :

0 x y

This operation modifies the element present at index x to y.

Query 1 :

1 x y 

This operation counts the number of even numbers in range x to y inclusive.

Query 2 :

2 x y 

This operation counts the number of odd numbers in range x to y inclusive.

You are given a string 'STR'. The string contains [a-z] [A-Z] [0-9] [special characters]. You have to find the reverse of the string.

For example:

 If the given string is: STR = "abcde". You have to print the string "edcba".

follow up:

Try to solve the problem in O(1) space complexity. 

What is the difference between a Set and Dictionary? (Learn)

What are the best methods for data cleaning? (Learn)

How can you handle missing values in a dataset? (Learn)

Write an SQL query to find an employee with the highest salary.

Difference between primary key and unique Key. (Learn)

Introduce yourself.    

Why have you chosen data analyst as a career?

How do you create a dropdown list in MS Excel?

Can you provide a dynamic range in the 'Data Source' for a Pivot table?

What is the difference between COUNT, COUNTA, and COUNTBLANK? (Learn)

What are some common data visualization tools that you have used?

What are your strengths and weaknesses as a data analyst?
What are the common problems data analysts encounter during analysis?