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...

Python Set Operations Explained: From Theory to Real-Time Applications

set in Python is an unordered collection of unique elements. It is useful when storing distinct values and performing operations like union, intersection, or difference.

Python Set Operations



Real-Time Example: Removing Duplicate Customer Emails in a Marketing Campaign

Imagine you are working on an email marketing campaign for your company. You have a list of customer emails, but some are duplicated. Using a set, you can remove duplicates efficiently before sending emails.

Code Example:


# List of customer emails (some duplicates) customer_emails = [ "alice@example.com", "bob@example.com", "charlie@example.com", "alice@example.com", "david@example.com", "bob@example.com" ] # Convert list to a set to remove duplicates unique_emails = set(customer_emails) # Convert back to a list (if needed) unique_email_list = list(unique_emails) # Print the unique emails print("Unique customer emails:", unique_email_list)

Output:


Unique customer emails: ['alice@example.com', 'david@example.com', 'charlie@example.com', 'bob@example.com']

(Note: The order may vary because sets are unordered.)


Why Use Sets Here?

  1. Fast duplicate removal – Converting a list to a set automatically removes duplicates.
  2. Efficient lookup – Checking if an email exists is faster in a set (O(1) time complexity).
  3. Simpler code – No need for loops or conditional checks to remove duplicates manually.

Comments

Popular posts from this blog

SQL Query: 3 Methods for Calculating Cumulative SUM

5 SQL Queries That Popularly Used in Data Analysis

Big Data: Top Cloud Computing Interview Questions (1 of 4)