Snapdeal Interview Questions and Answers

Q1. Simple groupby questions in pandas?
Ans. 
GroupBy in pandas allows for data aggregation and transformation based on specific columns.
• Use `df.groupby('column_name')` to group data by a specific column.

• Apply aggregation functions like `sum()`, `mean()`, or `count()` after grouping.

• Example: `df.groupby('category').sum()` sums values for each category.

• You can group by multiple columns: `df.groupby(['col1', 'col2']).mean()`.

• Use `agg()` to apply multiple functions: ...read more
Answered by AI
Add your answer
Q2. Group by questions in SQL?
Ans. 
Group by in SQL aggregates data based on specified columns, allowing for summary statistics and analysis.
• The GROUP BY clause groups rows that have the same values in specified columns into summary rows.

• Common aggregate functions used with GROUP BY include COUNT(), SUM(), AVG(), MAX(), and MIN().

• Example: SELECT department, COUNT(*) FROM employees GROUP BY department; returns the number of employees in each department.

• Yo...read more
Answered by AI
Add your answer

Q1. Why you want to do this job?
Add your answer
Q2. What was your yesterday's schedule?
Add your answer
Q3. What is your short term goal?
Add your answer

Reverse a stack without using extra space

Q1. Convert Roman to Integer
Ans. 
Convert Roman numerals to integers using a mapping of values for each symbol.
• Create a mapping of Roman numeral symbols to their corresponding integer values.

• Iterate through the input Roman numeral string from right to left.

• If the current symbol's value is less than the next symbol's value, subtract it from the total. Otherwise, add it to the total.
Answered by AI
Add your answer
Q2. Mid of linked list
Add your answer

Q1. Basic SQL question.
Add your answer
Q2. Order of execution
Ans. 
The order of execution refers to the sequence in which instructions or operations are executed in a program.
• The order of execution is determined by the programming language and the specific code being executed.

• Generally, code is executed line by line from top to bottom.

• However, there are exceptions such as loops, conditionals, and function calls that can alter the order of execution.

• In some programming languages, there...read more
Answered by AI
Add your answer
Q3. Window functions
Add your answer
Q4. Aggregate functions
Add your answer