SQL Data schema was provided. SQL to be written that used left joins, nulls in filter, count func., case stmt.

Python
create a histogram from a given list
flatten a list: [1,2,[3,4. [5],[6,7,[8,[9]]]]]
remove duplicates from a list
count words in a sentence

Question

SQL Data schema was provided. SQL to be written that used left joins, nulls in filter, count func., case stmt.

Python
create a histogram from a given list
flatten a list: [1,2,[3,4. [5],[6,7,[8,[9]]]]]
remove duplicates from a list
count words in a sentence

booya · Accepted Answer

# Python solutions
#1. Create a histogram:

def my_histogram(ip_list):
    for i in ip_list:
        print(i*'*')

ip_list = [2, 3, 4, 5]
my_histogram(ip_list)
#2. Flatten List

def flatten_list(ip_list, op_list=[]):
    for i in ip_list:
        if isinstance(i, list):
            flatten_list(i, op_list)
        else:
            op_list.append(i)
    return op_list

ip_list = [1, 2, [3, [4, [5]]]]
print(flatten_list(ip_list))
#3. Remove dupes from a list

def remove_dupes(ip_list):
    op_dict={}
    op_list=[]
    for i in ip_list:
        if i not in op_dict.keys():
            op_dict[i] = 1
            op_list.append(i)
    return op_list

ip_list=[1,1,1,2,2]
print(remove_dupes(ip_list))

#4. Count words in a sentence

from collections import Counter

def count_unq_words(ip_str):
    ip_str=ip_str.lower()
    ip_list=ip_str.split()
    op = Counter(ip_list)
    print(len(op))

ip_str="Count count words in a sentence"
count_unq_words(ip_str)

Meta

Domanda di colloquio di Meta

Risposta di colloquio

Aziende seguite

Ricerche di lavoro