Re: AWK As A Major Systems Programming Language

Richard Kettlewell <invalid@invalid.invalid> wrote or quoted:

Yes, you could do a direct translation from the Awk and end up with
something that looked quite similar, apart from the differences in
syntax.

  Trying to make that Python script more user-friendly for folks
  who dig awk, then rolling out a sleeker version . . .

#!/usr/bin/env python3

import sys
import csv

# Initialize variables
total_price = 0
min_year = 0
max_year = 0
author_count = {}
year_count = {}

# Print the header of the report
print("Book Analysis Report")
print("====================")

# Read CSV data from standard input
reader = csv.reader(sys.stdin)
next(reader)  # Skip the header row

# Process each row in the CSV
for row in reader:
    title, author, year, price = row
    year = int(year)
    price = float(price)

    # Accumulate total price
    total_price += price

    # Determine min and max year
    if min_year == 0 or year < min_year:
        min_year = year
    if year > max_year:
        max_year = year

    # Count books per author
    if author in author_count:
        author_count[author] += 1
    else:
        author_count[author] = 1

    # Count books per year
    if year in year_count:
        year_count[year] += 1
    else:
        year_count[year] = 1

# Calculate total number of books
total_books = sum(author_count.values())

# Print the report
print("\nTotal number of books:", total_books)
print("Average book price: $%.2f" % (total_price / total_books))
print("Year range:", min_year, "to", max_year)

print("\nBooks per author:")
for author, count in author_count.items():
    print(author + ":", count)

print("\nBooks per year:")
for year, count in year_count.items():
    print(str(year) + ":", count)

  No need to make it such a big production, though . . .

import csv, sys
from collections import Counter

with open(sys.argv[1]) as f:
    data = list(csv.reader(f))[1:]
    prices = [float(row[3]) for row in data]
    years = [int(row[2]) for row in data]
    authors = [row[1] for row in data]

print("Book Analysis Report\n====================")
print(f"\nTotal number of books: {len(data)}")
print(f"Average book price: ${sum(prices) / len(prices):.2f}")
print(f"Year range: {min(years)} to {max(years)}")

print("\nBooks per author:")
for author, count in Counter(authors).items():
    print(f"{author}: {count}")

print("\nBooks per year:")
for year, count in Counter(years).items():
    print(f"{year}: {count}")