SQLite is a popular, lightweight, and self−contained database engine that is widely used in various applications. One of the unique features of SQLite is its ability to create databases in memory, which allows for faster data access and manipulation. In this article, we will explore how to connect to an in−memory SQLite database using Python, providing step−by−step instructions, code examples, explanations, and sample outputs. Understanding SQLite In−Memory Databases An SQLite in−memory database is a temporary database that resides entirely in memory instead of being stored on disk. This type of database is useful for scenarios where data needs to be ... Read More

Pandas is a powerful data manipulation library widely used in Python for data analysis and preprocessing tasks. When working with data, it is common to encounter situations where dates and times are represented as floating−point numbers instead of the expected datetime format. In such cases, it becomes essential to convert the float values to datetime objects to perform accurate time−based analysis. This article aims to provide a comprehensive guide on how to convert float values to datetime objects in a Pandas DataFrame. Understanding the importance of converting float to datetime Datetime objects offer several advantages over float representations of dates ... Read More

JSON (JavaScript Object Notation) is a popular format for data exchange between systems. It is a lightweight, text−based, and easy−to−parse format that has become a standard for data exchange over the internet. However, JSON does not provide any order for the elements in the data structure. While this may not be an issue in most cases, there are situations where the order of the elements is important. On the other hand, OrderedDict is a subclass of the built−in dict class in Python, which maintains the order of the keys in the dictionary. The order is determined by the order in ... Read More

In this Go language article, we will write programs that take in list of weights and values for items and a maximum weight capacity for knapsack. Knapsack problem is an optimization problem that uses dynamic programming. Here, the purpose is to find out the set of items that can be included in the knapsack without exceeding its weight capacity or maximum weight. Dynamic programming involves solving of problems by breaking them down into smaller subproblems and them combining them to get an optimal solution. Syntax func make ([] type, size, capacity) The make function in go language ... Read More

In this Go language article, we will write programs that take in a slice of integers and an anonymous function that filters each element in the slice. An anonymous function is the function which uses no function name and is called by the variable which is assigned to it. It is used generally used with event listeners. Here, Filter function will be created with the anonymous functions to filter the values from slice. Syntax func append(slice, element_1, element_2…, element_N) []T The append function is used to add values to an array slice. It takes number of arguments. The first ... Read More

In this article, we will write Go language programs that take in a slice of integers and an anonymous function that maps each element in the slice to a new value. An anonymous function is declared without a name and is assigned to a variable which is called to execute the process. Syntax func make ([] type, size, capacity) The make function in go language is used to create an array/map it accepts the type of variable to be created, its size and capacity as arguments. func range(variable) The range function is used to iterate over any data ... Read More

In this article, we will write a Go language program to print the numbers from 1 to 100 concurrently with each number printed by a separate go routine. Concurrency means execution of multiple tasks parallelly and independently and making sure all the resources of the system are utilized. It can be achieved via go routines which are light weight threads and the channels. Syntax func make ([] type, size, capacity) The make function in go language is used to create an array/map it accepts the type of variable to be created, its size and capacity as arguments. Algorithm ... Read More

In this Go language article, we will write programs to take in a slice of integers and compute their sum using concurrency. Concurrency helps multiple tasks or operations to be performed simultaneously. It helps make efficient use of system resources. It is achieved using Go routines which are light-weight threads and channels which helps in the communication between the go routines. Syntax func make ([] type, size, capacity) The make function in go language is used to create an array/map it accepts the type of variable to be created, its size and capacity as arguments. func range(variable) The ... Read More

In this article, we will write Go language programs to sort a slice of integers using merge sort with concurrency. It is a process which makes the parts of a program run independently and parallelly enhancing the efficiency of the program. Go routines and channels are used to execute concurrency. Merge sort is a divide and conquer algorithm used to sort the unsorted array or slice by dividing the input slice into smaller sub-slices, individually sort them recursively and then merge them into a single slice which is sorted. Syntax func make ([] type, size, capacity) The make function ... Read More

In this article, we will write Go language programs to compute the factorial of a number using concurrency. It is a task of implementing multiple operations simultaneously and can be implemented using Go routines and channels. Go routines are the lightweight threads and channels help in non-conflicting communications between the routines. Syntax func make ([] type, size, capacity) The make function in go language is used to create an array/map it accepts the type of variable to be created, its size and capacity as arguments. Algorithm This program imports the necessary packages main and fmt. In this ... Read More