Swiggy Data Scientist 2 Interview Questions and Answers

Questions from arrays and strings and some aptitude questions

Q1. How to merge 2 csv files
Ans. 
To merge two CSV files, you can use software like Microsoft Excel or programming languages like Python.
• Open both CSV files in a software like Microsoft Excel.

• Copy the data from one CSV file and paste it into the other CSV file.

• Save the merged CSV file with a new name.

• Alternatively, you can use programming languages like Python to merge CSV files by reading both files, combining the data, and writing to a new file.
Answered by AI
Add your answer
Q2. Basic questions on arrays
Add your answer

Q1. 3 reasons why u choose this company
Ans. 
I applied to this company because of its reputation in the industry, opportunities for growth, and company culture.
• Reputation in the industry - I have heard great things about the company's innovative projects and successful track record.

• Opportunities for growth - The company offers various training programs and career advancement opportunities for employees.

• Company culture - I value a positive work environment and the...read more
Answered by AI
Add your answer

Q1. Questions on python
Add your answer

It was basic MCQ related to Javascript

Q1. Asked basic questions related to array and SQL
Add your answer

Q1. Asked question to test the business context
Add your answer

Basic Apititude Questions

Q1. Difference between WHERE and HAVING??
Ans. 
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
• WHERE is used with SELECT statement to filter rows based on a condition

• HAVING is used with GROUP BY statement to filter groups based on a condition

• WHERE is applied before data is grouped, HAVING is applied after data is grouped

• Example: SELECT * FROM table WHERE column = 'value'

• Example: SELECT column, COUNT(*) FROM table GROUP B
Answered by AI
Add your answer
Q2. Where- Row Level Filters Having-Aggregate Filters
Ans. 
Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.
• Row level filters are used to filter individual rows of data before any aggregations are performed.

• Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.

• Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...read more
Answered by AI
Add your answer

Q1. Why do you wanna join Uber?
Add your answer
Q2. Best Company Ever
Add your answer

It was easy consisting of sql and excel questions

Approx 30 questions which are to be solved in 1 hour. Questions include logical and mathematical questions along with basic ML and stats questions

Q1. Basic questions related to Python and SQL
Add your answer

Q1. Advance SQL questions and 1 case study
Add your answer

Q1. Basic ML questions and Business acumen questions
Add your answer

The aptitude questions were bit easy and there were questions about SQL, and also excel sheets.

Q1. Questions about sql
Add your answer

Q1. Joins, operations questions not data analysis questions
Add your answer
Q2. Customer retention case study
Add your answer
Q3. Cumulative sum for given table
Ans. 
To calculate cumulative sum for a given table
• Sort the table in ascending order based on the column you want to calculate the cumulative sum for

• Add a new column to the table to store the cumulative sum

• Iterate through each row of the table and calculate the cumulative sum by adding the current row's value to the previous row's cumulative sum

• Store the cumulative sum in the new column for each row
Answered by AI
Add your answer
Q4. Do you have experience in operations/data entry role
Ans. 
Yes, I have experience in both operations and data entry roles.
• I have worked as a data entry operator for a pharmaceutical company where I was responsible for entering patient data into the system.

• In my previous role as an operations analyst, I was responsible for analyzing data and creating reports for the management team.

• I have experience using various data entry software such as Microsoft Excel and Google Sheets.

• I a...read more
Answered by AI
Add your answer
Q5. As a data analyst can you do data entry work also?
Ans. 
Yes, I can do data entry work as a data analyst.
• Data entry work is a part of data analysis process.

• I have experience in data entry work and can perform it efficiently.

• Data entry work includes entering data into spreadsheets, databases, or other software.

• I understand the importance of accurate data entry for effective analysis.
Answered by AI
Add your answer
Q6. Normal excel statements like if, vlookup, xlookups etc.,
Add your answer

Q1. Screening questions
Add your answer
Q2. Name, age, qualification, prior experience etc
Add your answer

Operation questions like vlookups, Hlookups, xlookups etc,.

Reporting questions like pivot tables, typing speed, power pivots, pricing sheet preparation

SQL queries like joins, aggregation functions, filters etc,.

Q1. Advanced analytics and finding trends and patterns with MH - operations data
Add your answer
Q2. How fast can you prepare a bar chart with product operations data
Ans. 
I can prepare a bar chart with product operations data within a few minutes.
• I have experience using data visualization tools like Tableau, Power BI, or Excel to quickly create bar charts.

• I am proficient in organizing and cleaning data to ensure accurate representation in the chart.

• I can customize the chart with relevant labels, colors, and titles to make it visually appealing and easy to understand.
Answered by AI
Add your answer
Q3. How can I do merge multiple excel files together
Ans. 
You can merge multiple Excel files together using the 'Consolidate' feature in Excel.
• Open Excel and go to the 'Data' tab

• Click on 'Consolidate' in the 'Data Tools' group

• Select the files you want to merge and choose the desired options

• Click 'OK' to merge the files together
Answered by AI
Add your answer