Ipsos Data Analyst Interview Questions and Answers

1 easy sql and 1 easy python for 55 min

1 easy python and very hard sql for 1 hr 50 min

Q1. Mainly they focused on the answers you have written on round 2 and basic sql and pandas in python
Add your answer
Q2. 1) write a join 2) implement left join using pandas
Ans. 
Answering a question on writing a join and implementing left join using pandas for Data Analyst role.
• To write a join, we need to identify the common column(s) between two tables and use the JOIN keyword in SQL.

• Example: SELECT * FROM table1 JOIN table2 ON table1.common_column = table2.common_column

• To implement left join using pandas, we can use the merge() function with how='left' parameter.

• Example: pd.merge(table1, tab
Answered by AI
Add your answer

1 hr exam it is easy to crack

A train running at the speed of 60 km/hr crosses a pole of 9 seconds. what is hte length of train?

Print all prime numbers

Q1. Python string is changable or not
Ans. 
Python strings are immutable, meaning they cannot be changed once created.
• Python strings are immutable, so any operation that appears to modify a string actually creates a new string object.

• For example, when you use string concatenation or slicing, a new string is created instead of modifying the original string.

• To modify a string in Python, you would need to create a new string with the desired changes.
Answered by AI
Add your answer
Q2. Sql window function ?
Add your answer
Q3. Difference between having and where cause
Ans. 
HAVING is used with GROUP BY to filter groups, WHERE is used to filter rows
• HAVING is used with GROUP BY clause to filter the groups based on aggregate functions

• WHERE is used to filter rows based on conditions

• HAVING is applied after the GROUP BY clause, WHERE is applied before

• HAVING can only be used with SELECT statement that contains a GROUP BY clause

• Example: SELECT department, AVG(salary) FROM employees GROUP BY depar...read more
Answered by AI
Add your answer
Q4. Sql union and union all
Add your answer
Q5. Python using remove duplicate value
Ans. 
Use Python's set() function to remove duplicate values from an array of strings.
• Convert the array to a set to automatically remove duplicates

• Convert the set back to a list if needed
Answered by AI
Add your answer

Moderate level MCQ questions

Asked moderate level guesstimates and puzzles in 2 round