import pandas as pd
from matplotlib import pyplot as plt

columns = ["Rec","Trans","Total"]

data_frame = pd.read_csv("trans.csv",sep = ",")

print("CSV Data:\n",data_frame)


fig, axs = plt.subplots(1, 2, figsize=(9, 3), sharey=False)

axs[0].plot(data_frame.index,data_frame.Trans, label="Transfered - GB",c='Red')
axs[0].plot(data_frame.index,data_frame.Rec,label="Received - GB",c='Green')

#Convert GB into kb per second per day
seconds_in_day = 24*60*60
gb_to_kb=1024.0*1024.0

average_kb_per_day = gb_to_kb/seconds_in_day


data_frame_kbs=data_frame.copy(deep=True)

print(data_frame_kbs)
data_frame_kbs["Rec"]=data_frame_kbs['Rec'].mul(average_kb_per_day)
data_frame_kbs["Trans"]=data_frame_kbs['Trans'].mul(average_kb_per_day)

axs[1].plot(data_frame_kbs.index,data_frame_kbs.Trans,label="Kbs/s/d",c='Red')
axs[1].plot(data_frame_kbs.index,data_frame_kbs.Rec,label="Kbs/s/d",c='Green')

axs[0].legend()
axs[1].legend()

plt.show()