Square Panda India LLP Data Scientist Interview Questions and Answers

Q1. Sell me an ice tea in a cold hill station.
Ans. 
Refreshing ice tea is the perfect drink to enjoy in the cool hill station weather.
• Highlight the refreshing and cooling properties of ice tea

• Emphasize the versatility of ice tea - can be enjoyed hot or cold

• Mention the variety of flavors available, such as lemon, peach, or mint

• Suggest pairing the ice tea with local snacks or pastries for a complete experience
Answered by AI
Add your answer
Q2. Sell me an branded car.
Ans. 
Experience luxury and performance like never before with our top-of-the-line branded car.
• Our branded car offers cutting-edge technology for a seamless driving experience.

• Experience unparalleled comfort with premium leather seats and state-of-the-art amenities.

• Enjoy powerful performance with a high-performance engine that delivers top-notch speed and acceleration.

• Stand out on the road with a sleek and stylish design tha
Answered by AI
Add your answer
Q3. General HR questions
Add your answer

Q1. SQL queries , python pandas and numpy , power bi related questions
Add your answer

Q1. Previous experience, skills and expertise
Add your answer

Sql, numpy, pandas, dictionary, pandas group by, merging

Q1. Normal questions
Add your answer

2 python questions
2 SQL questions
5 MCQ questions

Q1. Basic SQL questions Acid property Difference between Varchar and char Join questions
Add your answer

Q1. Share details of your previous job.
Add your answer
Q2. Why are you looking for a change?
Add your answer
Q3. Tell me about yourself.
Add your answer

MCQ and Coding test

Q1. Basic SQL and Python Questions
Add your answer

Q1. What is your family background?
Add your answer
Q2. Tell me about yourself.
Add your answer

Q1. They asked me questions on python and mysql , after that they had asked my project and told me to do some modification
Add your answer

Q1. Why should we hire you?
Add your answer
Q2. Where do you see yourself in 5 years?
Add your answer
Q3. What are your strengths and weaknesses?
Add your answer
Q4. Tell me about yourself.
Add your answer

Q1. Sql - List top 3 youngest ages of employees dept wise
Ans. 
List top 3 youngest ages of employees dept wise using SQL.
• Use GROUP BY to group employees by department.

• Use ORDER BY to sort ages in ascending order.

• Use LIMIT to get top 3 youngest ages.

• Use MIN to get the youngest age in each department.
Answered by AI
View 3 more answers
Q2. Sql - List employees whose age is greater than average age of all employees
Ans. 
List employees whose age is greater than average age of all employees using SQL.
• Calculate the average age of all employees using AVG() function.

• Use WHERE clause to filter out employees whose age is greater than the average age.

• Join the employee table with the age table to get the age of each employee.

• Example: SELECT * FROM employees WHERE age > (SELECT AVG(age) FROM employees);
Answered by AI
View 1 more answer
Q3. Python - sum of digits till the result becomes single digit Ex: 479 - 20 - 2
Ans. 
Python program to find the sum of digits till the result becomes a single digit.
• Convert the number to a string and iterate through each digit.

• Add the digits and store the result.

• Repeat the process until the result becomes a single digit.

• Return the single digit result.
Answered by AI
View 7 more answers

Q1. Basic HR questions like why futurense, qualities that get you into futurense
Add your answer