#!/usr/bin/env python
# coding: utf-8

# In[15]:


import pandas as pd
import numpy as np

df_runs = pd.read_csv('temp.csv', sep=',')
date_fmt = '%Y-%m-%d %H:%M:%S'
df_runs['Started At'] = pd.to_datetime(df_runs['Started At'], format=date_fmt)
df_runs['Finished At'] = pd.to_datetime(
    df_runs['Finished At'], format=date_fmt)
df_runs['Elapsed Time'] = df_runs['Finished At'] - df_runs['Started At']


# In[16]:


run_groups = df_runs.groupby(['Version'])
run_groups


# In[17]:


# Grouping dataframe
run_groups = df_runs.groupby(['Version'], dropna=False)
# Sum on each individual group == sum on seperate dataframes
print(run_groups.get_group(' 7.1.0.0')['Elapsed Time'].sum())
print(run_groups.get_group(' 7.2.0.0')['Elapsed Time'].sum())
print(run_groups.get_group(' 8.0.0.0')['Elapsed Time'].sum())
print(run_groups.get_group(' 8.0.1.0')['Elapsed Time'].sum())
# Sum on the groupByDataframe
print(run_groups['Elapsed Time'].sum())