Metrics4 Analytics Data Analyst Interview Questions and Answers

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.

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

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