Posts

Showing posts with the label remove duplicates

Featured Post

How to Read a CSV File from Amazon S3 Using Python (With Headers and Rows Displayed)

-
Image
  Introduction If you’re working with cloud data, especially on AWS, chances are you’ll encounter data stored in CSV files inside an Amazon S3 bucket . Whether you're building a data pipeline or a quick analysis tool, reading data directly from S3 in Python is a fast, reliable, and scalable way to get started. In this blog post, we’ll walk through: Setting up access to S3 Reading a CSV file using Python and Boto3 Displaying headers and rows Tips to handle larger datasets Let’s jump in! What You’ll Need An AWS account An S3 bucket with a CSV file uploaded AWS credentials (access key and secret key) Python 3.x installed boto3 and pandas libraries installed (you can install them via pip) pip install boto3 pandas Step-by-Step: Read CSV from S3 Let’s say your S3 bucket is named my-data-bucket , and your CSV file is sample-data/employees.csv . ✅ Step 1: Import Required Libraries import boto3 import pandas as pd from io import StringIO boto3 is...
Post a Comment
Read more

These Tips Helpful to Remove Python List and Dictionary Duplicates

-
Image
In this post, I have shared top ideas to remove duplicates from the list. Those are with Append and Dictionary. 1. How to Remove Duplicates with Append # Here is a list with duplicates list_with_duplicates = [1,2,3,12,1,2,3,4,5,6,1,2,3,7,8,9] It is simple if you follow the first-approach - brute force approach: list_without_duplicates = [] for pd in list_with_duplicates:   if pd not in list_without_duplicates:       list_without_duplicates.append(pd) print(list_without_duplicates) Result: [1, 2, 3, 12, 4, 5, 6, 7, 8, 9] This method has performance issues when the list is bigger in size.  Real-time. 2. How to Remove Duplicates with Dictionary # Here is you can convert a list to a dictionary dict_without_duplicates = dict(zip(list_with_duplicates, list_with_duplicates)) print(dictionary_without_duplicates) Result: {1: 1, 2: 2, 3: 3, 12: 12, 4: 4, 5: 5, 6: 6, 7: 7, 8: 8, 9: 9} Real-time. Once again, this works and has the advantage of taking less space than duplic...
Post a Comment
Read more