import csv
from pathlib import Path

current_file_directory = Path(__file__).parent
file_path = current_file_directory / "sample.csv"

with open(file_path) as file:
    reader = csv.reader(file, delimiter=",")
    for row in reader:
        print(row)

with open(file_path) as file:
    reader = csv.reader(file, delimiter=",")
    data = list(reader)
    print(data)

with open(file_path) as file:
    reader = csv.DictReader(file, delimiter=",")
    for row in reader:
        print("Row:")
        for key, value in row.items():
            print(f" {key}: {value}")


numbers = list(range(11))
second_powers = [x ** 2 for x in numbers]


with open(current_file_directory / "out.csv", "w", newline="") as file:  # csv.writer adds the newlines
    writer = csv.writer(file, delimiter=",")

    writer.writerow(["number", "second power"])
    # for number, second_power in zip(numbers, second_powers):
    #     writer.writerow([number, second_power])

    writer.writerows(zip(numbers, second_powers))