Featured Post

SQL Interview Success: Unlocking the Top 5 Frequently Asked Queries

Image
 Here are the five top commonly asked SQL queries in the interviews. These you can expect in Data Analyst, or, Data Engineer interviews. Top SQL Queries for Interviews 01. Joins The commonly asked question pertains to providing two tables, determining the number of rows that will return on various join types, and the resultant. Table1 -------- id ---- 1 1 2 3 Table2 -------- id ---- 1 3 1 NULL Output ------- Inner join --------------- 5 rows will return The result will be: =============== 1  1 1   1 1   1 1    1 3    3 02. Substring and Concat Here, we need to write an SQL query to make the upper case of the first letter and the small case of the remaining letter. Table1 ------ ename ===== raJu venKat kRIshna Solution: ========== SELECT CONCAT(UPPER(SUBSTRING(name, 1, 1)), LOWER(SUBSTRING(name, 2))) AS capitalized_name FROM Table1; 03. Case statement SQL Query ========= SELECT Code1, Code2,      CASE         WHEN Code1 = 'A' AND Code2 = 'AA' THEN "A" | "A

Python Function: How to Write Error Logic

Here's an example python user-defined function. Here, you'll know how to write error conditions. The best examples is if and else. I have shared the logic here for your reference.

Python
is one of the top programming languages. Python does support Functions. While writing functions you also need to consider some errors. Those are called exceptions. I am explaining how to give error logic in a function of Python.


Python function error logic

Exception-handling means to have logic for error scenarios. Writing exception I will show in a simple Function.

In this post I will give you syntax for writing function and exception. 

Here is my simple Function that multiplies two numbers.

Logic to write Function in Python to Multiply Two Numbers 

def product (num1,num2):
prod=num1*num2
print( ' The product of the numbers is \t:
'+str(prod)

Parameters used the Python Function
  • The 'def' means you are defining function with a name of 'product'.
  • In the parameters of 'product', you can see TWO variables. Those are to take input from the user for multiplication.
  • prod=num1*num2. That means product of two numbers assigning to 'prod' variable. 
  • Python is dynamic language and you no need to define variables explicitly.
  • Print command displays your result to the terminal or console. 
  • The '\t' tells 'space' between comment and the result.
How Python Function works

How to write error logic in Python Function

In the below code when you supply other than numeric, it sends an error message.

def product(num1,num2):
prod=num1*num2
If num1 or num2 in [ 0,1,2,3,4,5,6,7,8,9]
     print( prints value)
elif
    print( error)

Now, you are good to write functions and exceptions.

References

Comments

Popular posts from this blog

How to Fix datetime Import Error in Python Quickly

Explained Ideal Structure of Python Class

How to Check Kafka Available Brokers