Rockstar Games India Data Analyst Intern Interview Questions and Answers

Q1. About your project
Add your answer
Q2. Basic of machine learning
Add your answer
Q3. Basics of python
Add your answer
Q4. Sql joins and write a query.
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• Use INNER JOIN to return rows when there is at least one match in both tables.

• Use LEFT JOIN to return all rows from the left table, and the matched rows from the right table.

• Use RIGHT JOIN to return all rows from the right table, and the matched rows from the left table.

• Use FULL JOIN to return rows when there is a match in...read more
Answered by AI
Add your answer

Simple Data Science Case Study

Q1. Python knowledge related questions
Add your answer

Data Science Case Study

Q1. General ml questions
Add your answer
Q2. Coding on dataframe from kaggle
Add your answer

Coding round and MCQ about data science topics

Q1. Technical questions and project in your resume
Add your answer

Q1. Technical questions related to data science
Add your answer

Round duration - 90 Minutes
Round difficulty - Medium

The test is divided into 3 sections:
1. R coding.
2. Python coding. This section includes NumPy and scikit questions.
3. Statistics. This section includes T-tests, Anova regression distributions, and chi-square.
Each section has roughly 12 questions. The number of questions and difficulty is not set in advance, the test is adaptive. The more correct answers you give, the more the questions get tougher. The qualification does not depend upon the number of questions solved, rather on the difficulty level you can achive.

Round duration - 60 Minutes
Round difficulty - Hard

Q1. 
Rotate Matrix by 90 Degrees Problem Statement
Given a square matrix 'MATRIX' of non-negative integers, rotate the matrix by 90 degrees in an anti-clockwise direction using only constant extra space.
Inpu...read more
Ans. 
The task is to rotate a square matrix by 90 degrees in an anti-clockwise direction using constant extra space.
• Iterate through each layer of the matrix from outer to inner

• For each layer, perform a four-way swap of elements

• Continue this process until all layers have been rotated
Answered by AI
Add your answer

Round duration - 30 Minutes
Round difficulty - Medium

Python coding 45 mins

Q1. Fraud data balancing
Add your answer
Q2. Recommendation metrics
Add your answer

Q1. Why join Turing?
Add your answer
Q2. Ability to learn new skills
Add your answer

Assignment containing the python coding and the pandas data analysis and statistics questions

Q1. Given the tabular data and asked to find the issues in the data and how to solve them.
Add your answer
Q2. Check if the sentence is palindrome or not.
Ans. 
Check if a sentence is a palindrome or not.
• Remove all non-alphanumeric characters and convert to lowercase.

• Compare the original sentence with its reverse to check for palindrome.

• Example: 'A man, a plan, a canal, Panama' is a palindrome sentence.
Answered by AI
Add your answer

Q1. Classical data science questions
Add your answer
Q2. Given the large dataset and asked to find the answers using pandas
Add your answer

Q1. Given a dataset, pandas task and commands
Add your answer
Q2. DSA round for lists,string, tuples, dictionary
Add your answer