Server Side Programming Articles - Page 1721 of 2646

In this tutorial, we are going to learn how to use PostgreSQL with Python. You have to install certain thing before going into the tutorial. Let's install them.Install the PostgreSQL with the guide..Install the Python module psycopg2 for PostgreSQL connection and working. Run the command to install it.pip install psycopg2Now, open the pgAdmin. And create a sample database. Next, follow the below steps to get started with database operations.Import the psycopg2 module.Store the database name, username, and password in separate variables.Make a connection to the database using psycopg2.connect(database=name, user=name, password=password) method.Instantiate a cursor object to execute SQL commands.Create queries and ... Read More

In this tutorial, we are going to see different ways to copy a nested list in Python. Let's see one by one.First, we will copy the nested list using loops. And it's the most common way.Example Live Demo# initializing a list nested_list = [[1, 2], [3, 4], [5, 6, 7]] # empty list copy = [] for sub_list in nested_list:    # temporary list    temp = []    # iterating over the sub_list    for element in sub_list:       # appending the element to temp list       temp.append(element)    # appending the temp list to copy ... Read More

In this tutorial, we are going to find the indices of the numbers that are greater than the given number K. Let's see the different ways to find them.A most common way to solve the problem is using the loops. Let's see the steps to solve the problem.Initialize the list and K.Iterate over the list using its length.If you find any number greater than K, then print the current index.Example Live Demo# initializing the list and K numbers = [3, 4, 5, 23, 12, 10, 16] K = 10 # iterating over thAe list for i in range(len(numbers)):    # checking ... Read More

In this tutorial, we are going to write a program that finds the index of a sublist element from the list. Let's see an example to understand it clearly.Inputnested_list = [[1, 2, 3], [4, 5], [6, 7, 8, 9]]OutputIndex of 7:- 2 Index of 5:- 1 Index of 3:- 0Let's see the simple and most common way to solve the given problem. Follow the given steps solve it.Initialize the list.Iterate over the list using the index.Iterate over the sub list and check the element that you want to find the index.If we find the element then print and break itExample Live ... Read More

In this tutorial, we are going to write a program that cyclically iterates a list from the given Let's see the steps to solve the problemInitialize the list and index.Find the length of the list using len.Iterate over the list using the length.Find the index of the element using index % length.Print the element.Increment the index.It's a simple loop iteration. You can write it without any trouble. Let's see the code.Example Live Demo# initializing the list and index alphabets = ['a', 'b', 'c', 'd', 'e', 'f', 'g', 'h'] start_index = 5 # finding the length length = len(alphabets) # iterating over ... Read More

In this tutorial, we are going to see how to sort a list of strings. We'll sort the given list of strings with sort method and sorted function. And then we'll see how to sort the list of strings based on different criteria like length, value, etc., Let's see how to sort a list of strings using list.sort() method. The sort method list is an insort. It'll directly sort the original list. Let's see the code.Example Live Demo# list of strings strings = ['Python', 'C', 'Java', 'Javascript', 'React', 'Django', 'Spring'] # sorting the list in ascending order strings.sort() # printing the ... Read More

In this tutorial, we are going to learn about the holidays library. The holidays library will help to determine whether a particular is a holiday or not in different countries. We can only see the public holidays.Let's install the module with the following command.pip install holidaysAfter successfully installing the module follow the ways to see get the holidays information. see the holidays of India in the year 2020. You have to follow the below steps to get a complete list of holidays for India in 2020.You can find the country codes for the holidays here..Import the holidays' module.Instantiate the holidays.India() ... Read More

In this tutorial, we are going to write a program that groups similar substrings from a list. Let's see an example to understand it more clearly.Inputstrings = ['tutorials-python', 'tutorials-c', 'tutorials-java', 'tutorials-javascript', 'python-1', 'python-2', 'javascript-1']Output[['tutorials-python', 'tutorials-c', 'tutorials-java', 'tutorials-javascript'], ['python-1', 'python-2'], ['javascript-1']]We are going to use the groupby method from itertools module to solve the problem. The groupby method will group all the similar string into an iter object. For the given list we have split the string with - and pass the first part of the string to the groupby method.Let's see the steps involved in solving this problem.Initialize the list ... Read More

In this article, we will learn about iterative Merge sort in Java. Unlike the traditional iterative Merge Sort, the following Java program implements a recursive merge step while dividing the array and an iterative approach for merging. What is merge sort? Merge Sort is a popular sorting algorithm that follows the Divide and Conquer rule. It recursively divides the array into two halves, sorts each half, and then merges them back in a sorted manner.The following are three main steps to perform Merge sort in Java − Divide: The array is split into two halves ... Read More

The easiest way to write text and obtain it as an output is done by using writeLines function and cat function, and the output of these functions are connected with the help fileConn and sink.Example> fileConn writeLines(c("TutorialsPoint", "SIMPLY EASY LEARNING"), fileConn) > close(fileConn)We can do the same and view these files in R as follows −> fileConn writeLines(c(paste("TutorialsPoint", "E-learning"), "2006", "Video Courses", "Tutorials", "Books"), fileConn) > close(fileConn) > file.show("example.txt")Using sink function> sink("example3.txt") > cat("TutorialsPoint", "E-learning") > cat("") > cat("2006") > cat("") > cat("Video Courses") > cat("") > cat("Tutorials") > cat("") > cat("Books") > sink()Using only cat function> cat("TutorialsPoint E-learning", ... Read More