Assuming that MySQL database named as test is present on server and a table named employee is also created. The table has five fields fname, lname, age, gender, and salary.A tuple object containing data of a record is defined ast1=('Mac', 'Mohan', 20, 'M', 2000)To establish interface between MySQL  and Python 3, you need to install PyMySQL module. Then you can set up the connection using following statementsimport PyMySQL # Open database connection db = PyMySQL.connect("localhost", "root", "", "test" ) # prepare a cursor object using cursor() method cursor = db.cursor()Next step is to set up the insert query using data ... Read More

In Python, a Tuple is an ordered and immutable collection of elements, and tuples are created using parentheses. In this article, we are going to explore all the different ways to use a tuple within a tuple. Tuple within a Tuple in Python A tuple can contain elements of any data type, such as another tuple. When one tuple is placed inside another tuple, it is called a nested tuple or a tuple within a tuple. Following is the syntax of creating a Tuple in Python - outer_tuple = (value1, value2, (nested_value1, nested_value2), value3) Note: We can access ... Read More

A Dictionary is a set of key-value pairs, and each key in a Dictionary is separated from its value by a colon ":"; the items are separated by commas. They do not allow duplicate values. Since the 3.7 Python update, dictionaries are ordered. The correct syntax to create a Python Dictionary is to store values in the form of key-value pairs within the curly braces "{ }". On the left of the colon, we store keys, and on the right, values. The keys should be unique (within one dictionary), and we need to separate the items using commas. Basic ... Read More

In Python, a list is a built-in data structure that is used to store a sequence of items. Lists are mutable, i.e., the elements can be changed after the list is created. Syntax to create a Python List The correct syntax to create a Python List is using square brackets "[ ]". We need to specify the elements in the list by separating them with commas. Here is the basic syntax to create a list in Python - my_list = [item1, item2, item3, ...] Example: List of Integers A list of integers in Python is a sequence of whole numbers ... Read More

A Nested dictionary is a dictionary inside another dictionary. In Python, we have the function len() to count elements in a Nested Dictionary. With that, we can also use a function that recursively calls and calculates the elements in an arbitrary depth of the nested dictionary. Non-Recursive Count in Nested Dictionary A non-recursive count in a nested dictionary means counting only the keys at the top level, without going into any nested dictionaries inside it. Here is an example of counting the elements in a nested python dictionary- # Define a nested dictionary nested_dict = { ... Read More

Truncating a dictionary in Python means limiting it to a fixed number of key-value pairs. From version Python 3.7 onwards, the dictionaries store the values based on the insertion order, which makes it easy to slice and rebuild a smaller dictionary using the first N items. This is helpful when we want to reduce data size or process only a portion of the dictionary. In this article, we are going to explore the different methods to truncate a Python dictionary at a given length. Using itertools.islice() Method The itertools.islice() method in Python is used to truncate a dictionary by slicing ... Read More

A dictionary in Python is a mutable, unordered collection of key-value pairs.Inserting keys/values into a Python dictionaryWe can add new key-value pairs to an existing dictionary simply by assigning a value to a new key. In this article, we are going to explore the different ways to insert new key values into a Python dictionary. Following is an example, which creates a dictionary with 4 key-value pairs and displays the dictionary - # Creating a Dictionary with 4 key-value pairs myprod = { "Product":"Mobile", "Model": "XUT", "Units": 120, "Available": "Yes" } # Displaying the Dictionary print(myprod) # Displaying ... Read More

In Python, a Dictionary is one of the data structures that contains key-value pairs enclosed in curly braces '{}'. It is a Mutable and ordered data structure. Before proceeding with updating the values of a dictionary, let's create an example Dictionary with 4 key-value pairs, in which Product, Model, Units, are keys of the Dictionary - # Creating a Dictionary with 4 key-value pairs myprod = { "Product":"Mobile", "Model": "XUT", "Units": 120, "Available": "Yes" } # Displaying the Dictionary print(myprod) # Displaying individual values ... Read More

A Dictionary in Python is a mutable, unordered collection of data in a key-value format. A dictionary can also contain another dictionary as a value and this is known as a Nested Dictionary or a dictionary within a dictionary. When working with this type of data structure, it’s often important to go through each key-value pair at every level. In this article, we will explore how to recursively iterate through a nested Python dictionary using a function-based approach. Syntax to iterate through a Dictionary recursively Following is a sample syntax for recursively iterating through a nested dictionary - def recursive_iter(d): ... Read More

A non-whitespace character is any character that is not a space, tab i.e., \t, newline i.e., or carriage return \r. Examples of non-whitespace characters such as letters, digits, punctuation and special symbols. In Python, Regular Expressions (RegEx) are used to match the patterns in the given input strings. The re module in Python provides different methods to use the regular expressions. This module helps the developers to perform search operations, validations, filtering and much more based on string patterns. To match a non-whitespace character in Python we can use the special character class \S inside a raw string in any ... Read More