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 Regex: The 5 Exclusive Examples

 Regular expressions (regex) are powerful tools for pattern matching and text manipulation in Python. Here are five Python regex examples with explanations:


Regular expression examples


01 Matching a Simple Pattern


import re


text = "Hello, World!"

pattern = r"Hello"

result = re.search(pattern, text)

if result:

    print("Pattern found:", result.group())

Output:


Output:

Pattern found: Hello

This example searches for the pattern "Hello" in the text and prints it when found.


02 Matching Multiple Patterns


import re


text = "The quick brown fox jumps over the lazy dog."

patterns = [r"fox", r"dog"]

for pattern in patterns:

    if re.search(pattern, text):

        print(f"Pattern '{pattern}' found.")

Output:


Pattern 'fox' found.

Pattern 'dog' found.

It searches for both "fox" and "dog" patterns in the text and prints when they are found.


03 Matching Any Digit

 

import re


text = "The price of the product is $99.99."

pattern = r"\d+"

result = re.search(pattern, text)

if result:

    print("Price:", result.group())

Output:


Price: 99

This example extracts digits (numbers) from the text.


04 Matching Email Addresses


import re


text = "Contact us at support@example.com or info@example.org."

pattern = r"\b[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Z|a-z]{2,7}\b"

emails = re.findall(pattern, text)

for email in emails:

    print("Email:", email)

Output:

Email: support@example.com

Email: info@example.org

It extracts email addresses from the text using a common email pattern.


05. Replacing Text

 

import re

text = "Please visit our website at http://www.example.com."

pattern = r"http://www\.[A-Za-z]+\.[A-Za-z]+"

replacement = "https://www.example.com"

updated_text = re.sub(pattern, replacement, text)

print("Updated Text:", updated_text)

Output:

Updated Text: Please visit our website at https://www.example.com.

This example replaces a URL with a different URL in the text.


These are just a few examples of what you can do with regular expressions in Python. Regex is a versatile tool for text processing, and you can create complex patterns to match specific text structures or extract information from text data.

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)