Daily Archives: October 26, 2020

Python | Check a character is present in a string or not

26 Monday Oct 2020

Posted by in Python

≈ Leave a comment

Tags

, , , ,


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 writing code/puzzle or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go through the top pages of his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Python | Check whether a string is palindrome or not

26 Monday Oct 2020

Posted by in Python

≈ Leave a comment

Tags

, , ,


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 – pawankkmr”AT”gmail.com. Meanwhile please go through the top pages of his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Python | Find the missing number in the array of Ints

26 Monday Oct 2020

Posted by in Python

≈ Leave a comment

Tags

, , ,


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 or training please email at – pawankkmr”AT”gmail.com. Meanwhile please go through the top pages of his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Python | How would you delete duplicates in a list

26 Monday Oct 2020

Posted by in Python

≈ Leave a comment

Tags

, , ,


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. Meanwhile please go through the top pages of his blog.

Page Detail URL
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com

Python | Check whether an array is Monotonic or not

26 Monday Oct 2020

Posted by in Python

≈ Leave a comment

Tags

, , ,


Python | Check whether an array is Monotonic or not

In this puzzle you have to check whether an array is Monotonic or not

Sample Input List

--

a = [1,2,3,9,5,6,7]

--

Output

--

N

--

Solution

--

a = [1,2,3,9,5,6,7]

if  (
        all(a[i] <= a[i+1] for i in range(len(a)-1)) 
        or
        all(a[i] >= a[i+1] for i in range(len(a)-1))    
    ):
    print("M")
else:
    print("N")


--

Output

--In Python3

N

--

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. Meanwhile please go through the top pages of his blog.

Page Detail URL
☛ Python Puzzles https://msbiskills.com/list-of-python-coding-interview-puzzles/
☛ SQL Advance Puzzles https://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
☛ SQL Tricky Queries https://msbiskills.com/sql-puzzles-finding-outputs/
☛ SQL Server Perfomance tuning Articles https://msbiskills.com/sql-performance-tuning/
☛ SQL Server Articles https://msbiskills.com/t-sql/
☛ SQL Interview Questions & Answers https://msbiskills.com/sql-server-interview-questions/

My SQL Groups on Facebook:

1. If you like this post, you may want to join my SQL SERVER Interview Puzzles/Interview Questions on Facebook: https://www.facebook.com/groups/1430882120556342/

2. If you like this post, you may want to join my SQL Server Puzzles on Facebook:
https://www.facebook.com/groups/206594023090781/

My SQL Page on Facebook:

2. For all the updates you may follow my page -> https://www.facebook.com/MSBISkillscom-1602779883299222/

Enjoy !!! Keep Learning

Http://MsbiSkills.com