In [1]:
%load_ext autoreload
%autoreload 1
In [2]:
from IPython.display import display, HTML
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import seaborn as sns
import warnings
warnings.filterwarnings("ignore", 'This pattern has match groups')
%matplotlib inline
pd.options.display.max_rows = 1000
pd.options.display.max_columns = 60
pd.options.display.max_colwidth = 200
In [3]:
#utils.py is where all our custom functions live is we set an autoreload on it.
%aimport utils
from utils import *
%aimport viz_utils
from viz_utils import *
In [4]:
df_all = pd.read_excel('all data v3.xlsx', 'iLab data.txt', index_col=None, na_values=['NA'])
Along with the time coordinates of the ideas they had (i.e. their methods before a delete all or a submit)
Note: students may have used a method multiple times, only the 1st time coordinate when the method was deleted/submitted is shown for simplicity.
In [5]:
%aimport viz_utils
%aimport utils
session_pairs = ["L70970875:120f77e742b:-8000",
"L-32a989cf:120ecd7e93b:-8000",
"L40bb98dd:120c3a7683a:-8000",
"L-7821f52f:120f7fb42ba:-8000",
"L651ef9df:120f7fb65f2:-8000",
"L46c6b7c:120ed2665a4:-8000",
"L-10f11766:120ecd4f63a:-8000",
"L-160920ae:120ed3b11b6:-8000",
"L-2567b17a:120eda25685:-8000"]
for session in session_pairs:
print 'Session: ', session
df = prepare_session(df_all,session)
plot(df,to_plot,colors, column_to_use, function_to_use)
ideas = get_key_ideas(df)
print "\n"
display(ideas)
print "\n\n\n-------------------------------------------------------"
Session: L70970875:120f77e742b:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
delete
12:44
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all | st1 Count all +
2
submit
14:34
1 3 5 7 9 | 3 4 5 6 7
st1 Median all | st1 Median all
3
submit
15:53
1 3 5 7 9 | 3 4 5 6 7
st1 Average all | st1 Average all
4
submit
21:33
1 3 5 7 9 | 3 4 5 6 7
st1 Average all | st1 Average all
5
submit
24:40
1 3 5 7 9 | 3 4 5 6 7
st1 - Median | st1 - Median all
6
submit
26:46
1 3 5 7 9 | 3 4 5 6 7
st1 Average all | st1 Average all
-------------------------------------------------------
Session: L-32a989cf:120ecd7e93b:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
delete
1:45
1 3 5 7 9 | 3 4 5 6 7
st1 Average all | st1
2
delete
5:30
1 3 5 7 9 | 3 4 5 6 7
st1 Median all + 5 | st1
3
deleteAll
5:54
1 3 5 7 9 | 3 4 5 6 7
st1 Count choose... 5 9 | st1
4
delete
7:15
1 3 5 7 9 | 3 4 5 6 7
st1 Median all x Average choose... 7 9 3 1 | st1 Median all x Average choose... 7 6 4 3
5
delete
9:18
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all + Average 1 3 | st1 Sum all + 3
6
submit
9:45
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all + Average 1 3 | st1 Sum all + Average 3 4
7
get new case
11:54
-
-
8
deleteAll
14:48
2 5 8 | 2 2 5 5 8 8
st1 Sum all + Average 2 5 | st1 Sum all + Average 2 2
9
delete
18:8
2 5 8 | 2 2 5 5 8 8
st1 Count 2 5 x Count 8 | st1 Count choose... 2 2 5
10
deleteAll
21:37
2 5 8 | 2 2 5 5 8 8
st1 Count 2 5 x Count 8 | st1 Count choose... 2 2 x Count 2 8
11
deleteAll
23:45
2 5 8 | 2 2 5 5 8 8
st1 Count 2 5 x Count 8 | st1 Count 2 2 x Count 8
12
deleteAll
28:4
2 5 8 | 2 2 5 5 8 8
st1 Median all / Count all | st1 Median all / Count all
13
deleteAll
29:15
2 5 8 | 2 2 5 5 8 8
st1 Median all / Count all | st1 Median all / Count 2 5 8
14
deleteAll
33:1
2 5 8 | 2 2 5 5 8 8
st1 Sum all + Median all st2 Step1 x | st1 Sum all + Median all st2 Step1 x
-------------------------------------------------------
Session: L40bb98dd:120c3a7683a:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
delete
0:56
1 3 5 7 9 | 3 4 5 6 7
st1 9 + 7 st2 5 | st1 7
2
deleteAll
1:9
1 3 5 7 9 | 3 4 5 6 7
st1 9 + 7 | st1 7
3
delete
9:13
1 3 5 7 9 | 3 4 5 6 7
st1 9 + 7 st2 Step1 + 3 st3 Step2 + 1 st4 Step3 / | st1 6 + 7 st2 Step1 + 5 st3 Step2 + 4 st4 3
4
submit
10:9
1 3 5 7 9 | 3 4 5 6 7
st1 9 + 7 st2 Step1 + 3 st3 Step2 + 1 st4 Step3 / | st1 6 + 7 st2 Step1 + 5 st3 Step2 + 4 st4 Step3 + 3 st5 Step4 / 5
5
get new case
10:45
-
-
6
delete
12:38
2 5 8 | 2 2 5 5 8 8
st1 8 + 5 st2 Step1 + 2 | st1 8 + 8 st2 Step1 + 5 st3 Step2 + 5 st4 Step3 + 5
7
submit
13:3
2 5 8 | 2 2 5 5 8 8
st1 8 + 5 st2 Step1 + 2 | st1 8 + 8 st2 Step1 + 5 st3 Step2 + 5 st4 Step3 + 2 st5 Step4 + 2
8
delete
14:23
2 5 8 | 2 2 5 5 8 8
st1 8 + 5 st2 Step1 + 2 st3 | st1 8 + 8 st2 Step1 + 5 st3 Step2 + 5 st4 Step3 + 2 st5 Step4 + 2 st6 Step5 /
9
delete
16:3
2 5 8 | 2 2 5 5 8 8
st1 8 + 5 st2 Step1 + 2 st3 5 / | st1 8 + 8 st2 Step1 + 5 st3 Step2 + 5 st4 Step3 + 2 st5 Step4 + 2 st6 Step5 / 5
10
submit
16:18
2 5 8 | 2 2 5 5 8 8
st1 8 + 5 st2 Step1 + 2 st3 Step2 / 5 | st1 8 + 8 st2 Step1 + 5 st3 Step2 + 5 st4 Step3 + 2 st5 Step4 + 2 st6 Step5 / 5
11
get new case
22:46
-
-
-------------------------------------------------------
Session: L-7821f52f:120f7fb42ba:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
delete
1:48
1 3 5 7 9 | 3 4 5 6 7
st1 Sum 1 3 | st1
2
delete
2:17
1 3 5 7 9 | 3 4 5 6 7
st1 Average 7 3 | st1 7
3
delete
2:42
1 3 5 7 9 | 3 4 5 6 7
st1 Average all | st1 7
4
deleteAll
5:9
1 3 5 7 9 | 3 4 5 6 7
st1 Average all x 9 st2 Average all x 5 | st1 Average all x 7 st2 Average all
5
delete
9:49
1 3 5 7 9 | 3 4 5 6 7
st1 Average all x 5 st2 Average all x 9 st3 Average all x 1 st4 Average all x 7 | st1 Average all x 6 st2 Average all x 7 st3 Sum all x 5 st4 Average all x Step3
6
delete
10:42
1 3 5 7 9 | 3 4 5 6 7
st1 Average all x 5 st2 Average all x 9 st3 Average all x 1 st4 Average all x 7 | st1 Average all x 6 st2 Average all x 7 st3
7
delete
19:24
1 3 5 7 9 | 3 4 5 6 7
st1 Average all x 1 st2 Average all x 9 st3 Sum Average all x 5 st4 Average all x 3 st5 | st1 Average all x 3 st2 Average all x 5 st3 Average all x 4 st4 Average all
8
delete
22:27
1 3 5 7 9 | 3 4 5 6 7
st1 Average all x 1 st2 Average all x 9 st3 Sum Average all x 5 st4 Average all x 3 st5 Average all - 7 st6 Average all - 1 st7 Step1 - Step5 st8 | st1 Average all x 3 st2 Average all x 5 st3 Aver...
9
delete
23:17
1 3 5 7 9 | 3 4 5 6 7
st1 Average all x 1 st2 Average all x 9 st3 Sum Average all x 5 st4 Average all x 3 st5 Average all - 7 st6 Average all - 1 st7 Step1 - Step5 st8 | st1 Average all x 3 st2 Average all x 5 st3 Aver...
10
delete
24:39
1 3 5 7 9 | 3 4 5 6 7
st1 Average all x 1 st2 Average all x 9 st3 Sum Average all x 5 st4 Average all x 3 st5 Average all - 7 st6 Average all - 1 st7 Step1 - Step5 st8 Average all - 7 | st1 Average all x 3 st2 Average ...
11
deleteAll
25:15
1 3 5 7 9 | 3 4 5 6 7
st1 Average all x 1 st2 Average all x 9 st3 Sum Average all x 5 | st1 Average all x 3 st2 Average all x 5 st3 Average all x 4 st4 Average all - 5 st5 Average all - 7 st6 Average all - 6 st7 Averag...
-------------------------------------------------------
Session: L651ef9df:120f7fb65f2:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
delete
0:52
1 3 5 7 9 | 3 4 5 6 7
st1 1 + | st1
2
deleteAll
1:17
1 3 5 7 9 | 3 4 5 6 7
st1 1 + 1 | st1
3
delete
2:31
1 3 5 7 9 | 3 4 5 6 7
st1 1 | st1
4
delete
2:59
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all | st1
5
delete
4:6
1 3 5 7 9 | 3 4 5 6 7
st1 Average all | st1 Average all
6
delete
8:22
1 3 5 7 9 | 3 4 5 6 7
st1 Count all | st1
7
delete
8:39
1 3 5 7 9 | 3 4 5 6 7
st1 Count all | st1 Count all
8
delete
9:26
1 3 5 7 9 | 3 4 5 6 7
st1 Average none | st1
9
delete
10:16
1 3 5 7 9 | 3 4 5 6 7
st1 Average all | st1
10
delete
10:44
1 3 5 7 9 | 3 4 5 6 7
st1 9 x 5 st2 Count all | st1
11
deleteAll
10:58
1 3 5 7 9 | 3 4 5 6 7
st1 9 x 9 | st1
12
deleteAll
11:31
1 3 5 7 9 | 3 4 5 6 7
st1 Median all | st1 Median all
13
deleteAll
12:3
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all | st1 Sum all
14
deleteAll
12:22
1 3 5 7 9 | 3 4 5 6 7
st1 Count all | st1 Sum all
15
deleteAll
13:7
1 3 5 7 9 | 3 4 5 6 7
st1 Average | st1 Average none
16
deleteAll
13:30
1 3 5 7 9 | 3 4 5 6 7
st1 Average all | st1 Average all
17
deleteAll
13:46
1 3 5 7 9 | 3 4 5 6 7
st1 Median all | st1 Median all
18
deleteAll
15:45
1 3 5 7 9 | 3 4 5 6 7
st1 9 - 1 | st1 7 - 4
19
submit
17:19
1 3 5 7 9 | 3 4 5 6 7
st1 9 - 1 | st1 7 - 3
20
submit
20:32
1 3 5 7 9 | 3 4 5 6 7
st1 9 - 1 | st1 7 - 3
21
get new case
20:56
-
-
22
deleteAll
22:4
1 3 5 7 9 | 1 4 5 6 9
st1 9 - 1 | st1 9 - 1
23
deleteAll
22:26
1 3 5 7 9 | 1 4 5 6 9
st1 Average all | st1 Average all
24
deleteAll
22:38
1 3 5 7 9 | 1 4 5 6 9
st1 Count all | st1 Count all
25
deleteAll
22:57
1 3 5 7 9 | 1 4 5 6 9
st1 Sum all | st1 Sum all
26
deleteAll
23:42
1 3 5 7 9 | 1 4 5 6 9
st1 Median all | st1 Sum all
27
deleteAll
24:14
1 3 5 7 9 | 1 4 5 6 9
st1 Median all | st1 Median all
-------------------------------------------------------
Session: L46c6b7c:120ed2665a4:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
deleteAll
3:28
1 3 5 7 9 | 3 4 5 6 7
st1 Average choose... Median all | st1 3
2
deleteAll
5:18
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all / 5 st2 | st1 3
3
deleteAll
6:23
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all / 5 st2 | st1 Count choose... Median all x
4
deleteAll
6:58
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all / 5 st2 | st1 Median all x
5
deleteAll
7:14
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all / 5 st2 | st1 5
6
delete
7:35
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all / 5 st2 | st1 Median all x 5
7
deleteAll
8:16
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all / 5 st2 | st1 Sum all / 5
8
submit
8:43
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all / 5 | st1 Sum all / 5
9
deleteAll
9:28
1 3 5 7 9 | 3 4 5 6 7
st1 Count choose... | st1 Sum all / 5
10
deleteAll
9:54
1 3 5 7 9 | 3 4 5 6 7
st1 Count all x | st1 Sum all / 5
11
deleteAll
10:6
1 3 5 7 9 | 3 4 5 6 7
st1 Sum | st1 Sum all / 5
12
submit
10:34
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all / 5 | st1 Sum all / 5
13
deleteAll
11:44
1 3 5 7 9 | 3 4 5 6 7
st1 Average all x 3 | st1 Sum all / 5
14
deleteAll
12:30
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all - 9 | st1 Sum all / 5
15
deleteAll
13:40
1 3 5 7 9 | 3 4 5 6 7
st1 Count all | st1 Sum all / 5
16
submit
15:16
1 3 5 7 9 | 3 4 5 6 7
st1 Count 2 4 6 8 | st1 Count none
17
get new case
16:4
-
-
18
submit
16:54
1 3 5 7 9 | 1 4 5 6 9
st1 Count 2 4 6 8 | st1 Count 3 2 8 7
19
deleteAll
19:47
1 3 5 7 9 | 1 4 5 6 9
st1 Count 2 4 6 8 | st1
20
deleteAll
19:59
1 3 5 7 9 | 1 4 5 6 9
st1 Average 1 | st1
21
submit
20:45
1 3 5 7 9 | 1 4 5 6 9
st1 Average choose... 4 | st1 Average 4
22
submit
23:24
1 3 5 7 9 | 1 4 5 6 9
st1 Count 2 4 6 8 | st1 Count 2 3 7 8
23
deleteAll
24:20
1 3 5 7 9 | 1 4 5 6 9
st1 Sum all | st1
24
submit
24:47
1 3 5 7 9 | 1 4 5 6 9
st1 Median all | st1 Median all
25
deleteAll
25:37
1 3 5 7 9 | 1 4 5 6 9
st1 Sum 2 4 8 6 6 | st1
26
submit
26:26
1 3 5 7 9 | 1 4 5 6 9
st1 Sum 4 6 8 2 / 5 | st1 Sum 7 8 3 2 / 5
27
submit
31:3
1 3 5 7 9 | 1 4 5 6 9
st1 Count 3 5 7 | st1 Count 4 5 6
-------------------------------------------------------
Session: L-10f11766:120ecd4f63a:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
deleteAll
7:50
1 3 5 7 9 | 3 4 5 6 7
st1 Average all / | st1 Average all / Average
2
deleteAll
10:16
1 3 5 7 9 | 3 4 5 6 7
st1 Median all | st1 Median all
3
deleteAll
10:32
1 3 5 7 9 | 3 4 5 6 7
st1 Count all | st1 Count all
4
deleteAll
12:19
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all / Count all | st1 Sum all
5
deleteAll
13:45
1 3 5 7 9 | 3 4 5 6 7
st1 Average all / Median all | st1 Average all / Median all
6
deleteAll
16:2
1 3 5 7 9 | 3 4 5 6 7
st1 Count all + | st1
7
submit
20:55
1 3 5 7 9 | 3 4 5 6 7
st1 Count 2 4 6 8 | st1 Count none
8
get new case
21:15
-
-
9
submit
22:7
1 3 5 7 9 | 1 4 5 6 9
st1 Count 2 6 4 8 | st1 Count 3 2 7 8
10
deleteAll
25:20
1 3 5 7 9 | 1 4 5 6 9
st1 2 | st1
11
submit
25:59
1 3 5 7 9 | 1 4 5 6 9
st1 Count 2 6 4 8 | st1 Count 3 2 7 8
12
submit
27:11
1 3 5 7 9 | 1 4 5 6 9
st1 Sum 1 3 5 7 9 | st1 Sum 1 4 5 6 9
13
deleteAll
29:38
1 3 5 7 9 | 1 4 5 6 9
st1 Count choose... 2 4 6 8 + | st1 Sum 1 4 5 6 9 +
14
deleteAll
30:56
1 3 5 7 9 | 1 4 5 6 9
st1 Count choose... 2 4 6 8 + | st1 Count choose... 2 3 3
15
deleteAll
31:10
1 3 5 7 9 | 1 4 5 6 9
st1 Count choose... 2 4 6 8 + | st1 Count 2 3 2
16
deleteAll
31:18
1 3 5 7 9 | 1 4 5 6 9
st1 Count choose... 2 4 6 8 + | st1 Count
17
delete
31:48
1 3 5 7 9 | 1 4 5 6 9
st1 Count choose... 2 4 6 8 + | st1 Count 2 3 7
18
delete
36:8
1 3 5 7 9 | 1 4 5 6 9
st1 Count choose... 2 4 6 8 - Count 1 3 5 7 9 | st1 Count 2 3 7 8 -
-------------------------------------------------------
Session: L-160920ae:120ed3b11b6:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
delete
0:54
1 3 5 7 9 | 3 4 5 6 7
st1 9 - 1 st2 | st1
2
delete
1:13
1 3 5 7 9 | 3 4 5 6 7
st1 9 - 1 st2 9 - 1 | st1
3
delete
3:17
1 3 5 7 9 | 3 4 5 6 7
st1 9 - 1 st2 | st1 7 - 3
4
submit
3:31
1 3 5 7 9 | 3 4 5 6 7
st1 9 - 1 | st1 7 - 3
5
get new case
4:17
-
-
6
submit
6:28
1 3 5 7 9 | 1 4 5 6 9
st1 7 - 3 | st1 6 - 4
7
get new case
7:2
-
-
8
submit
7:44
4 4 6 6 | 2 4 6 10
st1 6 - 4 | st1 10 - 2
9
get new case
8:39
-
-
10
submit
9:34
2 4 6 10 | 2 5 6 10
st1 6 - 4 | st1 6 - 5
11
get new case
9:58
-
-
12
delete
10:26
4 4 5 6 8 | 0 1 5 6 12
st1 8 - 4 | st1 12 - 0
13
submit
11:17
4 4 5 6 8 | 0 1 5 6 12
st1 8 - 4 | st1 12 - 0
14
get new case
11:30
-
-
15
submit
11:53
4 5 7 8 | 2 4 8 11
st1 8 - 4 | st1 11 - 2
16
get new case
12:5
-
-
17
submit
12:47
2 5 8 | 2 2 5 5 8 8
st1 8 - 2 | st1 8 - 2
18
get new case
13:3
-
-
19
submit
13:35
3 7 8 | 3 3 7 7 8 8
st1 8 - 3 | st1 8 - 3
20
get new case
13:52
-
-
21
delete
14:23
1 3 5 7 9 | 1 2 3 3 9
st1 9 - 1 | st1 9 - 1
22
submit
14:59
1 3 5 7 9 | 1 2 3 3 9
st1 7 - 3 | st1 3 - 2
23
get new case
15:12
-
-
24
submit
15:36
5 5 5 11 | 11 11 11 5
st1 11 - 5 | st1 11 - 5
25
get new case
15:50
-
-
-------------------------------------------------------
Session: L-2567b17a:120eda25685:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
delete
0:11
1 3 5 7 9 | 3 4 5 6 7
st1 9 | st1
2
submit
1:44
1 3 5 7 9 | 3 4 5 6 7
st1 Average all | st1 Average all
3
submit
2:56
1 3 5 7 9 | 3 4 5 6 7
st1 Average all | st1 Average all
4
delete
7:31
1 3 5 7 9 | 3 4 5 6 7
st1 Median all | st1 Median all
5
delete
7:56
1 3 5 7 9 | 3 4 5 6 7
st1 Sum | st1
6
delete
8:43
1 3 5 7 9 | 3 4 5 6 7
st1 Sum all | st1 Sum all
7
submit
10:12
1 3 5 7 9 | 3 4 5 6 7
st1 9 - 1 | st1 7 - 3
8
get new case
12:11
-
-
9
deleteAll
15:34
1 3 5 7 9 | 1 4 5 6 9
st1 Median all | st1 Median all
10
deleteAll
15:51
1 3 5 7 9 | 1 4 5 6 9
st1 Average all | st1 Average all
11
delete
19:38
1 3 5 7 9 | 1 4 5 6 9
st1 9 - 1 st2 7 - 3 | st1 9 - 1 st2 6 - 4 st3
12
delete
21:23
1 3 5 7 9 | 1 4 5 6 9
st1 9 - 1 st2 7 - 3 st3 Step1 - Step2 | st1 9 - 1 st2 6 - 4 st3 Step1 - Step1
13
deleteAll
21:38
1 3 5 7 9 | 1 4 5 6 9
st1 9 - 1 st2 7 - 3 st3 Step1 - Step2 | st1 9 - 1 st2 6 - 4 st3 Step1 - Step2
14
submit
23:23
1 3 5 7 9 | 1 4 5 6 9
st1 9 - 1 st2 7 - 3 st3 Step1 - Step2 | st1 9 - 1 st2 6 - 4 st3 Step1 - Step2
15
deleteAll
25:18
1 3 5 7 9 | 1 4 5 6 9
st1 9 - 1 | st1
16
submit
26:30
1 3 5 7 9 | 1 4 5 6 9
st1 9 - 1 st2 7 - 3 st3 Step1 - Step2 | st1 9 - 1 st2 6 - 4 st3 Step1 - Step2
17
submit
29:42
1 3 5 7 9 | 1 4 5 6 9
st1 9 + 1 st2 7 + 3 st3 Step1 + Step2 | st1 9 + 1 st2 6 + 4 st3 Step1 + Step2
18
submit
31:34
1 3 5 7 9 | 1 4 5 6 9
st1 9 - 1 st2 7 - 3 st3 Step1 + Step2 | st1 9 - 1 st2 6 - 4 st3 Step1 + Step2
19
get new case
31:45
-
-
-------------------------------------------------------
In [6]:
%aimport viz_utils
session_pairs = ["L-23727b5d:120fc875dd6:-8000",
"L-4af1736f:120fc85c498:-8000",
"Ld1a3562:120fc85ee39:-8000",
"L5cdf7922:120f1e34b2a:-8000",
"L6203b1fe:120f1e535b4:-8000",
"L-7fa003de:120f2365e41:-8000",
"L4739cf0e:120f2367488:-8000",
"L-3a693a9:120f818907f:-8000",
"L-6425781a:120fcfdb07c:-8000",
"L-7bb916cc:120f8188b5f:-8000",
"L68f494a4:120fcfd39b6:-8000",
"L-5bacd7a1:120edcb6ed9:-8000",
"L-e22e239:120edcb3172:-8000",
"L2a1d096a:120f7d9f5d3:-8000",
"L45ac8b86:120f2b33c23:-8000",
"L6f07cfe6:120edcb473c:-8000"]
for session in session_pairs:
print "Session:", session
df = prepare_session(df_all,session)
plot(df,to_plot,colors, column_to_use, function_to_use)
ideas = get_key_ideas(df)
print "\n"
display(ideas)
print "\n\n\n-------------------------------------------------------"
Session: L-23727b5d:120fc875dd6:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
submit
1:7
44 47 50 53 | 44 45 45 46 53
st1 Average all - 1 | st1 Average all - 1
2
get new case
1:40
-
-
3
submit
2:35
45 48 51 | 45 45 48 48 51 51
st1 Average all - 2 | st1 Average all - 2
4
get new case
3:20
-
-
5
submit
7:31
46 50 51 | 46 46 50 50 51 51
st1 Average all - 3 | st1 Average all - 3
6
get new case
7:49
-
-
7
deleteAll
8:52
47 49 51 51 53 55 | 47 47 47 55 55 55
st1 Median all | st1 Median all
8
delete
11:6
47 49 51 51 53 55 | 47 47 47 55 55 55
st1 Sum all - 4 | st1 Sum all - 5
9
delete
11:45
47 49 51 51 53 55 | 47 47 47 55 55 55
st1 Sum all - 4 | st1 Average all - 4
10
submit
12:29
47 49 51 51 53 55 | 47 47 47 55 55 55
st1 Average all - 4 | st1 Average all - 4
-------------------------------------------------------
Session: L-4af1736f:120fc85c498:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
deleteAll
0:59
44 47 50 53 | 44 45 45 46 53
st1 Average all - Median all | st1
2
submit
2:58
44 47 50 53 | 44 45 45 46 53
st1 Count all + Average all | st1 Count all + Average all
3
get new case
3:27
-
-
4
deleteAll
4:45
45 48 51 | 45 45 48 48 51 51
st1 Count all - Average all | st1 Median all - Average all
5
deleteAll
5:31
45 48 51 | 45 45 48 48 51 51
st1 Count all - Average all | st1 Count all - Average all
6
deleteAll
6:34
45 48 51 | 45 45 48 48 51 51
st1 Count all - Average all | st1 Count all - Average all
7
deleteAll
8:14
45 48 51 | 45 45 48 48 51 51
st1 Count all - Average all | st1 Count all
8
delete
11:45
45 48 51 | 45 45 48 48 51 51
st1 Count all - Average all | st1 Count all - Average all
9
deleteAll
12:28
45 48 51 | 45 45 48 48 51 51
st1 Average all - Count all | st1 Count all - Average all
10
deleteAll
12:53
45 48 51 | 45 45 48 48 51 51
st1 Average all - Median all | st1 Count all - Average all
11
deleteAll
13:21
45 48 51 | 45 45 48 48 51 51
st1 Median all - Count all | st1 Count all - Average all
12
deleteAll
13:36
45 48 51 | 45 45 48 48 51 51
st1 Median all - Count all | st1 Sum all
13
deleteAll
14:0
45 48 51 | 45 45 48 48 51 51
st1 Median all - Count all | st1 Average all - Count all
-------------------------------------------------------
Session: Ld1a3562:120fc85ee39:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
deleteAll
0:16
44 47 50 53 | 44 45 45 46 53
st1 Sum | st1
2
deleteAll
1:28
44 47 50 53 | 44 45 45 46 53
st1 Sum all + 10 st2 Average all / 10 | st1
3
deleteAll
2:53
44 47 50 53 | 44 45 45 46 53
st1 Sum all + 10 st2 Average all / 10 | st1 Sum all + 10 st2 Average all / 10
4
delete
12:13
44 47 50 53 | 44 45 45 46 53
st1 Count 2 3 | st1 13
5
delete
12:38
44 47 50 53 | 44 45 45 46 53
st1 4 - 1 | st1 13
-------------------------------------------------------
Session: L5cdf7922:120f1e34b2a:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
deleteAll
0:6
44 47 50 53 | 44 45 45 46 53
st1 2 | st1
2
deleteAll
0:21
44 47 50 53 | 44 45 45 46 53
st1 Count 2 5 | st1
3
delete
2:0
44 47 50 53 | 44 45 45 46 53
st1 Count 2 3 5 6 8 9 - Count 1 4 7 10 | st1 Count 4 5 6 7 8 9 - Count 1 2 2 3 10
4
delete
4:3
44 47 50 53 | 44 45 45 46 53
st1 Count choose... 2 3 5 6 8 9 + Count 1 4 7 10 | st1 Count 4 5 6 7 8 9 - Count 1 2 2 3 10
5
delete
4:16
44 47 50 53 | 44 45 45 46 53
st1 Count choose... 2 3 5 6 8 9 + Count 1 4 7 10 | st1 Count 1
6
submit
4:44
44 47 50 53 | 44 45 45 46 53
st1 Count choose... 2 3 5 6 8 9 + Count 1 4 7 10 | st1 Count 4 5 6 7 8 9 + Count 2 1 2 3 10
7
get new case
4:57
-
-
8
submit
6:25
44 47 50 53 | 44 48 49 53
st1 Count 2 3 5 6 8 9 + Count 1 4 7 10 | st1 Count 2 3 4 7 8 9 + Count 1 5 6 10
9
delete
8:2
44 47 50 53 | 44 48 49 53
st1 Count Average 1 4 7 10 - Average 2 3 5 6 8 9 | st1
10
deleteAll
8:27
44 47 50 53 | 44 48 49 53
st1 Average all | st1 Average all
11
deleteAll
9:26
44 47 50 53 | 44 48 49 53
st1 Count all - Count all | st1 Sum all -
12
deleteAll
10:23
44 47 50 53 | 44 48 49 53
st1 Count 10 | st1
13
deleteAll
10:52
44 47 50 53 | 44 48 49 53
st1 10 - 1 | st1 10
14
get new case
12:31
-
-
15
submit
14:8
43 46 48 49 50 | 44 48 49 54 56
st1 Count 1 2 4 | st1 Count 2 3 4 4 4 8 9 10 12
16
get new case
14:19
-
-
-------------------------------------------------------
Session: L6203b1fe:120f1e535b4:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
submit
1:25
44 47 50 53 | 44 45 45 46 53
st1 Average all / Sum all | st1 Average all / Sum all
2
get new case
1:49
-
-
3
deleteAll
3:23
45 48 51 | 45 45 48 48 51 51
st1 Average all / Sum all | st1 Average all / Sum all
4
deleteAll
4:15
45 48 51 | 45 45 48 48 51 51
st1 8 - 5 | st1 Average all / Sum all
5
submit
4:25
45 48 51 | 45 45 48 48 51 51
st1 8 - 5 | st1 8 - 5
6
get new case
5:35
-
-
7
deleteAll
8:21
46 47 51 52 53 | 44 47 51 53 55
st1 Sum all - 10 st2 Step1 - 9 st3 Step2 - 8 st4 Step3 - 4 st5 Step4 - 3 | st1 Sum all - 12 st2 Step1 10 - st3 Step2 - 8 st4 Step3 - 4 st5 Step4 - 1
8
delete
10:49
46 47 51 52 53 | 44 47 51 53 55
st1 Average all - 10 st2 Step1 - 9 st3 Step2 - 8 st4 Step3 - 4 st5 Step4 - 3 | st1 all - 12 st2 Step1 - 10
9
delete
11:14
46 47 51 52 53 | 44 47 51 53 55
st1 Average all - 10 st2 Step1 - 9 st3 Step2 - 8 st4 Step3 - 4 st5 Step4 - 3 | st1 all - 12 st2 Step1 - 10 st3 Step1
-------------------------------------------------------
Session: L-7fa003de:120f2365e41:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
submit
0:26
44 47 50 53 | 44 45 45 46 53
st1 7 - 4 | st1 3 - 2
2
get new case
0:43
-
-
3
submit
1:22
45 46 47 55 57 | 44 45 46 49 53
st1 14 - 2 | st1 10 - 1
4
get new case
1:36
-
-
5
deleteAll
1:56
45 46 47 55 57 | 45 48 49 52 57
st1 14 | st1
6
submit
2:19
45 46 47 55 57 | 45 48 49 52 57
st1 12 - 4 | st1 9 - 6
7
get new case
2:30
-
-
8
submit
3:15
43 49 52 54 54 | 48 49 50 51 52
st1 11 - 0 | st1 9 - 5
9
get new case
3:25
-
-
10
submit
3:53
43 49 52 54 54 | 43 50 51 52 54
st1 9 - 6 | st1 9 - 7
11
get new case
4:8
-
-
12
submit
4:36
50 50 52 52 | 47 50 52 55
st1 9 - 7 | st1 12 - 4
13
get new case
4:48
-
-
14
submit
5:23
51 51 51 54 54 | 45 48 51 54 57
st1 11 - 8 | st1 14 - 2
15
get new case
5:39
-
-
16
submit
6:11
51 52 54 54 | 47 51 54 56
st1 11 - 8 | st1 13 - 4
17
get new case
6:24
-
-
18
submit
6:58
45 48 51 | 45 45 48 48 51 51
st1 8 - 2 | st1 8 - 2
19
get new case
7:19
-
-
20
submit
7:56
46 50 51 | 46 46 50 50 51 51
st1 8 - 3 | st1 8 - 3
21
get new case
8:9
-
-
22
delete
9:15
49 51 51 53 | 49 49 51 53
st1 8 - 6 | st1 10 - 6
23
deleteAll
10:23
49 51 51 53 | 49 49 51 53
st1 10 + 8 st2 8 + 6 st3 | st1
24
delete
11:30
49 51 51 53 | 49 49 51 53
st1 8 - 8 | st1 8 - 6
25
deleteAll
12:24
49 51 51 53 | 49 49 51 53
st1 8 - 8 | st1 8 - 6
-------------------------------------------------------
Session: L4739cf0e:120f2367488:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
submit
0:26
44 47 50 53 | 44 45 45 46 53
st1 7 - 1 | st1 3 - 1
2
get new case
0:43
-
-
3
submit
1:42
44 44 46 46 | 44 44 46 52
st1 3 - 1 | st1 9 - 1
4
get new case
2:1
-
-
5
deleteAll
5:0
44 44 46 52 | 44 46 46 52
st1 Sum 3 1 1 | st1 Sum 1 3 3
6
submit
6:39
44 44 46 52 | 44 46 46 52
st1 9 - 1 | st1 9 - 3
7
get new case
7:0
-
-
8
submit
7:50
46 48 50 52 | 46 47 51 52
st1 7 - 3 | st1 8 - 3
9
get new case
8:3
-
-
10
submit
8:42
45 48 51 | 45 45 48 48 51 51
st1 8 - 2 | st1 8 - 2
11
get new case
9:0
-
-
12
submit
10:34
45 45 48 48 51 51 | 45 47 48 48 49 51
st1 5 - 2 | st1 6 - 4
13
get new case
10:51
-
-
14
submit
11:20
46 47 51 52 53 | 44 47 51 53 55
st1 10 - 3 | st1 12 - 1
15
get new case
11:37
-
-
16
deleteAll
12:8
46 50 51 | 46 46 50 50 51 51
st1 8 + 3 | st1 8 + 3
17
submit
13:43
46 50 51 | 46 46 50 50 51 51
st1 Average all / Count 3 7 8 | st1 Average 3 7 8 / Count 3 7 8
18
get new case
14:0
-
-
-------------------------------------------------------
Session: L-3a693a9:120f818907f:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
delete
3:37
44 47 50 53 | 44 45 45 46 53
st1 Average all - 10 st2 7 - 1 st3 | st1 Average all - 10 st2 Average all
2
delete
4:21
44 47 50 53 | 44 45 45 46 53
st1 Average all - 10 st2 7 - 1 st3 Average all | st1 Average all - 10 st2 Average all
3
deleteAll
7:54
44 47 50 53 | 44 45 45 46 53
st1 Average all - 10 | st1 Average all - 10 st2 Average all
4
deleteAll
9:12
44 47 50 53 | 44 45 45 46 53
st1 Average all - 10 | st1 Average all - 10 st2
5
delete
10:47
44 47 50 53 | 44 45 45 46 53
st1 Average all - 10 st2 7 - 1 st3 | st1 Average all - 10 st2 12 - 3 st3
-------------------------------------------------------
Session: L-6425781a:120fcfdb07c:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
delete
1:55
44 47 50 53 | 44 45 45 46 53
st1 Average all - 10 st2 Average all - 4 | st1 Average all - 3 st2 Average all - 3
2
delete
4:58
44 47 50 53 | 44 45 45 46 53
st1 Average all - 10 st2 Average all - 4 st3 Average all - 10 | st1 Average all - 3 st2 Average all - 10 st3 Average all 3
3
delete
7:28
44 47 50 53 | 44 45 45 46 53
st1 Average all - 10 st2 Average all - 4 st3 Average all - 10 st4 Average all - 1 st5 Average all | st1 Average all - 3 st2 Average all - 10 st3 Average all - 1 st4 Average all - 2 st5
4
delete
8:52
44 47 50 53 | 44 45 45 46 53
st1 Average all - 10 st2 Average all - 4 st3 Average all - 10 | st1 Average all - 3 st2 Average all - 10 st3 Average all - 1 st4 Average all - 2 st5 2 - 1
5
delete
16:32
44 47 50 53 | 44 45 45 46 53
st1 Average all - 10 st2 Average all - 4 st3 Average all - 10 st4 Average all - 7 st5 10 - 1 st6 Step1 + Step5 st7 Step6 + Step4 | st1 Average all - 3 st2 Average all - 10 st3 Average all - 1 st4 ...
6
submit
17:53
44 47 50 53 | 44 45 45 46 53
st1 Average all - 10 st2 Average all - 4 st3 Average all - 10 st4 Average all - 7 st5 10 - 1 st6 Step1 + Step5 st7 Step6 + Step4 st8 Step7 + Step2 st9 Step8 + Step3 | st1 Average all - 3 st2 Avera...
-------------------------------------------------------
Session: L-7bb916cc:120f8188b5f:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
deleteAll
1:43
44 47 50 53 | 44 45 45 46 53
st1 Count all | st1 Count all
2
delete
2:55
44 47 50 53 | 44 45 45 46 53
st1 10 - 1 | st1
3
submit
3:16
44 47 50 53 | 44 45 45 46 53
st1 7 - 1 | st1 3 - 1
4
get new case
4:9
-
-
5
submit
4:56
44 44 46 46 | 44 44 46 52
st1 3 - 1 | st1 9 - 1
6
submit
6:12
44 44 46 46 | 44 44 46 52
st1 3 - 1 | st1 9 - 1
7
get new case
6:28
-
-
8
deleteAll
7:5
44 44 46 52 | 44 46 46 52
st1 9 - 1 | st1
9
deleteAll
7:25
44 44 46 52 | 44 46 46 52
st1 Count all | st1 Count
10
deleteAll
8:29
44 44 46 52 | 44 46 46 52
st1 Median all | st1 Median all
11
submit
9:28
44 44 46 52 | 44 46 46 52
st1 Median all | st1 Median all
12
get new case
11:36
-
-
13
deleteAll
12:30
45 48 51 | 45 45 48 48 51 51
st1 Median all | st1 Median all
14
deleteAll
12:44
45 48 51 | 45 45 48 48 51 51
st1 Average all | st1 Average all
15
submit
13:5
45 48 51 | 45 45 48 48 51 51
st1 Sum all | st1 Sum all
-------------------------------------------------------
Session: L68f494a4:120fcfd39b6:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
deleteAll
0:33
44 47 50 53 | 44 45 45 46 53
st1 4 - 1 | st1 2 - 1
2
submit
1:17
44 47 50 53 | 44 45 45 46 53
st1 4 - 1 | st1 2 - 1
3
get new case
1:29
-
-
4
submit
1:50
44 45 46 53 57 | 44 45 46 49 55
st1 14 - 1 | st1 12 - 1
5
get new case
1:57
-
-
6
submit
2:23
44 45 46 53 57 | 44 47 48 51 57
st1 3 - 1 | st1 5 - 1
7
get new case
2:42
-
-
8
submit
3:2
44 45 47 48 | 44 44 48 53
st1 5 - 1 | st1 10 - 1
9
get new case
3:12
-
-
10
submit
3:41
44 44 48 53 | 44 46 48 53
st1 5 - 1 | st1 3 - 1
11
get new case
3:53
-
-
12
submit
4:10
44 45 46 48 51 | 44 46 49 53 56
st1 8 - 1 | st1 13 - 1
13
get new case
4:19
-
-
14
deleteAll
4:35
44 47 49 51 | 44 45 50 51
st1 8 - | st1
15
submit
4:57
44 47 49 51 | 44 45 50 51
st1 4 - 1 | st1 2 - 1
16
get new case
5:6
-
-
17
deleteAll
6:19
45 48 51 | 45 45 48 48 51 51
st1 8 - 2 | st1 8 - 2 st2
18
submit
7:7
45 48 51 | 45 45 48 48 51 51
st1 Count all | st1 Count all
19
get new case
7:41
-
-
20
submit
8:7
46 50 51 | 46 46 50 50 51 51
st1 Count all | st1 Count all
21
submit
9:25
46 50 51 | 46 46 50 50 51 51
st1 Count all | st1 Count all
22
submit
9:53
46 50 51 | 46 46 50 50 51 51
st1 Average all | st1 Average all
23
get new case
10:2
-
-
24
deleteAll
10:28
50 50 54 54 55 55 | 46 46 50 50 51 51
st1 Sum all | st1 Average all
25
submit
10:38
50 50 54 54 55 55 | 46 46 50 50 51 51
st1 Average all | st1 Average all
26
submit
11:15
50 50 54 54 55 55 | 46 46 50 50 51 51
st1 Count all | st1 Count all
27
get new case
11:25
-
-
28
deleteAll
12:3
49 52 52 54 | 49 49 52 54 54
st1 Count all | st1 Count all
29
deleteAll
12:18
49 52 52 54 | 49 49 52 54 54
st1 Average all | st1 Average all
30
deleteAll
12:46
49 52 52 54 | 49 49 52 54 54
st1 Median all | st1 Median all
31
deleteAll
13:18
49 52 52 54 | 49 49 52 54 54
st1 Average choose... Count all | st1 Sum all
32
deleteAll
14:29
49 52 52 54 | 49 49 52 54 54
st1 11 - 9 | st1 11 - 9 st2
33
deleteAll
14:56
49 52 52 54 | 49 49 52 54 54
st1 9 | st1
34
deleteAll
15:25
49 52 52 54 | 49 49 52 54 54
st1 Count all | st1 Count all
35
deleteAll
17:27
49 52 52 54 | 49 49 52 54 54
st1 11 + 6 | st1 11
36
deleteAll
18:42
49 52 52 54 | 49 49 52 54 54
st1 9 x 9 | st1 11 x 11
-------------------------------------------------------
Session: L-5bacd7a1:120edcb6ed9:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
delete
0:20
44 47 50 53 | 44 45 45 46 53
st1 10 - | st1
2
submit
2:7
44 47 50 53 | 44 45 45 46 53
st1 7 - 4 | st1 3 - 2
3
get new case
2:28
-
-
4
submit
3:2
45 46 50 55 56 | 45 46 47 50 53
st1 13 - 2 | st1 10 - 2
5
get new case
3:15
-
-
6
submit
4:0
45 46 50 55 56 | 45 49 50 52 56
st1 12 - 3 | st1 9 - 6
7
get new case
4:10
-
-
8
submit
4:29
49 50 52 52 | 46 49 52 55
st1 9 - 6 | st1 12 - 3
9
get new case
4:50
-
-
10
submit
6:7
46 49 52 55 | 46 50 51 55
st1 9 - 6 | st1 8 - 7
11
get new case
6:16
-
-
12
submit
6:39
50 51 55 56 56 | 43 44 50 51 57
st1 13 - 7 | st1 14 - 0
13
get new case
6:52
-
-
14
deleteAll
7:36
50 52 54 56 | 50 51 55 56
st1 13 - 11 | st1
15
submit
7:57
50 52 54 56 | 50 51 55 56
st1 11 - 9 | st1 12 - 8
16
get new case
8:12
-
-
17
submit
8:37
46 47 51 52 53 | 44 47 51 53 55
st1 10 - 3 | st1 12 - 1
18
get new case
8:48
-
-
19
submit
9:29
45 48 51 | 45 45 48 48 51 51
st1 8 - 2 | st1 8 - 2
20
get new case
9:46
-
-
21
submit
10:12
46 50 51 | 46 46 50 50 51 51
st1 8 - 3 | st1 8 - 3
22
get new case
10:51
-
-
23
deleteAll
11:24
47 48 49 54 55 | 47 52 53 54 55
st1 11 - 5 | st1 11 - 9
24
deleteAll
12:45
47 48 49 54 55 | 47 52 53 54 55
st1 11 - | st1
-------------------------------------------------------
Session: L-e22e239:120edcb3172:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
submit
0:34
44 47 50 53 | 44 45 45 46 53
st1 10 - 1 | st1 10 - 1
2
submit
2:30
44 47 50 53 | 44 45 45 46 53
st1 Average all | st1 Average all
3
get new case
3:4
-
-
4
deleteAll
4:54
48 49 49 50 57 | 44 45 45 46 53
st1 Average all | st1 Average all
5
submit
5:54
48 49 49 50 57 | 44 45 45 46 53
st1 14 - 5 | st1 10 - 1
6
get new case
6:35
-
-
7
submit
8:54
44 45 45 46 53 | 44 46 46 46 53
st1 3 - 2 | st1 3 - 3
8
get new case
9:35
-
-
9
submit
10:27
46 46 51 51 54 | 46 46 49 55 57
st1 11 - 3 | st1 14 - 3
10
get new case
11:6
-
-
11
submit
12:23
46 46 49 55 57 | 46 49 50 52 57
st1 Median all | st1 Median all
-------------------------------------------------------
Session: L2a1d096a:120f7d9f5d3:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
submit
1:10
44 47 50 53 | 44 45 45 46 53
st1 Median all | st1 Median all
2
get new case
1:28
-
-
3
submit
2:5
45 48 51 | 45 45 48 48 51 51
st1 Median all | st1 Median all
4
get new case
2:25
-
-
5
submit
2:53
46 50 51 | 46 46 50 50 51 51
st1 Median all | st1 Median all
6
get new case
3:4
-
-
7
submit
3:57
44 46 48 50 52 | 44 45 46 46 52
st1 Median all | st1 Median all
8
get new case
4:14
-
-
9
deleteAll
5:4
45 48 49 49 50 53 | 45 46 48 50 52 53
st1 Median all | st1 Median all
10
deleteAll
5:33
45 48 49 49 50 53 | 45 46 48 50 52 53
st1 Average all | st1 Average all
11
deleteAll
5:52
45 48 49 49 50 53 | 45 46 48 50 52 53
st1 Count all | st1 Average all
12
deleteAll
6:11
45 48 49 49 50 53 | 45 46 48 50 52 53
st1 Count all | st1 Count all
13
deleteAll
6:39
45 48 49 49 50 53 | 45 46 48 50 52 53
st1 Sum all | st1 Sum all
14
deleteAll
8:11
45 48 49 49 50 53 | 45 46 48 50 52 53
st1 10 / 2 | st1 10
15
submit
11:18
45 48 49 49 50 53 | 45 46 48 50 52 53
st1 6 - 6 | st1 7 - 5
16
get new case
11:42
-
-
17
deleteAll
12:11
47 49 49 54 55 | 47 49 49 51 51
st1 6 | st1
18
submit
13:10
47 49 49 54 55 | 47 49 49 51 51
st1 Average all | st1 Average all
19
get new case
13:28
-
-
20
deleteAll
14:6
51 53 53 55 55 | 47 49 49 51 51
st1 Average all | st1 Average all
21
deleteAll
14:58
51 53 53 55 55 | 47 49 49 51 51
st1 Median all | st1 Median all
22
submit
15:55
51 53 53 55 55 | 47 49 49 51 51
st1 12 - 10 | st1 8 - 6
23
get new case
16:22
-
-
24
submit
17:8
46 47 51 52 53 | 44 47 51 53 55
st1 10 - 3 | st1 12 - 1
25
get new case
17:27
-
-
-------------------------------------------------------
Session: L45ac8b86:120f2b33c23:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
submit
1:19
44 47 50 53 | 44 45 45 46 53
st1 10 - 1 st2 7 - 4 st3 Step1 + Step2 | st1 10 - 1 st2 3 - 2 st3 Step1 + Step2
2
get new case
1:40
-
-
3
delete
2:23
44 45 45 45 53 | 44 44 45 53 53
st1 10 - 1 st2 3 | st1
4
delete
3:48
44 45 45 45 53 | 44 44 45 53 53
st1 10 - 1 st2 10 - 2 st3 Step1 + Step2 | st1 10 - 1 st2 10 - 2 st3 Step1 + Step2
5
deleteAll
4:12
44 45 45 45 53 | 44 44 45 53 53
st1 10 - 1 st2 10 - 2 | st1 10 - 1 st2 10 - 2
6
submit
6:7
44 45 45 45 53 | 44 44 45 53 53
st1 10 - 1 st2 2 - 2 st3 Step1 + Step2 | st1 10 - 1 st2 10 - 1 st3 Step1 + Step2
7
get new case
6:43
-
-
8
submit
8:28
44 44 45 45 46 | 44 44 45 45 51
st1 3 - 1 st2 2 - 1 st3 Step1 + Step2 | st1 8 - 1 st2 2 - 1 st3 Step1 + Step2
9
get new case
9:33
-
-
10
submit
11:29
44 45 45 45 46 | 44 44 45 46 46
st1 3 - 1 st2 2 - 2 st3 Step1 + Step2 | st1 3 - 1 st2 3 - 1 st3 Step1 + Step2
11
get new case
14:14
-
-
-------------------------------------------------------
Session: L6f07cfe6:120edcb473c:-8000
action
timestamp
cases
tried methods
0
get new case
0:0
-
-
1
submit
1:24
44 47 50 53 | 44 45 45 46 53
st1 10 - 1 st2 7 - 4 st3 Step1 + Step2 | st1 10 - 1 st2 3 - 2 st3 Step1 + Step2
2
get new case
1:55
-
-
3
delete
2:50
44 45 45 45 53 | 44 44 45 53 53
st1 10 - 2 | st1
4
submit
5:21
44 45 45 45 53 | 44 44 45 53 53
st1 10 - 1 st2 2 - 2 st3 Step1 + Step2 | st1 10 - 1 st2 10 - 2 st3 Step1 + Step2
5
get new case
5:40
-
-
6
submit
7:47
46 50 51 | 46 46 50 50 51 51
st1 8 - 3 | st1 8 - 3
7
get new case
11:29
-
-
8
deleteAll
13:39
46 46 50 50 51 51 | 46 48 49 49 50 51
st1 8 + 3 st2 8 + 7 st3 7 + 3 st4 Step1 - Step2 st5 Step4 - Step3 | st1
-------------------------------------------------------
We invent 25 sudonames for ur 25 sessions accross bth activities.
In [7]:
pseudonyms = ["Alice","Bob","Carl","David","Estelle","Frida","George","Harry","Isaac","Jack","Kelly","Laila","Marie","Nathan","Orlando","Prince","Quin","Raphael","Sophie","Travis","Ursula","Venus","William","Xavier","Yan","Zelda"]
session_pairs = [("L70970875:120f77e742b:-8000",'Trampoline'),
("L-32a989cf:120ecd7e93b:-8000",'Trampoline'),
("L40bb98dd:120c3a7683a:-8000",'Trampoline'),
("L-7821f52f:120f7fb42ba:-8000",'Trampoline'),
("L651ef9df:120f7fb65f2:-8000",'Trampoline'),
("L46c6b7c:120ed2665a4:-8000",'Trampoline'),
("L-10f11766:120ecd4f63a:-8000",'Trampoline'),
("L-160920ae:120ed3b11b6:-8000",'Trampoline'),
("L-2567b17a:120eda25685:-8000","Tramoline"),
("L-23727b5d:120fc875dd6:-8000","KanD"),
("L-4af1736f:120fc85c498:-8000","KanD"),
("Ld1a3562:120fc85ee39:-8000","KanD"),
("L5cdf7922:120f1e34b2a:-8000","KanD"),
("L6203b1fe:120f1e535b4:-8000","KanD"),
("L-7fa003de:120f2365e41:-8000","KanD"),
("L4739cf0e:120f2367488:-8000","KanD"),
("L-3a693a9:120f818907f:-8000","KanD"),
("L-6425781a:120fcfdb07c:-8000","KanD"),
("L-7bb916cc:120f8188b5f:-8000","KanD"),
("L68f494a4:120fcfd39b6:-8000","KanD"),
("L-5bacd7a1:120edcb6ed9:-8000","KanD"),
("L-e22e239:120edcb3172:-8000","KanD"),
("L2a1d096a:120f7d9f5d3:-8000","KanD"),
("L45ac8b86:120f2b33c23:-8000","KanD"),
("L6f07cfe6:120edcb473c:-8000","KanD")]
In [12]:
%aimport utils
writer = pd.ExcelWriter('tried_methods_all_pairs_activities.xlsx')
mega_df = pd.DataFrame()
for i,(session,activity) in enumerate(session_pairs):
pseudo = pseudonyms[i]
df = prepare_session(df_all,session)
ideas = get_key_ideas(df)
ideas.insert(0,'pseudonym',pseudo)
ideas.insert(0,'session',session)
mega_df = pd.concat([mega_df,ideas])
mega_df.to_excel(writer,'Sheet1',index=False)
writer.save()
print 'Done'
Done
In [9]:
from matplotlib.backends.backend_pdf import PdfPages
In [10]:
%aimport viz_utils
with PdfPages('viz_all_pairs_activities.pdf') as pdf:
for i,(session,activity) in enumerate(session_pairs):
pseudo = pseudonyms[i]
df = prepare_session(df_all,session)
plt = plot(df,to_plot,colors, column_to_use, function_to_use,for_export=True)
# plt.figure(figsize=(20,12))
plt.title("{0} - {1} - {2}".format(activity,pseudo,session),fontsize=25)
plt.tight_layout()
pdf.savefig()
plt.close()
# ideas = get_key_ideas(df)
print 'Done'
Done
Content source: sperez8/iLab-viz
Similar notebooks: