Skewb Analytics Interview Questions, Process, and Tips

Calculated columns in pandas can be created using the assign() method or by directly assigning a new column based on existing columns.

• Use the assign() method to create calculated columns by specifying the new column name and the calculation formula.

• Directly assign a new column by referencing existing columns and applying the desired calculation.

• Example: df.assign(new_column = df['column1'] + df['column2'])

• Example: df['

Outliers in a dataset can be treated by identifying them using statistical methods and then either removing them, transforming them, or keeping them based on the context.

• Identify outliers using statistical methods like Z-score, IQR, or visualization techniques like box plots.

• Decide whether to remove outliers, transform them using techniques like winsorization or log transformation, or keep them based on the context of ...read more

A normal distribution in a dataset is a bell-shaped curve where the data is symmetrically distributed around the mean.

• Data is evenly distributed around the mean

• 68% of data falls within one standard deviation of the mean

• 95% of data falls within two standard deviations of the mean

• Examples: heights of people, test scores in a class

Treating categorised values based on frequency involves grouping rare values together.

• Identify rare values based on their frequency distribution

• Group rare values together to reduce complexity

• Consider creating a separate category for rare values