Internet Speed Test logger with SpeedTest CLI

internet-speed-logger.py

# pip install speedtest-cli

import os
import csv, json
import subprocess
from datetime import datetime


res = subprocess.run(["speedtest-cli --server 6982 --json"], stdout=subprocess.PIPE, shell=True)
now = datetime.now()

results = json.loads(res.stdout)

current_dir = os.path.dirname(__file__)

def to_mb(speed):
    return round(int(speed) / (1024 * 1024), 2)


with open(os.path.join(current_dir, 'internet_speed.csv'), 'a') as file:
    writer = csv.writer(file)

    if file.tell() == 0:
        writer.writerow(["Download", "Upload", "Ping", "Server", "Datetime"])

    writer.writerow([
        to_mb(results["download"]), 
        to_mb(results["upload"]), 
        results["ping"],
        results["server"]["sponsor"],
        now.strftime("%d/%m/%Y %H:%M")
    ])