AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
MASAI
School
Compare
Filter interviews by
MASAI School Interview Questions and Answers
9 Interview questions
Grouping data in pandas allows for aggregation and analysis of subsets of data based on specific criteria.
Use `df.groupby('column_name')` to group data by a specific column.
You can apply aggregation functions like `sum()`, `mean()`, or `count()` after grouping.
Example: `df.groupby('category').sum()` will sum all numeric columns for each category.
Multiple columns can be grouped by passing a list: `df.groupby(['col1...
Joins combine rows from two or more tables based on related columns, enabling complex queries and data analysis.
INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;
LEFT JOIN (or LEFT OUTER JOIN): Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;
RIGHT JOIN (or RIGHT ...
In SQL, data is grouped by a specified column or expression using the GROUP BY clause.
Data is grouped based on the values in the specified column or expression
Aggregate functions like SUM, COUNT, AVG can be used with GROUP BY to perform calculations on each group
GROUP BY is often used in conjunction with the SELECT statement
Example: SELECT department, AVG(salary) FROM employees GROUP BY department
Web development is like building a house on the internet where people can visit and do things.
Web development is creating websites and web applications using programming languages like HTML, CSS, and JavaScript.
It involves designing how the website looks and works, and making sure it works well on different devices like computers and phones.
Examples of web development include creating a website for a business, an ...
The 'this' keyword refers to the current object and is used to access its properties and methods.
Used to refer to the current object in a method or constructor
Can be used to call another constructor in the same class
Can be used to call a method of the same object
Can be used to call a method of a parent object
Can be used to bind a function to a specific object
Designing an e-commerce schema involves structuring data for products, users, orders, and more for efficient management.
Define entities: Products, Users, Orders, Categories, and Payments.
Consider relationships: A Product can belong to multiple Categories.
Use normalization: Avoid data redundancy by separating data into related tables.
Implement indexing: Speed up queries on frequently accessed fields like product na...
Aggregation pipelines are a framework in MongoDB for processing and transforming data through a series of stages.
Aggregation pipelines consist of multiple stages, each performing a specific operation on the data.
Common stages include $match (filtering documents), $group (grouping documents), and $sort (ordering results).
Example: To find the total sales per product, use $group to sum sales amounts by product ID.
Pip...
Lists are ordered collections of items, while dictionaries are unordered collections of key-value pairs.
Lists are accessed by index, dictionaries are accessed by key
Lists maintain the order of elements, dictionaries do not guarantee order
Lists use square brackets [], dictionaries use curly braces {}
Example: list - [1, 2, 3], dictionary - {'a': 1, 'b': 2}
Lambda functions are anonymous functions in Python that can have any number of arguments but only one expression.
Lambda functions are defined using the lambda keyword.
They are commonly used for small, one-time tasks.
Lambda functions can take any number of arguments, but can only have one expression.
Example: add = lambda x, y: x + y
MASAI School Interview Experiences
17 interviews found
Anonymous
Selected
I appeared for an interview in Dec 2024, where I was asked the following questions.
- Q1. How to group by in pandas
- Ans.
Grouping data in pandas allows for aggregation and analysis of subsets of data based on specific criteria.
Use `df.groupby('column_name')` to group data by a specific column.
You can apply aggregation functions like `sum()`, `mean()`, or `count()` after grouping.
Example: `df.groupby('category').sum()` will sum all numeric columns for each category.
Multiple columns can be grouped by passing a list: `df.groupby(['col1', 'c...
- Q2. Explain all types of joins
- Ans.
Joins combine rows from two or more tables based on related columns, enabling complex queries and data analysis.
INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;
LEFT JOIN (or LEFT OUTER JOIN): Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;
RIGHT JOIN (or RIGHT OUTER...
(5 Questions)
- Q1. It is related to SQL, Python, and Excel
- Q2. Not Remember the interview questions exactly
- Q3. What is grouped by in SQL
- Ans.
In SQL, data is grouped by a specified column or expression using the GROUP BY clause.
Data is grouped based on the values in the specified column or expression
Aggregate functions like SUM, COUNT, AVG can be used with GROUP BY to perform calculations on each group
GROUP BY is often used in conjunction with the SELECT statement
Example: SELECT department, AVG(salary) FROM employees GROUP BY department
- Q4. List and dictionary differences
- Ans.
Lists are ordered collections of items, while dictionaries are unordered collections of key-value pairs.
Lists are accessed by index, dictionaries are accessed by key
Lists maintain the order of elements, dictionaries do not guarantee order
Lists use square brackets [], dictionaries use curly braces {}
Example: list - [1, 2, 3], dictionary - {'a': 1, 'b': 2}
- Q5. Lambda functions in python
- Ans.
Lambda functions are anonymous functions in Python that can have any number of arguments but only one expression.
Lambda functions are defined using the lambda keyword.
They are commonly used for small, one-time tasks.
Lambda functions can take any number of arguments, but can only have one expression.
Example: add = lambda x, y: x + y
Interview Preparation Tips
Skills evaluated in this interview
Himanshu Kumar
I applied via Referral and was interviewed in Mar 2024. There was 1 interview round.
(1 Question)
- Q1. Past experience, discussed three projects
Interview Preparation Tips
Selected
I applied via LinkedIn and was interviewed before Oct 2023. There were 2 interview rounds.
Around sql/python and other da tools
Stats and probability with focus on puzzles
Interview Preparation Tips
Selected
I appeared for an interview before Apr 2024, where I was asked the following questions.
- Q1. How will you deal with a company that has work with you but came back with a problem
- Ans.
Addressing client issues requires empathy, effective communication, and a solution-oriented approach to restore trust and collaboration.
Listen actively to understand the problem fully before responding.
Acknowledge the issue and express empathy for their situation.
Collaborate with the client to identify potential solutions.
Provide a clear action plan with timelines to resolve the issue.
Follow up after implementation to ...
- Q2. How soon can you join
- Ans.
I can join immediately, but I am flexible to accommodate your timeline for a smooth transition.
I am currently available and can start as soon as needed.
If required, I can assist in the transition process to ensure a seamless handover.
I understand the importance of filling this role quickly and am ready to prioritize this opportunity.
(1 Question)
- Q1. RCA questions, Questions through your resume
Selected
I appeared for an interview before Mar 2024, where I was asked the following questions.
- Q1. DSA - related to arrays hard
- Q2. Stack medium level
All the logical Qustions
(1 Question)
- Q1. They will ask you about dsa qustions
Interview Preparation Tips
(5 Questions)
- Q1. What is database indexing? How does indexing work? What is compound indexing in mongodb
- Q2. How is node.js non blocking? How does it handle async operations?
- Q3. What are aggregation pipelines?
- Ans.
Aggregation pipelines are a framework in MongoDB for processing and transforming data through a series of stages.
Aggregation pipelines consist of multiple stages, each performing a specific operation on the data.
Common stages include $match (filtering documents), $group (grouping documents), and $sort (ordering results).
Example: To find the total sales per product, use $group to sum sales amounts by product ID.
Pipeline...
- Q4. Design an e-commerce schema, and some of the things to look into while designing the schema
- Ans.
Designing an e-commerce schema involves structuring data for products, users, orders, and more for efficient management.
Define entities: Products, Users, Orders, Categories, and Payments.
Consider relationships: A Product can belong to multiple Categories.
Use normalization: Avoid data redundancy by separating data into related tables.
Implement indexing: Speed up queries on frequently accessed fields like product names.
P...
- Q5. What is the difference between fs.writeFile and fs.writeFileSync? How will it affect your apis when there is 1, 10 and 1000+ users respectively
Interview Preparation Tips
Skills evaluated in this interview
SARTHAK AHUJA
Basic Aptitude test
Coding Round is little tough.
(3 Questions)
- Q1. Formal conversation about the projects and all that kind of stuff
- Q2. What kind of project you have worked on
- Q3. How you tackles different project
Interview Preparation Tips
Top trending discussions
MASAI School Interview FAQs
Some of the top questions asked at the MASAI School interview -
The duration of MASAI School interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
MASAI School Interviews By Designations
- MASAI School Software Developer Interview Questions
- MASAI School Data Analyst Interview Questions
- MASAI School Associate Product Manager Interview Questions
- MASAI School Product Manager Interview Questions
- MASAI School Marketing Executive Interview Questions
- MASAI School Data Science Intern Interview Questions
- MASAI School Front end Developer Interview Questions
- MASAI School Mentor Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Engineer Interview Questions
- Sales Executive Interview Questions
- Associate Software Engineer Interview Questions
- Accountant Interview Questions
- Java Developer Interview Questions
- Senior Software Engineer Interview Questions
- Manager Interview Questions
- Sales Officer Interview Questions
- Show more
Overall Interview Experience Rating
based on 19 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
MASAI School Reviews and Ratings
based on 173 reviews
Rating in categories
|
Operations Manager
45
salaries
|  ₹5 L/yr - ₹13 L/yr |
|
Full Stack Web Developer
29
salaries
| ₹1 L/yr - ₹8 L/yr |
|
Data Analyst
20
salaries
| ₹4.2 L/yr - ₹10 L/yr |
|
Software Engineer
19
salaries
| ₹5 L/yr - ₹11.8 L/yr |
|
Full Stack Developer
18
salaries
| ₹1.6 L/yr - ₹7.4 L/yr |
FastInfo
Testbook.com
BrightCHAMPS
Acadecraft
- Home >
- Interviews >
- MASAI School Interview Questions
