speedtest-cli csv data analysis collected during a year

speedtest-cli-analysis.py

import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import matplotlib
import os
import datetime

% matplotlib inline

dir_name = os.path.abspath('./')

file_path = os.path.join(dir_name, 'speed-tests.csv')

df = pd.read_csv(file_path)

df['timestamp'] = pd.to_datetime(df.pop('dt'))

df['download'] /= 8000
df['upload'] /= 8000
df['ping'] /= 1000

df.dropna(how='any')

# df.describe()

df.index = df['timestamp']

# mask = (df.timestamp >= datetime.datetime(2017, 12, 1)) & (df.timestamp < datetime.datetime(2017, 12, 2))

m = pd.DataFrame.groupby(df, by=[df.index.month, df.index.year]).mean()

m.unstack(level=1).plot(y=['download','upload'], figsize=(15, 10), grid=True, xticks=[x for x in range(1,13)])