10. Generate Formatted Text Reports with Column Alignment
1. Hello, World!
2. Rename Photos by Capture Date
3. Organize Downloads Folder by File Type
4. Delete Old Log Files Automatically
5. Find Duplicate Files Using MD5 Hashing
6. Generate Comprehensive File Inventory
7. Parse Web Server Logs for Performance Metrics
8. Extract Emails, URLs, and Phone Numbers from Text
9. Track Daily and Monthly Active Users from Apache Logs
10. Generate Formatted Text Reports with Column Alignment
11. Analyze Sales Transactions and Generate Revenue Reports
12. Clean and Validate CSV Data
13. Convert JSON API Responses to CSV
14. Parse and Validate Configuration Files
15. Build a CLI Calculator with Argument Parsing
16. Parse and Display Weather Data from JSON
17. Build a Simple Inventory System with Classes
18. Generate Markdown Table from CSV Data
19. Aggregate Sales Data by Time Period
20. Recursive Directory Size Calculator with Filtering
21. Parse and Transform Server Configuration
22. Find and Replace Across Multiple Files
23. Build a Simple Template Engine
24. CSV Data Validator with Business Rules
25. Build a Multi-Format Log Analyzer

Challenge

Problem

When stakeholders prefer plain text over CSV, proper formatting makes data comprehensible. This drill teaches you to transform data into human-readable text reports with aligned columns, proper spacing, and summary statistics. You'll learn string formatting, dynamic column width calculation, and alignment techniques—essential for command-line tools, email reports, and system administration summaries. Note: This drill parses CSV manually using string methods rather than Ruby's CSV library.

Difficulty: Beginner

Instructions

  1. Read employee data from CSV file (Name, Department, Salary, Years)
  2. Calculate dynamic column widths based on longest values
  3. Format header row with columns aligned
  4. Format data rows with proper alignment:
    • Names: left-aligned
    • Department: left-aligned
    • Salary: right-aligned with $ and commas
    • Years: right-aligned
  5. Add separator line (dashes)
  6. Add summary statistics:
    • Total employees: X
    • Average salary: $XX,XXX
    • Total payroll: $XXX,XXX

Files

Editable
Read-only

Hints

Hint 1

String#ljust(width) left-aligns text with padding

Hint 2

String#rjust(width) right-aligns text with padding

Hint 3

Calculate max width: array.map { |r| r[0].length }.max

Hint 4

Format with commas: num.to_s.reverse.gsub(/(\d{3})(?=\d)/, '\1,').reverse

Hint 5

Parse CSV manually: line.split(',')

Hint 6

Use [calculated_width, header_width].max for column widths

Ruby 3.4

Provided Files (Read-only)

1. Correct header alignment

Input: 
generate_report('employees.csv')
Expected Output: 
Name           Department   Salary  Years
-------------------------------------------
John Smith     Engineering  $95,000      5
Alice Johnson  Marketing    $75,000      3
Bob Williams   Engineering  $105,000     8
Carol Davis    Sales        $68,000      2
-------------------------------------------
Total employees: 4
Average salary: $85,750
Total payroll: $343,000

2. Salaries formatted with commas

Input: 
generate_report('employees.csv')
puts 'Formatting verified'
Expected Output: 
Name           Department   Salary  Years
-------------------------------------------
John Smith     Engineering  $95,000      5
Alice Johnson  Marketing    $75,000      3
Bob Williams   Engineering  $105,000     8
Carol Davis    Sales        $68,000      2
-------------------------------------------
Total employees: 4
Average salary: $85,750
Total payroll: $343,000
Formatting verified

3. Summary statistics correct

Input: 
generate_report('employees.csv')
puts 'Stats verified'
Expected Output: 
Name           Department   Salary  Years
-------------------------------------------
John Smith     Engineering  $95,000      5
Alice Johnson  Marketing    $75,000      3
Bob Williams   Engineering  $105,000     8
Carol Davis    Sales        $68,000      2
-------------------------------------------
Total employees: 4
Average salary: $85,750
Total payroll: $343,000
Stats verified
+ 2 hidden test cases