Excel uses a special format to store dates and times, called serial date numbers. Serial date numbers are a count of days since January 1, 1899, which is the date that Excel considers to be the beginning of time. Python's datetime module provides powerful tools for working with dates and times. However, when it comes to interoperability with other applications, such as Microsoft Excel, we often encounter the need to convert Python datetime objects into Excel's serial date number format. In this article, we will explore how to perform this conversion and bridge the gap between Python and Excel. Understanding ... Read More

Arrays are fundamental data structures in programming, enabling us to store and manipulate collections of values efficiently. Python, as a versatile programming language, provides numerous tools and libraries for working with arrays and matrices. In particular, the ability to convert 1−D arrays into 2−D arrays is an essential skill when dealing with tabular data or performing operations requiring a two−dimensional structure. In this article, we will explore the process of converting 1−D arrays into columns of a 2−D array using Python. We will cover various methods, ranging from manual manipulation to leveraging powerful libraries such as NumPy. Whether you are ... Read More

When working with data in Python, it is often necessary to transform and manipulate arrays to facilitate analysis and computations. One common scenario is converting a 1D array of tuples into a 2D Numpy array. This conversion allows for easier indexing, slicing, and applying array operations. In this article, our focus will be on the conversion process of transforming a 1D array of tuples into a Numpy array. 1D Array of Tuple A 1D array of tuples refers to a data structure in which tuples are arranged sequentially in a one−dimensional array. For example, consider the following 1D array of ... Read More

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