Business Analytics Consultant Interview Questions and Answers

To find unique values of a column, use DISTINCT keyword in SQL. To get distribution, use GROUP BY clause.

• For SQL: SELECT DISTINCT column_name FROM table_name

• For Python Pandas: df['column_name'].unique()

• For distribution: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name

• For Python Pandas: df['column_name'].value_counts()