Scribd
Upload
9 views5 pages

BILab3 71 CSE-B

The document outlines a series of data manipulation tasks including replacing parts of email addresses, adding date-related columns, filtering data for a specific year, adjusting product prices, and creating new columns based on existing data. Key tasks involve extracting usernames, rounding product prices, and categorizing prices into bands. The overall focus is on transforming and analyzing a dataset for better insights.

Uploaded by

Gaikwad Aditya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
9 views5 pages

BILab3 71 CSE-B

The document outlines a series of data manipulation tasks including replacing parts of email addresses, adding date-related columns, filtering data for a specific year, adjusting product prices, and creating new columns based on existing data. Key tasks involve extracting usernames, rounding product prices, and categorizing prices into bands. The overall focus is on transforming and analyzing a dataset for better insights.

Uploaded by

Gaikwad Aditya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 5

1: Replace @example to @gmail in email address

2: Add Year, Month, and Day columns derived from Date


3: Create YearMonth column as text (YYYY-MM) from Date

4: Filter rows to keep only date in year 2025


5:Increase Product Price by 10%

6: Extract username (before @) from Email ID into new column 'Username'

7.Product Price (Round)


8.Full Name
9.Create 'Price_Band' as Low/Medium/High based on thresholds (<=500 /
<=1500 / else)

10.

You might also like