In [2]:
import pandas as pd
pd.set_option('display.max_columns', 500)
def a1_notation(n):
string = ""
while n > 0:
n, remainder = divmod(n - 1, 26)
string = chr(65 + remainder) + string
return string
In [3]:
from random import random
In [4]:
random()
Out[4]:
0.15268578265054622
In [5]:
[round(random() * 100) for x in alist]
Out[5]:
[20,
74,
52,
30,
61,
48,
80,
90,
79,
44,
50,
74,
16,
51,
14,
91,
12,
17,
85,
44,
84,
6,
57,
71,
76,
18,
35,
47,
11,
53]
In [7]:
alist = list(range(1, 31))
list_of_lists = [[round(random() * 100) for x in alist] for x in alist]
A1_list = [a1_notation(x) for x in alist]
df = pd.DataFrame(list_of_lists, columns=A1_list)
df
Out[7]:
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
0
37
69
67
38
78
43
89
74
20
88
18
46
13
24
66
70
7
3
72
34
1
36
21
48
8
69
86
73
60
65
1
24
33
42
2
62
89
2
40
44
21
48
36
70
46
95
51
81
2
5
55
7
23
94
65
20
22
85
7
49
9
2
52
65
61
25
40
93
51
62
22
47
30
96
91
78
80
85
66
37
85
8
77
71
64
79
29
4
73
94
3
56
3
81
90
19
49
87
63
29
60
54
10
59
48
45
8
84
71
2
56
61
82
3
16
19
17
16
76
4
82
43
1
4
62
81
86
28
99
98
1
30
61
18
94
71
70
43
16
46
37
68
39
59
82
7
48
3
38
60
61
66
46
49
5
32
41
45
78
64
78
64
47
76
69
13
24
55
18
15
10
15
99
8
17
90
98
8
95
13
2
55
52
14
42
6
67
7
94
2
88
27
86
24
97
49
35
88
13
73
23
92
7
45
80
74
46
89
10
42
67
42
39
22
5
90
7
20
60
48
91
48
19
34
75
87
29
63
84
70
98
7
64
3
83
90
57
81
25
81
11
81
63
20
25
39
25
8
21
54
11
84
37
13
64
57
56
51
73
59
44
63
14
53
83
44
5
55
62
12
26
79
23
10
11
95
30
92
9
16
11
65
66
59
68
80
28
52
77
97
26
82
91
21
78
50
55
45
63
52
39
62
88
81
47
69
31
27
87
10
93
58
10
27
48
82
10
63
21
44
83
89
14
15
61
18
11
9
70
64
67
99
5
17
70
51
1
5
41
24
11
86
51
17
74
68
80
73
15
18
3
64
15
84
36
44
21
39
12
47
50
67
20
5
91
66
67
79
84
55
81
12
85
24
89
19
35
20
34
77
54
84
47
74
82
43
46
84
45
82
4
33
15
39
78
26
29
7
29
31
22
13
13
44
79
96
82
97
22
95
10
79
60
44
75
41
66
66
51
17
99
50
62
53
82
87
33
54
36
54
23
29
4
14
82
13
30
85
26
49
88
32
55
33
65
30
29
62
94
62
90
99
38
78
27
40
42
38
3
71
79
40
60
49
15
79
31
24
94
97
67
39
32
92
22
95
50
67
84
90
67
36
23
77
82
34
81
74
71
65
36
39
97
53
14
16
96
69
1
14
10
10
49
17
49
87
62
35
56
2
94
74
61
10
31
84
52
68
38
28
76
3
3
17
95
26
17
19
62
43
59
8
69
60
15
47
49
99
1
61
5
79
84
5
5
92
99
18
3
45
72
63
3
55
10
83
42
18
38
29
86
71
8
66
41
86
69
54
80
69
83
17
23
91
25
50
79
30
80
42
83
48
11
50
83
49
68
80
19
75
35
99
83
11
34
20
33
89
74
76
86
71
17
15
46
27
92
62
21
60
47
65
65
97
32
75
15
88
42
20
27
33
1
68
88
55
2
50
75
43
53
53
5
24
28
50
32
47
82
72
44
42
6
96
86
25
62
34
64
20
21
36
14
94
36
49
43
71
35
85
15
73
97
70
31
12
88
40
30
82
99
19
25
93
65
28
7
40
83
30
80
22
6
64
16
7
63
66
14
78
44
15
35
19
59
44
64
41
52
66
89
14
92
72
66
45
63
75
51
94
66
89
23
79
10
53
94
86
49
69
74
95
45
67
80
65
81
3
6
51
82
78
30
78
56
89
73
3
87
94
62
84
10
24
21
2
47
55
53
36
18
67
45
46
32
22
11
4
85
14
62
75
9
14
9
35
51
51
60
72
1
27
54
22
25
87
12
12
73
50
62
73
78
4
93
7
13
28
8
66
7
23
61
90
59
73
84
15
26
20
67
97
24
61
19
26
72
38
27
31
29
95
86
11
31
37
34
90
73
67
40
75
21
1
39
1
4
69
92
59
8
95
51
17
62
15
27
97
33
13
2
48
11
86
10
70
93
39
81
44
29
1
97
16
5
45
6
8
88
62
96
77
37
29
57
62
77
28
13
19
7
14
87
61
37
72
31
62
22
77
27
64
30
47
35
74
50
48
54
87
41
64
40
27
81
48
1
90
29
2
88
81
95
78
79
11
68
91
87
16
46
79
50
91
45
77
74
34
56
8
76
70
5
77
26
30
38
20
36
In [8]:
df['B']
Out[8]:
0 69
1 33
2 65
3 90
4 81
5 41
6 7
7 60
8 54
9 11
10 58
11 51
12 24
13 79
14 13
15 31
16 69
17 62
18 29
19 35
20 33
21 14
22 64
23 10
24 2
25 12
26 38
27 33
28 19
29 88
Name: B, dtype: int64
In [9]:
df[['B', 'D', 'F', 'H', 'J']]
Out[9]:
B
D
F
H
J
0
69
38
43
74
88
1
33
2
89
40
21
2
65
25
93
62
47
3
90
49
63
60
10
4
81
28
98
30
18
5
41
78
78
47
69
6
7
2
27
24
49
7
60
91
19
75
29
8
54
84
13
57
51
9
11
66
68
28
77
10
58
27
82
63
44
11
51
74
80
15
3
12
24
19
20
77
84
13
79
82
22
10
60
14
13
85
49
32
33
15
31
94
67
32
22
16
69
14
10
17
87
17
62
59
69
15
49
18
29
71
66
86
54
19
35
83
34
33
74
20
33
68
55
50
43
21
14
36
43
35
15
22
64
7
66
78
15
23
10
94
49
74
45
24
2
55
36
67
46
25
12
73
62
78
93
26
38
31
95
11
37
27
33
2
11
10
93
28
19
14
61
72
62
29
88
95
79
68
87
In [10]:
df['F'] = 'FOO'
df
Out[10]:
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
0
37
69
67
38
78
FOO
89
74
20
88
18
46
13
24
66
70
7
3
72
34
1
36
21
48
8
69
86
73
60
65
1
24
33
42
2
62
FOO
2
40
44
21
48
36
70
46
95
51
81
2
5
55
7
23
94
65
20
22
85
7
49
9
2
52
65
61
25
40
FOO
51
62
22
47
30
96
91
78
80
85
66
37
85
8
77
71
64
79
29
4
73
94
3
56
3
81
90
19
49
87
FOO
29
60
54
10
59
48
45
8
84
71
2
56
61
82
3
16
19
17
16
76
4
82
43
1
4
62
81
86
28
99
FOO
1
30
61
18
94
71
70
43
16
46
37
68
39
59
82
7
48
3
38
60
61
66
46
49
5
32
41
45
78
64
FOO
64
47
76
69
13
24
55
18
15
10
15
99
8
17
90
98
8
95
13
2
55
52
14
42
6
67
7
94
2
88
FOO
86
24
97
49
35
88
13
73
23
92
7
45
80
74
46
89
10
42
67
42
39
22
5
90
7
20
60
48
91
48
FOO
34
75
87
29
63
84
70
98
7
64
3
83
90
57
81
25
81
11
81
63
20
25
39
25
8
21
54
11
84
37
FOO
64
57
56
51
73
59
44
63
14
53
83
44
5
55
62
12
26
79
23
10
11
95
30
92
9
16
11
65
66
59
FOO
80
28
52
77
97
26
82
91
21
78
50
55
45
63
52
39
62
88
81
47
69
31
27
87
10
93
58
10
27
48
FOO
10
63
21
44
83
89
14
15
61
18
11
9
70
64
67
99
5
17
70
51
1
5
41
24
11
86
51
17
74
68
FOO
73
15
18
3
64
15
84
36
44
21
39
12
47
50
67
20
5
91
66
67
79
84
55
81
12
85
24
89
19
35
FOO
34
77
54
84
47
74
82
43
46
84
45
82
4
33
15
39
78
26
29
7
29
31
22
13
13
44
79
96
82
97
FOO
95
10
79
60
44
75
41
66
66
51
17
99
50
62
53
82
87
33
54
36
54
23
29
4
14
82
13
30
85
26
FOO
88
32
55
33
65
30
29
62
94
62
90
99
38
78
27
40
42
38
3
71
79
40
60
49
15
79
31
24
94
97
FOO
39
32
92
22
95
50
67
84
90
67
36
23
77
82
34
81
74
71
65
36
39
97
53
14
16
96
69
1
14
10
FOO
49
17
49
87
62
35
56
2
94
74
61
10
31
84
52
68
38
28
76
3
3
17
95
26
17
19
62
43
59
8
FOO
60
15
47
49
99
1
61
5
79
84
5
5
92
99
18
3
45
72
63
3
55
10
83
42
18
38
29
86
71
8
FOO
41
86
69
54
80
69
83
17
23
91
25
50
79
30
80
42
83
48
11
50
83
49
68
80
19
75
35
99
83
11
FOO
20
33
89
74
76
86
71
17
15
46
27
92
62
21
60
47
65
65
97
32
75
15
88
42
20
27
33
1
68
88
FOO
2
50
75
43
53
53
5
24
28
50
32
47
82
72
44
42
6
96
86
25
62
34
64
20
21
36
14
94
36
49
FOO
71
35
85
15
73
97
70
31
12
88
40
30
82
99
19
25
93
65
28
7
40
83
30
80
22
6
64
16
7
63
FOO
14
78
44
15
35
19
59
44
64
41
52
66
89
14
92
72
66
45
63
75
51
94
66
89
23
79
10
53
94
86
FOO
69
74
95
45
67
80
65
81
3
6
51
82
78
30
78
56
89
73
3
87
94
62
84
10
24
21
2
47
55
53
FOO
18
67
45
46
32
22
11
4
85
14
62
75
9
14
9
35
51
51
60
72
1
27
54
22
25
87
12
12
73
50
FOO
73
78
4
93
7
13
28
8
66
7
23
61
90
59
73
84
15
26
20
67
97
24
61
19
26
72
38
27
31
29
FOO
86
11
31
37
34
90
73
67
40
75
21
1
39
1
4
69
92
59
8
95
51
17
62
15
27
97
33
13
2
48
FOO
86
10
70
93
39
81
44
29
1
97
16
5
45
6
8
88
62
96
77
37
29
57
62
77
28
13
19
7
14
87
FOO
37
72
31
62
22
77
27
64
30
47
35
74
50
48
54
87
41
64
40
27
81
48
1
90
29
2
88
81
95
78
FOO
11
68
91
87
16
46
79
50
91
45
77
74
34
56
8
76
70
5
77
26
30
38
20
36
In [11]:
df.loc[:,'G':'I'] = 'BAR'
df
Out[11]:
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
0
37
69
67
38
78
FOO
BAR
BAR
BAR
88
18
46
13
24
66
70
7
3
72
34
1
36
21
48
8
69
86
73
60
65
1
24
33
42
2
62
FOO
BAR
BAR
BAR
21
48
36
70
46
95
51
81
2
5
55
7
23
94
65
20
22
85
7
49
9
2
52
65
61
25
40
FOO
BAR
BAR
BAR
47
30
96
91
78
80
85
66
37
85
8
77
71
64
79
29
4
73
94
3
56
3
81
90
19
49
87
FOO
BAR
BAR
BAR
10
59
48
45
8
84
71
2
56
61
82
3
16
19
17
16
76
4
82
43
1
4
62
81
86
28
99
FOO
BAR
BAR
BAR
18
94
71
70
43
16
46
37
68
39
59
82
7
48
3
38
60
61
66
46
49
5
32
41
45
78
64
FOO
BAR
BAR
BAR
69
13
24
55
18
15
10
15
99
8
17
90
98
8
95
13
2
55
52
14
42
6
67
7
94
2
88
FOO
BAR
BAR
BAR
49
35
88
13
73
23
92
7
45
80
74
46
89
10
42
67
42
39
22
5
90
7
20
60
48
91
48
FOO
BAR
BAR
BAR
29
63
84
70
98
7
64
3
83
90
57
81
25
81
11
81
63
20
25
39
25
8
21
54
11
84
37
FOO
BAR
BAR
BAR
51
73
59
44
63
14
53
83
44
5
55
62
12
26
79
23
10
11
95
30
92
9
16
11
65
66
59
FOO
BAR
BAR
BAR
77
97
26
82
91
21
78
50
55
45
63
52
39
62
88
81
47
69
31
27
87
10
93
58
10
27
48
FOO
BAR
BAR
BAR
44
83
89
14
15
61
18
11
9
70
64
67
99
5
17
70
51
1
5
41
24
11
86
51
17
74
68
FOO
BAR
BAR
BAR
3
64
15
84
36
44
21
39
12
47
50
67
20
5
91
66
67
79
84
55
81
12
85
24
89
19
35
FOO
BAR
BAR
BAR
84
47
74
82
43
46
84
45
82
4
33
15
39
78
26
29
7
29
31
22
13
13
44
79
96
82
97
FOO
BAR
BAR
BAR
60
44
75
41
66
66
51
17
99
50
62
53
82
87
33
54
36
54
23
29
4
14
82
13
30
85
26
FOO
BAR
BAR
BAR
33
65
30
29
62
94
62
90
99
38
78
27
40
42
38
3
71
79
40
60
49
15
79
31
24
94
97
FOO
BAR
BAR
BAR
22
95
50
67
84
90
67
36
23
77
82
34
81
74
71
65
36
39
97
53
14
16
96
69
1
14
10
FOO
BAR
BAR
BAR
87
62
35
56
2
94
74
61
10
31
84
52
68
38
28
76
3
3
17
95
26
17
19
62
43
59
8
FOO
BAR
BAR
BAR
49
99
1
61
5
79
84
5
5
92
99
18
3
45
72
63
3
55
10
83
42
18
38
29
86
71
8
FOO
BAR
BAR
BAR
54
80
69
83
17
23
91
25
50
79
30
80
42
83
48
11
50
83
49
68
80
19
75
35
99
83
11
FOO
BAR
BAR
BAR
74
76
86
71
17
15
46
27
92
62
21
60
47
65
65
97
32
75
15
88
42
20
27
33
1
68
88
FOO
BAR
BAR
BAR
43
53
53
5
24
28
50
32
47
82
72
44
42
6
96
86
25
62
34
64
20
21
36
14
94
36
49
FOO
BAR
BAR
BAR
15
73
97
70
31
12
88
40
30
82
99
19
25
93
65
28
7
40
83
30
80
22
6
64
16
7
63
FOO
BAR
BAR
BAR
15
35
19
59
44
64
41
52
66
89
14
92
72
66
45
63
75
51
94
66
89
23
79
10
53
94
86
FOO
BAR
BAR
BAR
45
67
80
65
81
3
6
51
82
78
30
78
56
89
73
3
87
94
62
84
10
24
21
2
47
55
53
FOO
BAR
BAR
BAR
46
32
22
11
4
85
14
62
75
9
14
9
35
51
51
60
72
1
27
54
22
25
87
12
12
73
50
FOO
BAR
BAR
BAR
93
7
13
28
8
66
7
23
61
90
59
73
84
15
26
20
67
97
24
61
19
26
72
38
27
31
29
FOO
BAR
BAR
BAR
37
34
90
73
67
40
75
21
1
39
1
4
69
92
59
8
95
51
17
62
15
27
97
33
13
2
48
FOO
BAR
BAR
BAR
93
39
81
44
29
1
97
16
5
45
6
8
88
62
96
77
37
29
57
62
77
28
13
19
7
14
87
FOO
BAR
BAR
BAR
62
22
77
27
64
30
47
35
74
50
48
54
87
41
64
40
27
81
48
1
90
29
2
88
81
95
78
FOO
BAR
BAR
BAR
87
16
46
79
50
91
45
77
74
34
56
8
76
70
5
77
26
30
38
20
36
In [16]:
df[['T', 'V']] = 'SPAM'
df
Out[16]:
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
0
63
80
15
43
41
FOO
BAR
BAR
BAR
30
65
1
65
45
6
55
72
7
50
SPAM
7
SPAM
40
68
26
6
24
94
89
48
1
25
30
13
93
21
FOO
BAR
BAR
BAR
11
3
58
54
46
36
28
14
28
98
SPAM
21
SPAM
61
52
52
21
59
69
48
68
2
96
64
85
54
42
FOO
BAR
BAR
BAR
85
51
63
77
23
46
32
92
29
89
SPAM
15
SPAM
4
9
50
40
72
88
64
31
3
30
15
15
10
70
FOO
BAR
BAR
BAR
73
5
49
12
97
77
95
33
28
1
SPAM
97
SPAM
54
92
54
79
3
40
43
91
4
8
28
33
25
54
FOO
BAR
BAR
BAR
54
76
19
40
81
5
100
10
5
64
SPAM
18
SPAM
59
66
96
60
92
98
73
27
5
58
87
33
41
59
FOO
BAR
BAR
BAR
43
53
69
36
19
87
71
33
58
3
SPAM
65
SPAM
36
39
100
90
47
85
51
70
6
58
25
10
73
1
FOO
BAR
BAR
BAR
7
61
13
71
87
80
82
16
73
34
SPAM
59
SPAM
78
54
48
50
1
94
91
56
7
78
17
90
85
55
FOO
BAR
BAR
BAR
31
93
83
7
52
58
76
35
67
3
SPAM
18
SPAM
78
19
65
92
14
11
62
71
8
11
52
60
35
58
FOO
BAR
BAR
BAR
94
74
52
18
62
43
77
55
52
7
SPAM
38
SPAM
48
68
30
19
54
49
66
52
9
79
62
29
2
71
FOO
BAR
BAR
BAR
85
59
19
5
82
33
94
23
1
43
SPAM
79
SPAM
35
28
56
78
71
4
5
96
10
20
64
53
29
63
FOO
BAR
BAR
BAR
45
55
72
13
61
47
80
22
77
15
SPAM
14
SPAM
93
93
58
63
28
12
96
70
11
96
94
82
93
56
FOO
BAR
BAR
BAR
15
20
95
51
100
81
63
88
74
35
SPAM
14
SPAM
87
79
85
1
45
26
73
49
12
68
53
76
55
23
FOO
BAR
BAR
BAR
56
82
40
79
59
52
93
65
92
44
SPAM
50
SPAM
33
11
32
20
2
20
61
63
13
56
89
16
71
14
FOO
BAR
BAR
BAR
49
20
88
28
84
23
84
40
27
18
SPAM
90
SPAM
22
54
92
13
65
22
32
35
14
9
47
92
96
31
FOO
BAR
BAR
BAR
14
100
44
21
24
50
22
65
67
3
SPAM
51
SPAM
1
80
37
77
0
64
9
48
15
19
24
36
24
85
FOO
BAR
BAR
BAR
69
10
28
74
42
48
83
26
22
42
SPAM
93
SPAM
61
60
83
98
11
91
37
66
16
5
48
60
85
4
FOO
BAR
BAR
BAR
67
89
45
37
30
75
97
73
11
93
SPAM
91
SPAM
76
24
94
32
51
44
54
15
17
38
62
72
27
96
FOO
BAR
BAR
BAR
70
76
77
66
83
54
36
60
51
50
SPAM
74
SPAM
91
80
67
2
67
74
36
98
18
52
58
99
25
47
FOO
BAR
BAR
BAR
15
51
60
46
84
97
71
3
71
66
SPAM
92
SPAM
24
25
100
2
46
6
2
94
19
98
80
6
15
63
FOO
BAR
BAR
BAR
25
27
35
33
49
50
12
69
83
87
SPAM
81
SPAM
80
12
31
93
8
43
40
51
20
12
77
37
23
38
FOO
BAR
BAR
BAR
42
16
47
26
46
92
4
30
69
54
SPAM
74
SPAM
17
42
3
84
3
89
83
35
21
18
25
6
86
76
FOO
BAR
BAR
BAR
97
11
30
24
86
59
15
55
20
74
SPAM
18
SPAM
98
37
70
35
95
28
1
32
22
6
88
46
10
27
FOO
BAR
BAR
BAR
27
95
42
79
40
41
75
64
36
77
SPAM
100
SPAM
84
37
97
33
2
43
34
76
23
45
42
92
46
7
FOO
BAR
BAR
BAR
35
66
38
64
89
59
73
67
30
99
SPAM
60
SPAM
91
17
79
44
33
86
63
6
24
75
70
98
60
94
FOO
BAR
BAR
BAR
38
80
90
21
42
81
75
32
20
17
SPAM
84
SPAM
58
36
81
35
30
65
7
70
25
51
25
28
71
49
FOO
BAR
BAR
BAR
97
62
4
30
64
46
4
39
82
70
SPAM
37
SPAM
99
51
52
6
77
38
13
83
26
8
4
90
3
76
FOO
BAR
BAR
BAR
28
20
46
52
38
21
4
99
29
84
SPAM
95
SPAM
17
26
8
65
3
98
85
50
27
69
40
98
35
92
FOO
BAR
BAR
BAR
46
48
7
3
44
74
44
63
42
7
SPAM
92
SPAM
75
80
70
21
40
45
40
1
28
49
34
97
84
43
FOO
BAR
BAR
BAR
22
1
37
4
35
68
55
86
10
92
SPAM
9
SPAM
19
93
30
85
84
34
87
57
29
4
92
44
18
59
FOO
BAR
BAR
BAR
34
30
98
85
48
63
20
65
11
57
SPAM
15
SPAM
95
73
92
67
8
98
31
68
In [12]:
df.loc[:, 'Y':'AB'] = 'EGGS'
df
Out[12]:
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
0
37
69
67
38
78
FOO
BAR
BAR
BAR
88
18
46
13
24
66
70
7
3
72
34
1
36
21
48
EGGS
EGGS
EGGS
EGGS
60
65
1
24
33
42
2
62
FOO
BAR
BAR
BAR
21
48
36
70
46
95
51
81
2
5
55
7
23
94
65
EGGS
EGGS
EGGS
EGGS
49
9
2
52
65
61
25
40
FOO
BAR
BAR
BAR
47
30
96
91
78
80
85
66
37
85
8
77
71
64
79
EGGS
EGGS
EGGS
EGGS
3
56
3
81
90
19
49
87
FOO
BAR
BAR
BAR
10
59
48
45
8
84
71
2
56
61
82
3
16
19
17
EGGS
EGGS
EGGS
EGGS
43
1
4
62
81
86
28
99
FOO
BAR
BAR
BAR
18
94
71
70
43
16
46
37
68
39
59
82
7
48
3
EGGS
EGGS
EGGS
EGGS
46
49
5
32
41
45
78
64
FOO
BAR
BAR
BAR
69
13
24
55
18
15
10
15
99
8
17
90
98
8
95
EGGS
EGGS
EGGS
EGGS
14
42
6
67
7
94
2
88
FOO
BAR
BAR
BAR
49
35
88
13
73
23
92
7
45
80
74
46
89
10
42
EGGS
EGGS
EGGS
EGGS
5
90
7
20
60
48
91
48
FOO
BAR
BAR
BAR
29
63
84
70
98
7
64
3
83
90
57
81
25
81
11
EGGS
EGGS
EGGS
EGGS
39
25
8
21
54
11
84
37
FOO
BAR
BAR
BAR
51
73
59
44
63
14
53
83
44
5
55
62
12
26
79
EGGS
EGGS
EGGS
EGGS
30
92
9
16
11
65
66
59
FOO
BAR
BAR
BAR
77
97
26
82
91
21
78
50
55
45
63
52
39
62
88
EGGS
EGGS
EGGS
EGGS
27
87
10
93
58
10
27
48
FOO
BAR
BAR
BAR
44
83
89
14
15
61
18
11
9
70
64
67
99
5
17
EGGS
EGGS
EGGS
EGGS
41
24
11
86
51
17
74
68
FOO
BAR
BAR
BAR
3
64
15
84
36
44
21
39
12
47
50
67
20
5
91
EGGS
EGGS
EGGS
EGGS
55
81
12
85
24
89
19
35
FOO
BAR
BAR
BAR
84
47
74
82
43
46
84
45
82
4
33
15
39
78
26
EGGS
EGGS
EGGS
EGGS
22
13
13
44
79
96
82
97
FOO
BAR
BAR
BAR
60
44
75
41
66
66
51
17
99
50
62
53
82
87
33
EGGS
EGGS
EGGS
EGGS
29
4
14
82
13
30
85
26
FOO
BAR
BAR
BAR
33
65
30
29
62
94
62
90
99
38
78
27
40
42
38
EGGS
EGGS
EGGS
EGGS
60
49
15
79
31
24
94
97
FOO
BAR
BAR
BAR
22
95
50
67
84
90
67
36
23
77
82
34
81
74
71
EGGS
EGGS
EGGS
EGGS
53
14
16
96
69
1
14
10
FOO
BAR
BAR
BAR
87
62
35
56
2
94
74
61
10
31
84
52
68
38
28
EGGS
EGGS
EGGS
EGGS
95
26
17
19
62
43
59
8
FOO
BAR
BAR
BAR
49
99
1
61
5
79
84
5
5
92
99
18
3
45
72
EGGS
EGGS
EGGS
EGGS
83
42
18
38
29
86
71
8
FOO
BAR
BAR
BAR
54
80
69
83
17
23
91
25
50
79
30
80
42
83
48
EGGS
EGGS
EGGS
EGGS
68
80
19
75
35
99
83
11
FOO
BAR
BAR
BAR
74
76
86
71
17
15
46
27
92
62
21
60
47
65
65
EGGS
EGGS
EGGS
EGGS
88
42
20
27
33
1
68
88
FOO
BAR
BAR
BAR
43
53
53
5
24
28
50
32
47
82
72
44
42
6
96
EGGS
EGGS
EGGS
EGGS
64
20
21
36
14
94
36
49
FOO
BAR
BAR
BAR
15
73
97
70
31
12
88
40
30
82
99
19
25
93
65
EGGS
EGGS
EGGS
EGGS
30
80
22
6
64
16
7
63
FOO
BAR
BAR
BAR
15
35
19
59
44
64
41
52
66
89
14
92
72
66
45
EGGS
EGGS
EGGS
EGGS
66
89
23
79
10
53
94
86
FOO
BAR
BAR
BAR
45
67
80
65
81
3
6
51
82
78
30
78
56
89
73
EGGS
EGGS
EGGS
EGGS
84
10
24
21
2
47
55
53
FOO
BAR
BAR
BAR
46
32
22
11
4
85
14
62
75
9
14
9
35
51
51
EGGS
EGGS
EGGS
EGGS
54
22
25
87
12
12
73
50
FOO
BAR
BAR
BAR
93
7
13
28
8
66
7
23
61
90
59
73
84
15
26
EGGS
EGGS
EGGS
EGGS
61
19
26
72
38
27
31
29
FOO
BAR
BAR
BAR
37
34
90
73
67
40
75
21
1
39
1
4
69
92
59
EGGS
EGGS
EGGS
EGGS
62
15
27
97
33
13
2
48
FOO
BAR
BAR
BAR
93
39
81
44
29
1
97
16
5
45
6
8
88
62
96
EGGS
EGGS
EGGS
EGGS
62
77
28
13
19
7
14
87
FOO
BAR
BAR
BAR
62
22
77
27
64
30
47
35
74
50
48
54
87
41
64
EGGS
EGGS
EGGS
EGGS
1
90
29
2
88
81
95
78
FOO
BAR
BAR
BAR
87
16
46
79
50
91
45
77
74
34
56
8
76
70
5
EGGS
EGGS
EGGS
EGGS
20
36
In [13]:
df.A
Out[13]:
0 37
1 24
2 52
3 81
4 62
5 32
6 67
7 20
8 21
9 16
10 93
11 86
12 85
13 44
14 82
15 79
16 96
17 19
18 38
19 75
20 27
21 36
22 6
23 79
24 21
25 87
26 72
27 97
28 13
29 2
Name: A, dtype: int64
In [14]:
df.A > 75
Out[14]:
0 False
1 False
2 False
3 True
4 False
5 False
6 False
7 False
8 False
9 False
10 True
11 True
12 True
13 False
14 True
15 True
16 True
17 False
18 False
19 False
20 False
21 False
22 False
23 True
24 False
25 True
26 False
27 True
28 False
29 False
Name: A, dtype: bool
In [15]:
df.A[df.A > 75]
Out[15]:
3 81
10 93
11 86
12 85
14 82
15 79
16 96
23 79
25 87
27 97
Name: A, dtype: int64
In [16]:
df['A'][df.A > 75]
Out[16]:
3 81
10 93
11 86
12 85
14 82
15 79
16 96
23 79
25 87
27 97
Name: A, dtype: int64
In [17]:
df[df.A > 75]
Out[17]:
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
3
81
90
19
49
87
FOO
BAR
BAR
BAR
10
59
48
45
8
84
71
2
56
61
82
3
16
19
17
EGGS
EGGS
EGGS
EGGS
43
1
10
93
58
10
27
48
FOO
BAR
BAR
BAR
44
83
89
14
15
61
18
11
9
70
64
67
99
5
17
EGGS
EGGS
EGGS
EGGS
41
24
11
86
51
17
74
68
FOO
BAR
BAR
BAR
3
64
15
84
36
44
21
39
12
47
50
67
20
5
91
EGGS
EGGS
EGGS
EGGS
55
81
12
85
24
89
19
35
FOO
BAR
BAR
BAR
84
47
74
82
43
46
84
45
82
4
33
15
39
78
26
EGGS
EGGS
EGGS
EGGS
22
13
14
82
13
30
85
26
FOO
BAR
BAR
BAR
33
65
30
29
62
94
62
90
99
38
78
27
40
42
38
EGGS
EGGS
EGGS
EGGS
60
49
15
79
31
24
94
97
FOO
BAR
BAR
BAR
22
95
50
67
84
90
67
36
23
77
82
34
81
74
71
EGGS
EGGS
EGGS
EGGS
53
14
16
96
69
1
14
10
FOO
BAR
BAR
BAR
87
62
35
56
2
94
74
61
10
31
84
52
68
38
28
EGGS
EGGS
EGGS
EGGS
95
26
23
79
10
53
94
86
FOO
BAR
BAR
BAR
45
67
80
65
81
3
6
51
82
78
30
78
56
89
73
EGGS
EGGS
EGGS
EGGS
84
10
25
87
12
12
73
50
FOO
BAR
BAR
BAR
93
7
13
28
8
66
7
23
61
90
59
73
84
15
26
EGGS
EGGS
EGGS
EGGS
61
19
27
97
33
13
2
48
FOO
BAR
BAR
BAR
93
39
81
44
29
1
97
16
5
45
6
8
88
62
96
EGGS
EGGS
EGGS
EGGS
62
77
In [18]:
mask = df.A > 75
mask
Out[18]:
0 False
1 False
2 False
3 True
4 False
5 False
6 False
7 False
8 False
9 False
10 True
11 True
12 True
13 False
14 True
15 True
16 True
17 False
18 False
19 False
20 False
21 False
22 False
23 True
24 False
25 True
26 False
27 True
28 False
29 False
Name: A, dtype: bool
In [19]:
df[mask]
Out[19]:
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
3
81
90
19
49
87
FOO
BAR
BAR
BAR
10
59
48
45
8
84
71
2
56
61
82
3
16
19
17
EGGS
EGGS
EGGS
EGGS
43
1
10
93
58
10
27
48
FOO
BAR
BAR
BAR
44
83
89
14
15
61
18
11
9
70
64
67
99
5
17
EGGS
EGGS
EGGS
EGGS
41
24
11
86
51
17
74
68
FOO
BAR
BAR
BAR
3
64
15
84
36
44
21
39
12
47
50
67
20
5
91
EGGS
EGGS
EGGS
EGGS
55
81
12
85
24
89
19
35
FOO
BAR
BAR
BAR
84
47
74
82
43
46
84
45
82
4
33
15
39
78
26
EGGS
EGGS
EGGS
EGGS
22
13
14
82
13
30
85
26
FOO
BAR
BAR
BAR
33
65
30
29
62
94
62
90
99
38
78
27
40
42
38
EGGS
EGGS
EGGS
EGGS
60
49
15
79
31
24
94
97
FOO
BAR
BAR
BAR
22
95
50
67
84
90
67
36
23
77
82
34
81
74
71
EGGS
EGGS
EGGS
EGGS
53
14
16
96
69
1
14
10
FOO
BAR
BAR
BAR
87
62
35
56
2
94
74
61
10
31
84
52
68
38
28
EGGS
EGGS
EGGS
EGGS
95
26
23
79
10
53
94
86
FOO
BAR
BAR
BAR
45
67
80
65
81
3
6
51
82
78
30
78
56
89
73
EGGS
EGGS
EGGS
EGGS
84
10
25
87
12
12
73
50
FOO
BAR
BAR
BAR
93
7
13
28
8
66
7
23
61
90
59
73
84
15
26
EGGS
EGGS
EGGS
EGGS
61
19
27
97
33
13
2
48
FOO
BAR
BAR
BAR
93
39
81
44
29
1
97
16
5
45
6
8
88
62
96
EGGS
EGGS
EGGS
EGGS
62
77
In [20]:
(df.A > 45) & (df.A < 55)
Out[20]:
0 False
1 False
2 True
3 False
4 False
5 False
6 False
7 False
8 False
9 False
10 False
11 False
12 False
13 False
14 False
15 False
16 False
17 False
18 False
19 False
20 False
21 False
22 False
23 False
24 False
25 False
26 False
27 False
28 False
29 False
Name: A, dtype: bool
In [21]:
sweet_spot = (df.A > 40) & (df.A < 60)
df[sweet_spot]
Out[21]:
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
2
52
65
61
25
40
FOO
BAR
BAR
BAR
47
30
96
91
78
80
85
66
37
85
8
77
71
64
79
EGGS
EGGS
EGGS
EGGS
3
56
13
44
79
96
82
97
FOO
BAR
BAR
BAR
60
44
75
41
66
66
51
17
99
50
62
53
82
87
33
EGGS
EGGS
EGGS
EGGS
29
4
Content source: miklevin/pipulate
Similar notebooks: