i
Snapdeal
Filter interviews by
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 functi...
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 departme...
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.
Find the pair element from the array
Iterate through the array and use a hashmap to store elements and their counts
Check if the current element's complement exists in the hashmap
Return the pair if found, otherwise return null
By analyzing data, identifying pain points, and implementing solutions to improve user experience and trust.
Analyze user behavior and feedback to identify areas of improvement
Implement measures to increase transparency and trust, such as user reviews and seller verification
Provide resources and support for dispute resolution
Encourage diversity and inclusivity in the marketplace to attract a wider range of buyers a...
I will design a customer support system that is user-friendly, efficient, and personalized.
Conduct research to understand customer needs and preferences
Identify common customer issues and develop a knowledge base for quick resolution
Implement a ticketing system to track and prioritize customer inquiries
Integrate chatbots and AI to provide 24/7 support
Train support staff to provide personalized and empathetic servi...
Implement infinite scrolling in React JS using Intersection Observer API.
Use Intersection Observer API to detect when the user has scrolled to the bottom of the page.
Fetch new data and append it to the existing data using setState.
Use a loading spinner to indicate that new data is being fetched.
Add a debounce function to prevent multiple API calls while scrolling.
Use a key prop when rendering the list of data to a...
Code to find if input date is today/tomorrow or no of days difference from current date.
Get current date using Date() constructor
Convert input date to Date object
Compare input date with current date to check if it's today/tomorrow
If not, calculate the difference in days using getTime() method
Output the result accordingly
Bind creates a new function with a specified 'this' value and arguments.
Bind returns a new function with the same body as the original function.
The 'this' value of the new function is bound to the first argument passed to bind().
The subsequent arguments are passed as arguments to the new function.
Polyfill for bind() can be created using call() or apply() methods.
Saas is a CSS preprocessor that extends the functionality of CSS with variables, mixins, and more.
Saas stands for Syntactically Awesome Style Sheets
It allows for the use of variables, mixins, and functions in CSS
Saas code must be compiled into CSS before it can be used in a web page
Saas is often used in conjunction with build tools like Gulp or Webpack
There are 6 colors, so 6^3 = 216 different cubes can be obtained.
The cube has 6 faces, each of which can be one of 6 colors.
Therefore, there are 6 options for the first face, 6 for the second, and 6 for the third.
To find the total number of possible cubes, we multiply these options together: 6 x 6 x 6 = 216.
Median is best because it is not affected by outliers and gives a better representation of central tendency.
Median is the middle value in a dataset, which makes it less affected by extreme values or outliers.
It gives a better representation of central tendency as compared to mean, which can be skewed by outliers.
Mode is not always useful as it may not exist or may not be unique in a dataset.
For example, in a dataset of...
No, 899 is not a prime number.
A prime number is a positive integer greater than 1 that has no positive integer divisors other than 1 and itself.
899 can be divided by 29 and 31, so it is not a prime number.
The amount of water used in the college depends on various factors such as the number of students, staff, and facilities.
The amount of water used in the college varies depending on the size of the college.
The number of students, staff, and facilities also play a significant role in determining the amount of water used.
The college may have water-saving measures in place to reduce water usage.
The amount of water used may...
BookMyShow should charge different prices based on factors like movie of superstar, festival occasion, etc.
Consider the popularity of the movie star
Take into account the demand for tickets during festival occasions
Analyze the competition and market trends
Offer discounts for bulk bookings or loyalty programs
Consider the cost of production and distribution
Adjust prices based on the time of day or week
Use dynamic pricing ...
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: ...
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...
Reverse a stack without using extra space
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.
I applied via Recruitment Consulltant and was interviewed in Dec 2023. There was 1 interview round.
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...
I applied via Naukri.com and was interviewed in Apr 2024. There was 1 interview round.
Fast growth of population
I have 5 years of experience in project management, leading cross-functional teams to successful project completion.
Led cross-functional teams to complete projects on time and within budget
Managed project timelines, resources, and deliverables
Collaborated with stakeholders to ensure project goals were met
Implemented project management best practices to improve efficiency
Experience in creating and executing project plan...
2 medium level leet code question.
Find the pair element from the array
Iterate through the array and use a hashmap to store elements and their counts
Check if the current element's complement exists in the hashmap
Return the pair if found, otherwise return null
I applied via Recruitment Consulltant and was interviewed before Jan 2024. There was 1 interview round.
Simple sql and python basic questions was asked.
I applied via Company Website and was interviewed in Oct 2023. There were 3 interview rounds.
How to work working timing work process salary
The company follows a systematic working process to ensure efficient operations.
The company has defined workflows and procedures for each department.
Tasks are assigned to employees based on their skills and expertise.
There is a clear hierarchy and reporting structure in place.
Regular communication and collaboration among team members.
The company may use software or tools to streamline data entry processes.
Quality check...
Top trending discussions
Some of the top questions asked at the Snapdeal interview -
The duration of Snapdeal interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 33 interview experiences
Difficulty level
Duration
based on 660 reviews
Rating in categories
Assistant Manager
93
salaries
| ₹4.2 L/yr - ₹12 L/yr |
Senior Executive
84
salaries
| ₹2.8 L/yr - ₹5.8 L/yr |
Category Manager
82
salaries
| ₹6.9 L/yr - ₹23 L/yr |
Deputy Manager
56
salaries
| ₹5.5 L/yr - ₹12 L/yr |
Senior Software Engineer
51
salaries
| ₹12 L/yr - ₹29.5 L/yr |
Flipkart
Amazon
Meesho
eBay