Skewb Analytics Interview Questions, Process, and Tips

Q1. Introduce to the CTO
Add your answer
Q2. Share the projects created, and asked questions based on that
Add your answer
Q3. How do you create calculated columns in pandas
Ans. 
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['
Answered by AI
Add your answer
Q4. How do you treat outliers in an Dataset
Ans. 
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
Answered by AI
Add your answer
Q5. What is an Normal Distribution in an Dataset
Ans. 
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
Answered by AI
Add your answer
Q6. Given in an example how to treat different categorised values based on their frequency.
Ans. 
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
Answered by AI
Add your answer

Bascis of html css and oops

Q1. How a function returns object in JS
Add your answer

Questions on Aptitude, Excel , SQL and Python