Improving my SQL BI Skills
by Pawan Kumar Khowal
2y ago
Python | The Print and Divide Puzzle In this puzzle you have to print numbers up to a certain range in descending order. If the number is divisible by 5 and 3 print “Pawan Here”, If the number is divisible by 5 print “Here” and If the number is divisible by 3 print “Pawan” Sample Input List -- i = 1 - 20 ( range ) -- Output -- Here 19 Pawan 17 16 Pawan Here 14 13 Pawan 11 Here Pawan 8 7 Pawan Here 4 Pawan 2 1 -- Solution -- for i in range(20,0,-1): if i % 15 == 0: print ("Pawan Here") elif i % 5 == 0: print ("Here") elif i % 3 == 0: print ("Pawan") else: print (i ..read more
Improving my SQL BI Skills
by Pawan Kumar Khowal
2y ago
Python | Count consecutive 1’s from a list In this puzzle you have to Count consecutive 1’s from a list Sample Input List -- a = [1,0,0,0,0,1,1] -- Output -- 2 -- Solution -- a = [1,0,0,0,0,1,1] b1 = 0 m = 0 for i in range(len(a)): if a[i] == 1: m = m + 1 else: if m > b1: b1 = m m = 0 if m > b1: print m else: print b1 -- Output --In Python3 2 -- Enjoy Please add a comment(s) if you have one or multiple solutions in mind. Thank You. Pawan Khowal Pawan is a Data Engineer. If you need any help in writing code/puzzle or training please email at ..read more
Improving my SQL BI Skills
by Pawan Kumar Khowal
2y ago
Python | Validate an IP Address-IPV6 In this puzzle you have to accept an string and validate it for IPV6 Sample Input List -- ipv6p('1001:0:11a2:52f8:2c78:818:ccf1:9a3a') -- Output -- 1 -- Solution -- def ipv6p(strs): chrs = '0123456789abcdefABCDEF' if strs.count(':') == 7: nums = strs.split(':') for x in nums: if len(x) == 0 or len(x) > 4 or not all(c in chrs for c in x): return 0 return(1) else: return(0) -- Output --In Python3 1 -- Enjoy Please ad ..read more
Improving my SQL BI Skills
by Pawan Kumar Khowal
2y ago
Python | Print positions of a string present in another string In this puzzle you have to print the positions of a string present in another string Sample Input List -- a = 'Hi I am here' b = 'am' -- Output -- String is present -- Solution -- a = 'Hi I am here' b = 'am' if b in a: print("String is present") else: print("String is NOT present") -- Output --In Python3 String is present -- Enjoy Please add a comment(s) if you have one or multiple solutions in mind. Thank You. Pawan Khowal Pawan is a Data Engineer. If you need any help in writi ..read more
Improving my SQL BI Skills
by Pawan Kumar Khowal
2y ago
Python | Check whether a string is a palindrome or not In this puzzle we have to check whether a string is a palindrome or not Sample Input List -- a = 'anna' -- Output -- Palindrome -- Solution -- a = 'anna' b = ''.join(reversed(a)) if a == b: print ("Palindrome ") else: print ("Not Palindrome ") -- Output --In Python3 Palindrome -- Enjoy Please add a comment(s) if you have one or multiple solutions in mind. Thank You. Pawan Khowal Pawan is a Data Engineer. If you need any help in writing code/puzzle or training please email at – pawankkm ..read more
Improving my SQL BI Skills
by Pawan Kumar Khowal
2y ago
Python | Find the missing number in the array of Ints In this puzzle you have to find the missing number from the list of sequential Ints starting 1 Sample Input List -- a = [1, 2, 3, 5, 6 ,7 ,8 ,9] -- Output -- 4 -- Solution-1 -- a = [1, 2, 3, 5, 6 ,7 ,8 ,9] cnt = len(a)+1 Total = ( cnt * (cnt + 1) ) / 2 y = int(Total - sum(i for i in a)) print(y) -- Output --In Python3 4 -- Enjoy Please add a comment(s) if you have one or multiple solutions in mind. Thank You. Pawan Khowal Pawan is a Data Engineer. If you need any help in writing code/puzzle ..read more
Improving my SQL BI Skills
by Pawan Kumar Khowal
2y ago
Python | How would you delete duplicates in a list In this puzzle you have to delete duplicate records from an array on Ints Sample Input List -- a = [1, 1, 1, 2, 2] -- Output -- [1, 2] -- Solution -- a = [1, 1, 1, 2, 2] b = [] for i in a: if i not in b: b.append(i) print (b) -- Output --In Python3 [1, 2] -- Enjoy Please add a comment(s) if you have one or multiple solutions in mind. Thank You. Pawan Khowal Pawan is a Data Engineer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Me ..read more
Improving my SQL BI Skills
by Pawan Kumar Khowal
2y ago
Python | Print elements from odd positions in a list In this puzzle you have to print elements from odd positions in a list Sample Input List -- [10,3,14,15,17] -- Output -- [3, 15] -- Solution -- a = [10,3,14,15,17] b = [] for i in range(0, len(a)): if i % 2 != 0: b.append(a[i]) print(b) -- Output --In Python3 [3, 15] -- Enjoy Please add a comment(s) if you have one or multiple solutions in mind. Thank You. Pawan Khowal Pawan is a Data Engineer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gm ..read more
Improving my SQL BI Skills
by Pawan Kumar Khowal
2y ago
Python | How to sort an array in ascending order In this puzzle you have to sort an array in ascending order Sample Input List -- a = [1,3,4,5,10,8,19] -- Output -- [1, 3, 4, 5, 8, 10, 19] -- Solution -- a = [1,3,4,5,10,8,19] for i in range(0 , len(a)): key = i for j in range(i+1, len(a)): if a[key] > a[j]: key = j a[i],a[key] = a[key],a[i] print(a) -- Output --In Python3 [1, 3, 4, 5, 8, 10, 19] -- Enjoy Please add a comment(s) if you have one or multiple solutions in mind. Thank You. Pawan Khow ..read more
Improving my SQL BI Skills
by Pawan Kumar Khowal
2y ago
Python | How to convert a number into a list of its digits In this puzzle you have to convert an INT value to a list of digits Sample Input List -- a = 123 -- Output -- [1, 2, 3] -- Solution -- a = 123 k = str(a) b = [] for i in range ( 0 , len(k) ): b.append(int(k[i])) print(b) -- Output --In Python3 [1, 2, 3] -- Enjoy Please add a comment(s) if you have one or multiple solutions in mind. Thank You. Pawan Khowal Pawan is a Data Engineer. If you need any help in writing code/puzzle or training please email at – pawankkmr”AT”gmail ..read more

OR