Deeptek Data Scientist Interview Questions and Answers

Q1. Advanced formulas of Excel
Ans. 
Advanced Excel formulas are complex functions used for data analysis and manipulation.
• Advanced formulas in Excel include VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, and IFERROR.

• These formulas are used for tasks like data lookup, conditional calculations, and summarizing data.

• For example, VLOOKUP is used to search for a value in a table and return a corresponding value from another column.
Answered by AI
Add your answer

Q1. How to calculate requirement of Banana is a city like Mumbai
Ans. 
The requirement of bananas in a city like Mumbai can be calculated based on population, consumption habits, and availability.
• Calculate the population of Mumbai

• Estimate the average consumption of bananas per person

• Consider factors like tourism and events that may increase demand

• Take into account the availability of bananas from local markets and imports
Answered by AI
Add your answer
Q2. How to know , difference between a good or bad retailer
Ans. 
A good retailer focuses on customer satisfaction, product quality, and efficient operations.
• Good retailers prioritize customer satisfaction by providing excellent customer service and addressing customer needs.

• Good retailers offer high-quality products that meet customer expectations.

• Good retailers have efficient operations, including inventory management, supply chain logistics, and streamlined processes.

• Bad retailers...read more
Answered by AI
Add your answer
Q3. Simple SQL questions
Add your answer

Q1. What is sql, what is key word, tell me something about pandas and numpy, hangman puzzle
Ans. 
SQL is a programming language used for managing and manipulating relational databases. Keywords are reserved words in SQL.
• SQL is used to retrieve, insert, update, and delete data from databases

• Keywords in SQL are reserved words that have a specific meaning and cannot be used as identifiers

• Pandas is a Python library used for data manipulation and analysis

• NumPy is a Python library used for numerical computing and array o...read more
Answered by AI
Add your answer

It was good. 1 hr duration

Q1. The questions were asked one on one
Add your answer

Q1. Normal hr questions were asked
Add your answer

Q1. Joins and Basic aggregate questions
Add your answer
Q2. Python pandas realted
Add your answer

Basic GFG questions and basic logiccal reasoning

Q1. Why are you swithcing
Ans. 
Seeking new challenges and growth opportunities in a different industry.
• Looking for a new challenge to expand my skills and knowledge

• Interested in exploring different industries and gaining diverse experience

• Seeking growth opportunities that align with my career goals
Answered by AI
Add your answer

Q1. General questions from CV and then few questions related to logistic regression then a coding question
Add your answer

Q1. Questions in CV. Have I written a transformer code
Add your answer

Asked me to find the angle of skewness of documents