Thorogood Data Analyst Intern Interview Questions and Answers for Freshers

Q1. How to transpose data set
Ans. 
Transposing a data set involves flipping rows and columns.
• Identify the data set to be transposed

• Create a new table with the columns and rows flipped

• Copy the data from the original table to the new table

• Transpose can be done using Excel, Python, R, SQL, etc.

• Example: Transposing a table of sales data to have products as rows and months as columns
Answered by AI
View 1 more answer

Simple assessment includes logical reasoning and general aptitude

Includes simple programs

Q1. Tell me about yourself
Add your answer
Q2. Compare strings from 2 files and store distinct strings in a different file
Ans. 
The solution compares strings from 2 files and stores distinct strings in a different file.
• Read the contents of both files into separate arrays

• Loop through the first array and check if each string is present in the second array

• If not present, add the string to a new array

• Write the contents of the new array to a different file
Answered by AI
Add your answer

Q1. Structured query language
Add your answer
Q2. Python and Java and R
Add your answer

Q1. Mangerial Ronund
Add your answer
Q2. Salary expectations
Add your answer

It is very easy . Leetcode easy prob can help out

Basic cat type questions

Q1. Basics about python, some queries about SQL , something about machine learning
Add your answer

Q1. What is your family background?
Add your answer
Q2. Why are you looking for a change?
Add your answer
Q3. Why should we hire you?
Add your answer
Q4. Tell me about yourself.
Add your answer