Upstart数据相关面经_Upstart数据相关面试真题及高频题

1.Python Data Processing

2.Count Companies with Conversion and Last Touch in the Same Month

3.Find Last Touch by Company or Month Before Conversion

4.Calculate Average Count by Month

5.Linear Regression Coefficients Expectation

6.Pandas Operations for Handling Null Values

1. Python Data Processing

Given a list containing JSON objects with various columns and values, process the data according to specified requirements and output the results.

2. Count Companies with Conversion and Last Touch in the Same Month

Write a SQL query to count the number of companies where both conversion and last touch occurred in the same month. Bonus question: Adjust the query to count only if the last touch until conversion is less than or equal to 45 days.

3. Find Last Touch by Company or Month Before Conversion

Using the provided marketing and conversion tables, write a SQL query to find the last marketing touch by company (or by month) before conversion.

4. Calculate Average Count by Month

Given a marketing table by marketing_touch and a conversion table, write a SQL query to calculate the average count by month.

5. Linear Regression Coefficients Expectation

Given E(X), E(Y), Var(X), Var(Y), and cov(X,Y), perform linear regression Y = aX + b + e. Calculate the expected values E(a) and E(b).