Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Programming Articles
Page 396 of 2547
Remove Tuples from the List having every element as None in Python
When working with lists of tuples, you may need to remove tuples where every element is None. This is different from removing tuples that contain any None values. Python provides several approaches to filter out tuples containing only None elements. Using List Comprehension with all() The most efficient approach uses list comprehension with the all() function to check if every element in a tuple is None − my_list = [(2, None, 12), (None, None, None), (23, 64), (121, 13), (None, ), (None, 45, 6)] print("The list is :") print(my_list) my_result = [sub for sub ...
Read MoreHow to use Boto3 to to paginate through all databases present in AWS Glue
In this article, we will see how to paginate through all databases present in AWS Glue using the boto3 library in Python. Problem Statement Use boto3 library in Python to paginate through all databases from AWS Glue Data Catalog that is created in your account. Pagination Parameters The pagination function uses three important parameters: max_items − denotes the total number of records to return. If the number of available records is greater than max_items, then a NextToken will be provided in the response to resume pagination. page_size − denotes the size of each page. ...
Read MoreTrim tuples by N elements in Python
When working with lists of tuples, you might need to remove a specific number of elements from the beginning or end. Python provides several approaches to trim tuples by N elements. Using del Operator The del operator removes elements at a specific index ? my_list = [(1, 2, 11), (99, 76, 34, 89), (3.08, 11.56), ("Hi", "Will"), ("Rob", "Ron")] n = 2 print("Original list:") print(my_list) print(f"Removing element at index {n}") del my_list[n] print("List after deletion:") print(my_list) Original list: [(1, 2, 11), (99, 76, 34, 89), (3.08, 11.56), ('Hi', 'Will'), ('Rob', ...
Read MoreHow to use Boto3 to paginate through all crawlers present in AWS Glue
In this article, we will explore how to use Boto3 to paginate through all AWS Glue crawlers in your account efficiently. Overview AWS Glue crawlers can be numerous in large accounts. Using pagination allows you to retrieve crawler information in manageable chunks, preventing timeouts and memory issues. Parameters The pagination function accepts three key parameters − max_items − Total number of records to return. If more records exist, a NextToken is provided for continuation. page_size − Number of crawlers per page/batch. starting_token − Token from previous response to continue pagination from a specific point. ...
Read MoreChange command Method for Tkinter Button in Python
The Button widget in Tkinter is crucial for handling events and performing operations in GUI applications. Sometimes you need to change what a button does after it's been created and displayed. To change a button's command method after initialization, use the configure() method. This allows you to reassign the button's functionality dynamically during program execution. Syntax button.configure(command=new_function) Example Here's a complete example showing how to change a button's command method ? # Import tkinter library from tkinter import * # Create an instance of tkinter frame win = Tk() ...
Read MoreFind number of times every day occurs in a Year in Python
When working with calendar calculations, you might need to find how many times each day of the week occurs in a given month. This is useful for scheduling, payroll calculations, or planning recurring events. Understanding the Problem In any month, most days occur either 4 or 5 times. For a month with n days starting on a specific day, we need to calculate the frequency of each weekday. Algorithm Approach The solution works by: Starting with a base count of 4 for each day (since 4 × 7 = 28 days) Adding the extra ...
Read MoreHow to use Boto3 to update the details of a workflow in AWS Glue Catalog
In this article, we will see how to update the details of a workflow in AWS Glue Catalog using the boto3 library in Python. What is AWS Glue Workflow? An AWS Glue workflow is a visual representation of a multi-job ETL process. You can use workflows to design complex ETL operations that involve multiple crawlers, jobs, and triggers. The update_workflow function allows you to modify workflow properties like description and default run properties. Problem Statement Use boto3 library in Python to update details of a workflow that is created in your AWS Glue account. Required ...
Read MoreHow to use Boto3 to update the scheduler of a crawler in AWS Glue Data Catalog
In this article, we will see how to update the scheduler of a crawler in AWS Glue Data Catalog using the boto3 library in Python. Problem Statement Use boto3 library in Python to update the scheduler of an existing crawler in AWS Glue. Prerequisites Before implementing the solution, ensure you have: AWS credentials configured (via AWS CLI, IAM roles, or environment variables) boto3 library installed: pip install boto3 Proper IAM permissions for Glue operations Approach to Update Crawler Schedule ...
Read MoreHow to use Boto3 to remove tags from AWS Glue Resources
In this article, we will see how to remove tags from AWS Glue Resources using the boto3 library. AWS Glue resources can have tags for organization and cost tracking, and sometimes you need to remove specific tags programmatically. Problem Statement Use boto3 library in Python to remove tags from AWS Glue Resources like databases, tables, crawlers, and jobs. Required Parameters The untag_resource function requires two main parameters: resource_arn − The Amazon Resource Name (ARN) of the Glue resource tags_list − List of tag keys to remove ...
Read MoreHow to use Boto3 to get tags from an AWS Glue Resources
In this article, we will see how to get the tags associated with AWS Glue Resources using the boto3 library in Python. Tags help organize and manage AWS resources by assigning key-value pairs for identification and billing purposes. AWS Glue Resource ARN Formats The resource_arn parameter requires a specific format depending on the resource type ? Resource Type ARN Format Catalog arn:aws:glue:region:account-id:catalog Database arn:aws:glue:region:account-id:database/database-name Table arn:aws:glue:region:account-id:table/database-name/table-name Connection arn:aws:glue:region:account-id:connection/connection-name Crawler arn:aws:glue:region:account-id:crawler/crawler-name Job arn:aws:glue:region:account-id:job/job-name Trigger arn:aws:glue:region:account-id:trigger/trigger-name Implementation Steps Follow ...
Read More