Posts

Showing posts with the label logic

Featured Post

Mastering flat_map in Python with List Comprehension

Image
Introduction In Python, when working with nested lists or iterables, one common challenge is flattening them into a single list while applying transformations. Many programming languages provide a built-in flatMap function, but Python does not have an explicit flat_map method. However, Python’s powerful list comprehensions offer an elegant way to achieve the same functionality. This article examines implementation behavior using Python’s list comprehensions and other methods. What is flat_map ? Functional programming  flatMap is a combination of map and flatten . It transforms the collection's element and flattens the resulting nested structure into a single sequence. For example, given a list of lists, flat_map applies a function to each sublist and returns a single flattened list. Example in a Functional Programming Language: List(List(1, 2), List(3, 4)).flatMap(x => x.map(_ * 2)) // Output: List(2, 4, 6, 8) Implementing flat_map in Python Using List Comprehension Python’...

How to Write ETL Logic in Python: Sample Code to Practice

Image
Here's an example Python code that uses the mysql-connector library to connect to a MySQL database, extract data from a table, transform it, and load it as a JSON file. Here's an example: Python ETL Sample Code import mysql.connector import json # Connect to the MySQL database cnx = mysql.connector.connect(user='username', password='password',                               host='localhost',                               database='database_name') # Define a cursor to execute SQL queries cursor = cnx.cursor() # Define the SQL query to extract data query = ("SELECT column1, column2, column3 FROM table_name") # Execute the SQL query cursor.execute(query) # Fetch all rows from the result set rows = cursor.fetchall() # Transform the rows into a list of dictionaries result = [] for row in rows:     result.append({'column1': row[0], 'col...

Python: How to Write Logic to Print Triangle

Image
Here's an example to print Triangle in Python. It's the best interview question. You can expect this type of question in your interview. So this is useful to practice it. How to Print Triangle Logic to Print Trianagle max = 8 for x in range(1, max + 1): for y in range(1, x + 1): print y, print Result 1 1 2 1 2 3 1 2 3 4 1 2 3 4 5 1 2 3 4 5 6 1 2 3 4 5 6 7 1 2 3 4 5 6 7 8   Also, Read Python while loop Python for loop example