(python) Given two sentences, construct an array that has the words that appear in one sentence and not the other.
Data Interview Questions
132,958 data interview questions shared by candidates
Write a program in Python to calculate tax if Salary and Tax Brackets are given as list in the form [ [10000, .3],[20000, .2], [30000, .1], [None, .1]]. You don’t know in the beginning how many tax brackets are there. You have to test for all of them.
SQL: joins, aggregations Python: basic data structures
Given an event-level table of interactions between pairs of users (note that there aren't duplicates in one day for one pair of users), for each possible number of "people interacted with" find the count for that group in a given day (i.e. 10 people interacted with only one person, 20 with 2, etc.).
What is the expectation of the variance?
Interview Questions were average on difficulty level if you put some thought to it. Screening rounds were more of question answers based where they gave you a problem and expected an answer. Python: Find the max no from the given set of elements in an array (without using max function) Find the minimum absolute difference between the set of elements of an array. Python Coding Questions that involved a hashmap. Know your basics well Print Max element of a given list Print median of a given list Print the first nonrecurring element in a list Print the most recurring element in a list HCF/Greatest common Factor of List LCM of list Sql: find the highest salary per department Select employee from departments where max salary of the department is 40k Select employee assigned to projects Select employee which have the max salary in a given department Select employee with second highest salary Table has two data entries every day for # of apples and oranges sold. write a query to get the difference between the apples and oranges sold on a given day Typical questions around Group by, Joins during screening round they used MYSQL so practice solutions with basic SQL as the version i was working on didn't support analytical functions or other advanced features. Face To Face Rounds (Fullstack): To begin I was asked about different metrics which could be reported given the dataset/information or scenario. Then interviewer picked up a metrics and asked to draw on whiteboard what kind of graph/chart will I use to display the information. Then going further asked about the table structures and data model which will be required to support the dashboard. Interviewer then provided the initial data set which is 1 case was a log file and in another some detail level tables, I was asked to write a programming code to read, parse and load data to tables. Then along the way once we have our code tables and dashboard finalized i was asked to write SQL's for different steps in the whole pipeline.
How can Facebook figure out when users falsify their attended schools?
why data engineer?
What drove the change from IPv4 to IPv6?
Measure difference between two vectors
Viewing 311 - 320 interview questions