Amazon AWS EC2 Instances

import polars as pl

df = pl.read_csv("aws_ec2_vm_instances.csv")
df = df.with_columns(
    hourly_cost=pl.col("hourly_cost").str.lstrip("$").cast(float),
    memory=pl.col("memory").str.rstrip(" GiB").cast(float),
    performance_per_vcpu=pl.when(pl.col("performance_per_vcpu").is_null())
    .then(1)
    .otherwise(pl.col("performance_per_vcpu")),
).with_columns(
    real_vcpu=pl.col("vcpu") * pl.col("performance_per_vcpu"),
)
df

(df["real_vcpu"] / df["memory"]).max()

df.filter(df["real_vcpu"] / df["memory"] >= 2)

(df["hourly_cost"] / df["real_vcpu"]).min()

df.filter(df["hourly_cost"] / df["real_vcpu"] <= 0.0058)

0.0058 * 24 * 30