In data scientist job, you can separate into three parts: Data Cleaning, Data Analysis, and Visualization. Which part would you prefer to do?
Data Interview Questions
133,156 data interview questions shared by candidates
1. the ORDER BY command in SQL is automatically set in what format if you didn't set it? Ascending or Descending? Answer: Ascending 2. When you want to delete or add a column of a table in a database, what command you will use? Answer: ALTER 3. this question about about LEFT JOIN, they ask what command you want to use if you want to keep all the info of the left table? Answer: left join 4. You want to combine two column after removing two duplicates, use UNION or UNION ALL? Answer: UNION
Validate an IP Address. Multiple test cases given.
Given a string like 'abc', print out all the strings of combination of the same length as the original string. Like 'abc', 'acb', 'bca', 'bac', 'cab', 'cba'
Phone Interview: Intermediate level Python and SQL questions. 5 questions each for 30 minutes.
Two tables: User actions: date|sessio_id|userid|event session details: date|Sessionid|timespent_Sec|userid 1. Identify avg time spent per user per day 2. Create a histogram of duration on x axis, no of users on y axis which is populated by volume in each bucket Product questions: 1. Wants to add a new banner on FB Market place which suggests to sell something on facebook , should they do it, what should be done to evaluate it ? 2. Market place transactions happen through messages - these messages went down by 10% in a month, should they be worried ? How would you go about analyzing it?
Top3 brand names with their average pieces more than $3 and having atleast 2 products.
What is the term used to select non duplicates in SQL?
How do you measure newsfeed health?
They answered no questions I sent over and sent my own questions back to me. So that was mighty pathetic too.
Viewing 981 - 990 interview questions