Don't worry. Not everyone knows it...

Using conditionals or say IF-ELSE statement is quite common when developing any application and based on the programming language, the syntax to handle such conditionals varies but the underline concept remains the same. In this article, I’ll show you how to write an IF statement in Python to check if a given item is present in the collection or not. Have a look at the traditional way to achieve the same: fruits = [‘apple’,’orange’,’banana’,’mango’] fruit = ‘mango’ if (fruit==’apple’ or fruit==’orange’ or fruit==’banana’ or fruit==’mango’): print (‘Found the fruit’) In the above snippet, we have a collection holding multiple fruits and a variable holding one fruit. The idea here is to check whether the given fruit exists in the collection or not.  There is no problem with the above code but we do have a way to optimize it and by optimizing the code, we can achieve the below benefits: less number of lines of code less error prone no need to change code, if more items are added

Python is nowadays a very common language to use, especially when you want to automate something. Hence, we will go with Python to automate our today’s flow wherein we will generate a pivot table using Python and then we will save it back to Microsoft Excel. Input Data I’m considering CSV file as an input, which holds multiple columns as shown in the below sample: Scenario Let’s consider a scenario, wherein we want to generate a pivot table which depicts the interest of students based on the residence. For example, say you want to know how many students are falling under Uncertain category from Rural, then pivot table should be able to provide us with this data. Generating Pivot Table The very first thing we need to do is to grab the CSV data and bring it into the memory, so that we can perform operations on it. Yes, you guessed it right. We can go for a pandas data frame. Once data is available in a data frame, we can filter out the required columns and start our pivoting process.  He

Whenever we think about automating something, there are many questions which come to our mind. Like, How will we schedule it? How many times we want to execute it? Is it possible to automate this scheduling part? Well, in this article I’m going to walk you through all those various steps which are required to schedule a Python script on Windows. Step 1: Prepare The Python script Automation begins with the piece of code which will automate something. So, the first step here is to get ready with a Python script which must be in working condition. There is no constraint on how big or small a script has to be, but we need to make sure that the script is doing what it is intended to do. Step 2: Create An Executable Once the script is verified, we need to create an executable or EXE file as this executable file we are going to schedule in our next step. In order to create an executable in Python, we need to install a package named pyinstaller using pip: pip install pyinstaller Once the packa

In this article, I’ll show you those two lines of Python code, using which you can print calendar of any year. Required Package The pre-requisite to generate calendar is to import the required package named calendar as shown below: from calendar import * Generate Calendar Now to generate a calendar, we need to call constructor and pass in four parameters as shown below: print(calendar(2018,2,1,4)) Here, 2018 is the year for which calendar will be printed 2 signifies width of each character 1 signifies number of lines per week 4 signifies column separation value You can adjust the last three parameters for better spacing in between the text. Output This is how the calendar looks like: I hope you enjoyed generating a calendar of your choice. Make sure to check out my recording explaining each and every parameter discussed in this article:

It is quite common to sort a Python dictionary based on key. But what if you want to perform sorting on the value? In this article, I’m going to show you multiple ways to sort dictionary value and then return the resultant dictionary. Method 1: Using operator The very first method to sort dictionary value is by using sorted(…) function along with operator. So, let’s go ahead and do it as shown below: import operator students = {‘Shweta’:25,’Andy’:30,’Maddy’:3} students = sorted(students.items(), key=operator.itemgetter(1)) print (students) Method 2: Using lambda The second method to sort dictionary value is by using sorted(…) function along with lambda and the code looks as shown below: : import operator students = {‘Shweta’:25,’Andy’:30,’Maddy’:3} students = sorted(students.items(), key=lambda stud:stud[1]) print (students) Output On execution of above two methods, you will get exactly same output. I hope you enjoyed sorting your dictionary values in Python. If you have reached t

Before jumping on to what is reduce, let’s have a quick look at the lines  below :  import operator sum = 0 for n in [1,2,3]: sum = sum + n print ( sum ) You got it right. Here we are taking a collection having three numbers and summing them up. As such, there is nothing wrong with this code but, of course there is a big room for optimization with respect to the number of lines of code we have written, just go get summation. Now the question is, how can we optimize? How can we reduce the number of lines and achieve the same result? Well, the answer is reduce function. What is reduce? Reduce is a function in Python provided by functools . This function takes a collection of values, performs some operation by calling a function and then returns a single value as an output. For example, you can give multiple values as input and perform mathematical calculations on them, you can perform operations on multiple strings, etc. Ways to use reduce There are two ways you can use reduce: Way 1

In this article, I’m going to share a scenario wherein we need to get a key from a Python dictionary, which is holding maximum value. Usually we are required to get a key having maximum key from a dictionary, which, of course, most of us can do very easily. But when it comes to the other way round, it is not that straight forward. I also found that this is one of the hottest questions these days for interviewers :) To achieve the scenario of a dictionary key having maximum value, we can go with two different ways as mentioned below: Method 1: Using itemgetter()  import operator students = {'Shweta':25,'Andy':30,'Maddy':3} v = max(students.items(),key=operator.itemgetter(1))[0] print ( v ) Method 2: Using lambda CODE import operator students = {'Shweta':25,'Andy':30,'Maddy':3} v = max(students.items(),key=lambda x:x[1])[0] print (v) You can use any of these methods and you will get the same output. I hope you enjoyed learning this co