Databricks数据相关面经_Databricks数据相关面试真题及高频题

1.Handling Edge Cases in Data Frames

2.Data Manipulation with Python Data Frames

3.Count Contiguous Subarrays with Alternating Even and Odd Numbers

4.Longest Diagonal Pattern Streak in Matrix

5.Word Recovery from Skeletons

6.Count Elements with Odd Number of Zero Occurrences

7.Longest Segment of Contiguous Houses

8.Calculate the Final Position of a Falling Figure in a Matrix

9.Version Control System Branch with Most Files

10.Count Elements with Even Number of Digits

11.Count Distinct Pairs with Similar Digits

12.Convert Snake Case to Camel Case in Substrings

13.Student with Highest Average Grade

14.Array Transformation Based on Characters

15.Valid Pair Count in Array

16.Valid Skeleton Word Count

17.Point Range Count

18.Maximum Sum Frame in a Matrix

19.Stock Price Analysis

20.Classification Metrics Comprehension

21.Understanding Linear Regression Assumptions

22.SQL Second Degree Follower Problem

23.Matrix Manipulation

24.Count Road Lamp Coverage

25.Rank Teams by Points

26.Binary String Operations

27.Bubble Match Game State

28.Calculate Waiting Time for the Next Bus

1. Handling Edge Cases in Data Frames

Given a problematic data frame, think of edge cases and perform data manipulation and summarization. The task involves advanced manipulation of text, strings, and datetime, considering the total running time of clusters allocated to the initial days, accounting for daily time, precise start/end dates and times, followed by summarization.

2. Data Manipulation with Python Data Frames

Given a data frame containing multiple companies' monthly revenues, calculate their cumulative income for the current year. The focus is on standard pandas operations for data manipulation.

3. Count Contiguous Subarrays with Alternating Even and Odd Numbers

Given an array of integers, count the number of contiguous subarrays that represent a sequence of numbers alternating between even and odd.

4. Longest Diagonal Pattern Streak in Matrix

Find the longest diagonal streak of the pattern 1,2,0,2,0 in a matrix.

5. Word Recovery from Skeletons

Given a word and a list of skeletons, return the skeletons that can recover the word using the characters in the skeleton. For example, given the word 'hello' and skeletons ['he-lo', 'he--o'], return ['he-lo'].