Python (1) Count "char" in the string. (2) Replace "None" in an array. Codes are simple but passing edge cases are difficult. SQL several % calculation questions

Question

Python (1) Count "char" in the string. (2) Replace "None" in an array. Codes are simple but passing edge cases are difficult.  SQL several % calculation questions

Anonymous · Accepted Answer

Edge cases - empty list, empty char

Anonymous · Answer

#4. Count words in a sentence

from collections import Counter

def count_unq_words(ip_str):

if len(ip_str.strip()) ==0:
        return 0
        
    res=0
    ip_list=ip_str.split()
    # counting spaces
    res = len(ip_list)-1
    
    for i in ip_list:
        if i.isnumeric():
            pass
        else:
            res+=len(i)
    print(res)

Meta

Meta interview question

Interview Answers

Want the inside scoop on your own company?

Bowls

Followed companies

Job searches