Improving my SQL BI Skills

1000 FOLLOWERS

Blog by Pawan Kumar Khowal. T-SQL, SQL Server, MDX, DAX Specialist, Reporting Services (SSRS), Integration Services, Analysis Services (SSAS), Tabular Model.

Improving my SQL BI Skills

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

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

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

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

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

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

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

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

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

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