Task 1.1: Warmup
CSV data processing with DuckDB - Namecheap Premium Domains
Task Overview: Premium Domain Analytics
In this task, we’ll do a warmup exercise to get you familiar with DuckDB. You’ll analyze premium domains sold on Namecheap’s marketplace using DuckDB. You’ll work with CSV data containing domain availability information.Learning Objectives
- Load and explore CSV data with DuckDB
- Analyze domain sales patterns and pricing
- Create aggregations and insights
- Find interesting cheap domain names
Data Overview
Understanding the Namecheap Dataset
The Namecheap Market Sales dataset contains domain sales information: Dataset:Namecheap_Market_Sales_Buy_Now.csv
Data Fields:
- permalink: Full URL to the domain listing on Namecheap marketplace
- domain: The actual domain name (e.g., buythisdomain.com)
- price: Sale price of the domain in USD (e.g., 10000.00)
- extensions_taken: Number of domain extensions taken (e.g., .com, .net, .org)
Data Structure
The CSV file has the following structure:Getting Started with CSV Data
Query and Explore the Dataset
Start by querying and exploring the CSV data.Hint: Basic Exploration
Hint: Basic Exploration
Basic Data Quality Check
Check for any obvious data quality issues.Hint: Data Quality Check
Hint: Data Quality Check
Basic Price Analysis
Check the price ranges of the domains.Hint: Price Analysis
Hint: Price Analysis
Domain Analysis Tasks
Find Short Domain Names
Find domains that are 8 characters or less.Hint: String Length Function
Hint: String Length Function
Find Cheap Domains
Find domains that cost less than $100.Hint: Price Filtering
Hint: Price Filtering
Find .co Domains
Find domains that contain the ‘.co’ extension.Hint: String Contains Function
Hint: String Contains Function
Find Domains Without Hyphens
Find domains that don’t contain hyphens.Hint: Regex Pattern Matching
Hint: Regex Pattern Matching
Find Domains Without Numbers
Find domains that don’t contain any digits.Hint: Regex for Digits
Hint: Regex for Digits
Final Challenge
Find Short and Cheap Domains
Combine the conditions from previous tasks to find short, cheap domains: Your task: Find domains that are:- Less than 9 characters long
- Under $100
- Contain the ‘.co’ domain extension
- Don’t have hyphens
- Don’t have numbers
- Order by price (cheapest first)
Hint: Combining Multiple Conditions
Hint: Combining Multiple Conditions
Now Write Your Own Query
Write your own query to find the best cheap and short domain names. Pick any price, domain length, and domain extension. Write down the top 3 domains you found.Task 1.1 Summary
Congratulations! You’ve completed the domain analysis warmup. You’ve learned to: ✅ Load and explore CSV data with DuckDB✅ Use string functions like
char_length() and contains()✅ Apply regex patterns with
regexp_matches()✅ Combine multiple conditions with
AND and NOT✅ Order results by price for best deals
✅ Analyze domain characteristics and pricing
Key Skills Developed:
- String Manipulation: Working with domain names and extensions
- Conditional Logic: Combining multiple filters
- Pattern Matching: Using regex for complex searches
- Data Analysis: Finding patterns in domain pricing
What You Found:
- Short, cheap domain names without hyphens or numbers
- The best deals on premium domain extensions
- Patterns in domain pricing and availability