Pergunta de entrevista da empresa Meta

SQL ==> Sales, promotions, products DB I was able to complete only 3 questions. Python ==> solved only 3 questions. find giving letter in a string Replace None with previous element from List, there was some challenges [None] [None,1,2] ==> [None,1,2] [1,None,2] ==> [1,2,2] [1,4,None,None,3]===> [1,4,4,4,3] Forgot one question In the SQL part, please make sure you learn how to calculate %

Respostas da entrevista

Sigiloso

3 de nov. de 2020

False : [1,None,2] ==> [1,2,2] True : [1,None,2] ==> [1,1,2]

1

Sigiloso

9 de dez. de 2020

def fillNone(l): prev = None for i, n in enumerate(l): if n is None: l[i] = prev else: prev = l[i] return l

1

Sigiloso

31 de dez. de 2020

def rep(ls): index = 0 temp = None if len(ls) == 1 and ls[0] is None: return ls if ls[0] == None: index = index + 1 print(index) for i in range(index,len(ls)-1): if ls[i] == None: temp = ls[i-1] print(temp) if ls[i] is None: ls[i] = temp return ls