import pandas as pd
df = pd.read_json("../football/footballdataset.json")
print(df)
AC AF AR AS AST AY AwayTeam B365A B365D B365H ... PSCH \
0 4 12 0 6 3 1 Leicester 6.50 4.50 1.53 ... 1.49
1 10 9 0 14 4 2 Man City 1.33 5.50 11.00 ... 11.75
2 5 11 0 10 5 3 Burnley 15.00 6.50 1.25 ... 1.33
3 9 19 0 8 6 3 Huddersfield 5.00 3.60 1.83 ... 1.79
4 7 10 0 9 1 1 Stoke 5.75 3.80 1.70 ... 1.82
.. .. .. .. .. ... .. ... ... ... ... ... ...
375 2 10 0 6 2 1 Chelsea 1.60 4.20 6.50 ... 4.85
376 12 10 0 13 2 1 Man City 1.39 5.00 9.00 ... 6.32
377 0 9 0 8 5 2 Stoke 4.20 3.79 1.90 ... 2.08
378 4 13 0 16 9 2 Leicester 9.00 6.00 1.33 ... 1.38
379 6 13 0 14 7 1 Everton 3.00 3.50 2.45 ... 2.35
PSD PSH Referee VCA VCD VCH WHA WHD WHH
0 4.55 1.53 M Dean 6.50 4.50 1.53 6.00 4.20 1.53
1 5.55 10.95 M Oliver 1.33 5.50 10.00 1.33 4.80 10.00
2 6.30 1.26 C Pawson 15.00 6.25 1.25 13.00 5.50 1.25
3 3.58 1.83 J Moss 5.00 3.60 1.83 5.00 3.30 1.80
4 3.83 1.70 N Swarbrick 5.75 3.80 1.70 5.50 3.50 1.70
.. ... ... ... ... ... ... ... ... ...
375 4.22 5.96 M Atkinson 1.60 4.20 6.00 1.57 4.00 6.50
376 5.11 8.06 A Marriner 1.44 5.00 7.50 1.40 4.50 8.50
377 3.72 1.91 A Taylor 4.20 3.75 1.90 4.00 3.75 1.91
378 5.95 1.33 C Pawson 9.50 5.75 1.33 9.00 6.00 1.30
379 3.51 2.36 G Scott 3.10 3.50 2.40 3.10 3.30 2.40
[380 rows x 65 columns]
print(df[['Referee', 'AST', 'AS', 'AwayTeam', 'HomeTeam']].to_string(index=False))
Referee AST AS AwayTeam HomeTeam
M Dean 3 6 Leicester Arsenal
M Oliver 4 14 Man City Brighton
C Pawson 5 10 Burnley Chelsea
J Moss 6 8 Huddersfield Crystal Palace
N Swarbrick 1 9 Stoke Everton
M Jones 0 4 Swansea Southampton
A Taylor 5 14 Liverpool Watford
R Madley 2 9 Bournemouth West Brom
M Atkinson 1 9 West Ham Man United
A Marriner 6 18 Tottenham Newcastle
R East 7 19 Watford Bournemouth
M Atkinson 1 8 West Brom Burnley
L Probert 2 5 Brighton Leicester
K Friend 1 4 Crystal Palace Liverpool
L Mason 8 16 West Ham Southampton
A Marriner 6 18 Arsenal Stoke
J Moss 8 17 Man United Swansea
C Pawson 5 13 Newcastle Huddersfield
A Taylor 2 9 Chelsea Tottenham
R Madley 2 7 Everton Man City
M Dean 8 19 Man City Bournemouth
A Marriner 3 7 Swansea Crystal Palace
S Attwell 3 6 Southampton Huddersfield
M Oliver 4 11 Leicester Man United
N Swarbrick 3 8 West Ham Newcastle
G Scott 2 16 Brighton Watford
J Moss 0 7 Everton Chelsea
C Pawson 0 8 Arsenal Liverpool
L Mason 3 13 Burnley Tottenham
A Taylor 2 16 Stoke West Brom
A Taylor 1 6 Bournemouth Arsenal
C Kavanagh 3 12 West Brom Brighton
G Scott 6 15 Tottenham Everton
L Mason 6 16 Chelsea Leicester
J Moss 3 10 Liverpool Man City
L Probert 3 12 Watford Southampton
N Swarbrick 8 18 Man United Stoke
M Oliver 5 23 Crystal Palace Burnley
M Jones 8 16 Newcastle Swansea
K Friend 2 10 Huddersfield West Ham
C Pawson 2 9 Brighton Bournemouth
R Madley 4 13 Southampton Crystal Palace
J Moss 1 10 Leicester Huddersfield
R East 4 5 Burnley Liverpool
S Attwell 4 13 Stoke Newcastle
M Dean 0 4 Swansea Tottenham
A Taylor 10 28 Man City Watford
P Tierney 1 9 West Ham West Brom
M Oliver 2 11 Arsenal Chelsea
A Marriner 3 7 Everton Man United
C Kavanagh 2 9 Huddersfield Burnley
M Atkinson 4 8 Bournemouth Everton
A Taylor 6 23 Liverpool Leicester
N Swarbrick 0 5 Crystal Palace Man City
C Pawson 4 9 Man United Southampton
M Dean 4 7 Chelsea Stoke
L Mason 4 8 Watford Swansea
M Oliver 5 15 Tottenham West Ham
A Marriner 5 17 Newcastle Brighton
R Madley 3 7 West Brom Arsenal
G Scott 1 8 Leicester Bournemouth
M Atkinson 6 17 Man City Chelsea
N Swarbrick 7 14 Tottenham Huddersfield
M Dean 1 6 Crystal Palace Man United
M Jones 3 21 Southampton Stoke
M Oliver 3 15 Watford West Brom
R East 1 6 Swansea West Ham
K Friend 1 9 Brighton Arsenal
J Moss 2 5 Burnley Everton
C Pawson 2 17 Liverpool Newcastle
S Attwell 6 8 West Ham Burnley
A Marriner 5 15 Chelsea Crystal Palace
M Atkinson 1 6 Man United Liverpool
C Pawson 1 5 Stoke Man City
P Tierney 2 7 Huddersfield Swansea
R Madley 1 5 Bournemouth Tottenham
N Swarbrick 6 9 Arsenal Watford
M Oliver 6 13 Everton Brighton
K Friend 5 19 Newcastle Southampton
M Dean 1 5 West Brom Leicester
M Atkinson 5 7 Brighton West Ham
J Moss 5 16 Watford Chelsea
L Mason 3 9 Man United Huddersfield
R East 0 6 Burnley Man City
S Attwell 0 10 Crystal Palace Newcastle
G Scott 2 7 West Brom Southampton
L Probert 3 7 Bournemouth Stoke
M Oliver 6 11 Leicester Swansea
C Pawson 14 30 Arsenal Everton
A Marriner 7 12 Liverpool Tottenham
L Mason 2 4 Swansea Arsenal
C Pawson 5 18 Chelsea Bournemouth
R Madley 2 6 West Ham Crystal Palace
K Friend 0 1 Huddersfield Liverpool
J Moss 4 13 Tottenham Man United
M Oliver 2 6 Stoke Watford
M Jones 5 15 Man City West Brom
N Swarbrick 1 6 Southampton Brighton
A Marriner 2 16 Everton Leicester
M Dean 5 12 Newcastle Burnley
R East 3 9 West Brom Huddersfield
P Tierney 6 16 Bournemouth Newcastle
L Probert 1 5 Burnley Southampton
R Madley 4 14 Leicester Stoke
M Dean 2 5 Brighton Swansea
N Swarbrick 7 15 Liverpool West Ham
A Taylor 2 10 Man United Chelsea
G Scott 3 11 Watford Everton
M Oliver 3 6 Arsenal Man City
K Friend 3 11 Crystal Palace Tottenham
M Dean 4 14 Tottenham Arsenal
L Probert 3 20 Huddersfield Bournemouth
M Atkinson 1 13 Swansea Burnley
A Taylor 5 8 Everton Crystal Palace
G Scott 4 12 Man City Leicester
M Jones 0 5 Southampton Liverpool
C Pawson 5 12 Newcastle Man United
J Moss 7 11 Chelsea West Brom
A Marriner 6 10 West Ham Watford
L Mason 6 13 Stoke Brighton
M Atkinson 2 7 Leicester West Ham
M Dean 3 9 Stoke Crystal Palace
M Oliver 3 11 Chelsea Liverpool
N Swarbrick 2 8 Brighton Man United
C Kavanagh 4 12 Watford Newcastle
S Attwell 5 9 Bournemouth Swansea
M Jones 2 5 West Brom Tottenham
L Mason 2 17 Arsenal Burnley
C Pawson 5 14 Man City Huddersfield
K Friend 2 5 Everton Southampton
A Marriner 4 10 Crystal Palace Brighton
A Taylor 6 18 Tottenham Leicester
J Moss 7 15 Man United Watford
L Probert 4 14 Newcastle West Brom
G Scott 2 7 Huddersfield Arsenal
R East 4 10 Burnley Bournemouth
N Swarbrick 0 2 Swansea Chelsea
M Oliver 3 7 West Ham Everton
P Tierney 2 7 Southampton Man City
M Atkinson 7 14 Liverpool Stoke
A Marriner 4 8 Man United Arsenal
G Scott 6 12 Liverpool Brighton
K Friend 2 8 Newcastle Chelsea
C Kavanagh 3 5 Huddersfield Everton
P Tierney 4 14 Burnley Leicester
C Pawson 3 10 Swansea Stoke
M Atkinson 2 8 Tottenham Watford
M Oliver 2 10 Crystal Palace West Brom
J Moss 4 15 Southampton Bournemouth
M Dean 4 7 West Ham Man City
L Probert 2 11 Watford Burnley
K Friend 5 11 Bournemouth Crystal Palace
S Attwell 2 7 Brighton Huddersfield
N Swarbrick 5 13 Leicester Newcastle
M Dean 1 7 West Brom Swansea
R East 3 4 Stoke Tottenham
A Taylor 2 19 Chelsea West Ham
C Pawson 2 3 Everton Liverpool
M Oliver 7 14 Man City Man United
R Madley 6 11 Arsenal Southampton
M Jones 7 14 Stoke Burnley
L Mason 2 7 Watford Crystal Palace
A Marriner 5 12 Chelsea Huddersfield
P Tierney 1 6 West Brom Liverpool
G Scott 7 14 Bournemouth Man United
M Atkinson 4 7 Everton Newcastle
C Kavanagh 11 16 Leicester Southampton
A Taylor 10 23 Man City Swansea
R Madley 4 7 Brighton Tottenham
J Moss 3 22 Arsenal West Ham
S Attwell 2 10 Newcastle Arsenal
C Kavanagh 6 11 Burnley Brighton
R East 2 6 Southampton Chelsea
M Atkinson 6 13 Crystal Palace Leicester
C Pawson 2 7 Tottenham Man City
G Scott 7 14 West Ham Stoke
M Oliver 9 15 Huddersfield Watford
A Marriner 7 21 Liverpool Bournemouth
A Taylor 3 8 Man United West Brom
J Moss 3 8 Swansea Everton
M Atkinson 9 14 Liverpool Arsenal
P Tierney 1 13 Watford Brighton
M Oliver 8 18 Tottenham Burnley
R Madley 8 25 Chelsea Everton
J Moss 6 19 Man United Leicester
M Jones 1 5 Bournemouth Man City
L Probert 3 10 Huddersfield Southampton
N Swarbrick 7 17 West Brom Stoke
C Pawson 5 13 Crystal Palace Swansea
L Mason 4 11 Newcastle West Ham
S Attwell 5 10 West Ham Bournemouth
M Dean 1 8 Brighton Chelsea
A Taylor 7 15 Stoke Huddersfield
K Friend 4 7 Swansea Liverpool
M Atkinson 2 3 Burnley Man United
G Scott 6 16 Southampton Tottenham
C Kavanagh 5 11 Leicester Watford
R East 3 7 Everton West Brom
A Marriner 6 22 Man City Newcastle
M Oliver 9 16 Arsenal Crystal Palace
L Probert 1 6 Everton Bournemouth
K Friend 1 1 Stoke Chelsea
P Tierney 4 11 Burnley Huddersfield
N Swarbrick 1 7 Leicester Liverpool
C Pawson 3 8 Southampton Man United
A Taylor 3 10 Brighton Newcastle
M Atkinson 4 9 Swansea Watford
J Moss 4 15 Man City Crystal Palace
M Dean 4 14 Arsenal West Brom
M Oliver 8 26 Bournemouth Brighton
R East 5 19 Liverpool Burnley
A Marriner 6 21 Man United Everton
G Scott 1 6 Huddersfield Leicester
C Kavanagh 6 14 Newcastle Stoke
L Mason 4 7 Watford Man City
S Attwell 4 11 Crystal Palace Southampton
R Madley 5 12 Tottenham Swansea
M Jones 3 10 West Brom West Ham
A Taylor 6 19 Chelsea Arsenal
M Dean 1 3 West Ham Tottenham
M Jones 1 14 Leicester Chelsea
M Oliver 2 8 Burnley Crystal Palace
J Moss 6 8 West Ham Huddersfield
G Scott 5 8 Swansea Newcastle
C Pawson 0 7 Everton Tottenham
R East 4 10 Southampton Watford
M Atkinson 1 13 Brighton West Brom
K Friend 3 12 Arsenal Bournemouth
A Marriner 4 11 Man City Liverpool
A Taylor 5 11 Stoke Man United
C Kavanagh 5 9 Crystal Palace Arsenal
J Moss 10 14 Chelsea Brighton
M Dean 2 12 Man United Burnley
S Attwell 5 15 West Brom Everton
L Probert 3 11 Watford Leicester
P Tierney 4 6 Newcastle Man City
M Oliver 3 6 Huddersfield Stoke
M Atkinson 3 8 Bournemouth West Ham
K Friend 2 17 Tottenham Southampton
N Swarbrick 4 21 Liverpool Swansea
K Friend 7 14 Liverpool Huddersfield
L Mason 4 9 Arsenal Swansea
N Swarbrick 3 9 Crystal Palace West Ham
L Probert 5 11 Bournemouth Chelsea
C Kavanagh 1 8 Leicester Everton
R Madley 1 3 West Brom Man City
S Hooper 2 11 Burnley Newcastle
M Dean 2 9 Brighton Southampton
J Moss 2 12 Watford Stoke
A Marriner 3 6 Man United Tottenham
N Swarbrick 2 11 Everton Arsenal
P Tierney 4 13 Stoke Bournemouth
R East 1 4 West Ham Brighton
M Atkinson 7 20 Man City Burnley
A Taylor 1 3 Swansea Leicester
S Attwell 0 4 Huddersfield Man United
M Oliver 5 13 Southampton West Brom
A Marriner 8 11 Newcastle Crystal Palace
J Moss 6 13 Tottenham Liverpool
M Dean 3 7 Chelsea Watford
J Moss 4 16 Crystal Palace Everton
M Jones 2 2 Leicester Man City
R Madley 6 14 Brighton Stoke
A Marriner 1 13 Burnley Swansea
A Taylor 1 6 Arsenal Tottenham
G Scott 4 11 Watford West Ham
M Oliver 2 7 Bournemouth Huddersfield
C Pawson 6 13 Man United Newcastle
M Atkinson 4 16 Liverpool Southampton
L Mason 1 8 West Brom Chelsea
R East 4 15 Newcastle Bournemouth
M Dean 1 11 Swansea Brighton
R Madley 6 13 Southampton Burnley
M Oliver 2 6 Stoke Leicester
S Attwell 4 7 West Ham Liverpool
A Taylor 2 7 Everton Watford
J Moss 7 16 Huddersfield West Brom
K Friend 4 14 Tottenham Crystal Palace
M Atkinson 7 14 Chelsea Man United
A Marriner 5 9 Man City Arsenal
C Kavanagh 4 10 Everton Burnley
L Probert 3 8 Bournemouth Leicester
G Scott 2 7 Newcastle Liverpool
A Taylor 3 12 Stoke Southampton
M Atkinson 2 7 West Ham Swansea
K Friend 3 3 Huddersfield Tottenham
P Tierney 2 9 West Brom Watford
S Attwell 7 15 Arsenal Brighton
M Oliver 0 3 Chelsea Man City
N Swarbrick 8 17 Man United Crystal Palace
A Taylor 2 9 Crystal Palace Chelsea
R East 4 10 Brighton Everton
M Oliver 0 0 Swansea Huddersfield
C Pawson 2 14 Liverpool Man United
A Marriner 2 6 Southampton Newcastle
R Madley 6 14 Leicester West Brom
L Mason 4 7 Burnley West Ham
M Atkinson 4 11 Watford Arsenal
M Dean 8 12 Tottenham Bournemouth
J Moss 6 17 Man City Stoke
G Scott 6 11 West Brom Bournemouth
M Dean 6 17 Crystal Palace Huddersfield
A Taylor 1 4 Watford Liverpool
M Atkinson 9 17 Everton Stoke
C Kavanagh 4 6 Leicester Brighton
N Swarbrick 6 16 Liverpool Crystal Palace
P Tierney 4 18 Man City Everton
R Madley 2 3 Swansea Man United
M Atkinson 0 4 Huddersfield Newcastle
A Marriner 6 13 Bournemouth Watford
L Probert 4 11 Burnley West Brom
J Moss 0 9 Southampton West Ham
C Pawson 2 8 Stoke Arsenal
A Marriner 7 12 Tottenham Chelsea
J Moss 6 13 Crystal Palace Bournemouth
A Taylor 5 14 Huddersfield Brighton
M Oliver 3 10 Liverpool Everton
S Attwell 4 8 Newcastle Leicester
M Atkinson 4 5 Man United Man City
G Scott 4 15 Tottenham Stoke
P Tierney 4 7 Burnley Watford
R East 1 7 Swansea West Brom
A Marriner 8 15 Southampton Arsenal
K Friend 2 5 West Ham Chelsea
M Atkinson 6 15 Leicester Burnley
A Marriner 3 12 Brighton Crystal Palace
C Pawson 2 4 Watford Huddersfield
C Kavanagh 1 6 Bournemouth Liverpool
M Dean 5 17 Chelsea Southampton
L Mason 3 12 Everton Swansea
J Moss 6 17 Man City Tottenham
P Tierney 4 10 West Brom Man United
A Taylor 3 15 Arsenal Newcastle
M Oliver 7 11 Stoke West Ham
K Friend 6 16 Tottenham Brighton
G Scott 4 13 Man United Bournemouth
R Madley 5 16 Chelsea Burnley
R East 2 6 Southampton Leicester
C Kavanagh 1 6 Crystal Palace Watford
S Attwell 3 9 Liverpool West Brom
L Mason 4 11 West Ham Arsenal
C Pawson 1 4 Swansea Man City
M Dean 7 16 Burnley Stoke
R Madley 2 9 Newcastle Everton
R East 1 9 Brighton Burnley
M Dean 1 6 Leicester Crystal Palace
L Probert 5 7 Everton Huddersfield
A Marriner 1 5 Stoke Liverpool
D Coote 2 9 West Brom Newcastle
A Taylor 7 14 Bournemouth Southampton
J Moss 3 11 Chelsea Swansea
K Friend 3 8 Arsenal Man United
N Swarbrick 7 19 Man City West Ham
M Oliver 5 13 Watford Tottenham
C Pawson 3 16 Man United Brighton
K Friend 3 12 Swansea Bournemouth
J Moss 5 11 Southampton Everton
C Kavanagh 3 13 West Ham Leicester
M Atkinson 2 13 Crystal Palace Stoke
R East 1 9 Newcastle Watford
M Jones 5 18 Tottenham West Brom
A Marriner 2 6 Burnley Arsenal
A Taylor 5 10 Liverpool Chelsea
M Dean 3 5 Huddersfield Man City
M Oliver 8 13 Southampton Swansea
L Mason 2 3 Huddersfield Chelsea
G Scott 7 14 Arsenal Leicester
P Tierney 3 6 Brighton Man City
N Swarbrick 3 14 Newcastle Tottenham
J Moss 6 16 Man United West Ham
P Tierney 5 16 Bournemouth Burnley
J Moss 1 7 West Brom Crystal Palace
M Oliver 4 9 Arsenal Huddersfield
K Friend 1 2 Brighton Liverpool
L Mason 3 7 Watford Man United
M Atkinson 2 6 Chelsea Newcastle
A Marriner 2 13 Man City Southampton
A Taylor 5 8 Stoke Swansea
C Pawson 9 16 Leicester Tottenham
G Scott 7 14 Everton West Ham
print(df[(df.HomeTeam == "Arsenal") | (df.AwayTeam == "Arsenal")])
AC AF AR AS AST AY AwayTeam B365A B365D B365H ... PSCH \
0 4 12 0 6 3 1 Leicester 6.50 4.50 1.53 ... 1.49
15 9 11 0 18 6 0 Arsenal 1.85 3.80 4.50 ... 4.37
27 3 9 0 8 0 4 Arsenal 3.50 3.70 2.15 ... 2.21
30 2 8 0 6 1 1 Bournemouth 9.00 5.50 1.36 ... 1.31
48 1 15 0 11 2 3 Arsenal 4.50 4.00 1.80 ... 1.77
59 4 17 0 7 3 4 West Brom 11.00 5.50 1.33 ... 1.34
67 5 8 0 9 1 2 Brighton 13.00 6.50 1.20 ... 1.26
76 5 10 0 9 6 0 Arsenal 1.65 4.33 5.25 ... 5.00
88 7 14 0 30 14 1 Arsenal 2.04 3.60 3.79 ... 4.70
90 2 9 0 4 2 0 Swansea 12.00 7.00 1.25 ... 1.20
108 5 15 0 6 3 6 Arsenal 7.50 5.50 1.39 ... 1.41
110 4 16 0 14 4 1 Tottenham 2.89 3.60 2.50 ... 2.49
127 5 14 0 17 2 0 Arsenal 1.53 4.50 6.50 ... 6.25
134 2 12 0 7 2 1 Huddersfield 17.00 7.50 1.19 ... 1.18
140 1 10 1 8 4 2 Man United 3.00 3.39 2.50 ... 2.32
159 5 10 0 11 6 2 Arsenal 1.95 3.75 4.00 ... 4.20
169 7 9 0 22 3 0 Arsenal 1.66 4.20 5.25 ... 5.45
170 5 9 0 10 2 1 Newcastle 14.00 6.50 1.25 ... 1.26
180 8 11 0 14 9 0 Liverpool 2.79 3.60 2.54 ... 2.68
199 4 7 0 16 9 1 Arsenal 1.80 4.00 4.50 ... 4.82
208 6 9 0 14 4 3 Arsenal 1.72 4.00 5.00 ... 5.70
218 8 11 0 19 6 2 Chelsea 2.60 3.39 2.60 ... 3.32
227 5 10 0 12 3 2 Arsenal 1.75 4.20 4.75 ... 3.81
230 10 8 0 9 5 0 Crystal Palace 7.00 4.75 1.50 ... 1.44
241 3 8 0 9 4 3 Arsenal 1.50 4.59 7.00 ... 7.10
250 6 8 0 11 2 0 Everton 12.00 5.75 1.30 ... 1.37
264 2 9 0 6 1 1 Arsenal 3.50 3.60 2.00 ... 1.93
279 1 11 0 9 5 1 Man City 1.72 4.00 4.50 ... 4.75
287 11 12 0 15 7 3 Arsenal 1.90 3.79 4.20 ... 4.25
297 9 9 0 11 4 1 Watford 7.50 5.00 1.44 ... 1.52
312 5 13 0 8 2 2 Stoke 10.00 5.50 1.28 ... 1.31
322 6 7 1 15 8 1 Southampton 6.00 4.50 1.57 ... 1.79
332 5 9 0 15 3 0 Arsenal 2.25 3.60 3.29 ... 2.90
340 6 9 0 11 4 2 West Ham 6.00 4.59 1.55 ... 1.53
351 0 7 0 8 3 1 Arsenal 8.00 4.75 1.44 ... 1.41
361 5 7 0 6 2 1 Burnley 6.50 4.20 1.57 ... 1.47
366 6 12 1 14 7 2 Arsenal 2.00 3.79 3.75 ... 3.89
372 4 7 0 9 4 0 Arsenal 1.60 4.33 6.00 ... 5.70
PSD PSH Referee VCA VCD VCH WHA WHD WHH
0 4.55 1.53 M Dean 6.50 4.50 1.53 6.00 4.20 1.53
15 3.85 4.39 A Marriner 1.83 3.80 4.60 1.80 3.50 4.50
27 3.72 2.16 C Pawson 3.30 3.70 2.20 3.40 3.25 2.20
30 5.59 1.39 A Taylor 9.00 5.50 1.36 8.00 5.00 1.36
48 4.02 1.81 M Oliver 4.50 4.00 1.80 4.50 3.50 1.80
59 5.45 1.36 R Madley 10.50 5.40 1.33 9.00 5.00 1.33
67 6.65 1.27 K Friend 12.00 6.50 1.25 13.00 6.00 1.22
76 4.37 5.49 N Swarbrick 1.62 4.40 5.50 1.62 4.20 5.50
88 3.71 3.84 C Pawson 2.00 3.60 4.00 2.05 3.30 4.00
90 7.35 1.24 L Mason 13.00 7.00 1.25 13.00 7.00 1.22
108 5.20 1.43 M Oliver 7.50 5.50 1.40 7.00 4.80 1.44
110 3.62 2.50 M Dean 2.90 3.60 2.50 2.80 3.50 2.50
127 4.47 5.89 L Mason 1.57 4.33 6.25 1.57 4.20 6.00
134 7.23 1.23 G Scott 19.00 7.00 1.20 15.00 7.00 1.20
140 3.42 2.44 A Marriner 3.10 3.40 2.45 3.00 3.20 2.50
159 3.79 3.85 R Madley 1.95 3.70 4.00 1.91 3.60 3.80
169 4.44 5.36 J Moss 1.65 4.30 5.40 1.65 4.00 5.50
170 6.80 1.27 S Attwell 15.00 6.50 1.25 13.00 6.00 1.25
180 3.71 2.51 M Atkinson 2.80 3.75 2.50 2.80 3.60 2.45
199 4.00 4.54 M Oliver 1.80 4.00 4.50 1.75 3.80 4.80
208 4.06 5.39 M Dean 1.70 4.00 5.25 1.73 3.75 4.50
218 3.51 2.80 A Taylor 2.63 3.50 2.75 2.70 3.30 2.70
227 4.22 4.63 K Friend 1.75 4.20 4.60 1.75 4.00 4.50
230 4.73 1.49 C Kavanagh 7.00 4.60 1.50 7.00 4.33 1.50
241 4.62 7.00 L Mason 1.50 4.40 7.50 1.50 4.33 7.00
250 5.85 1.32 N Swarbrick 11.00 5.75 1.30 11.00 5.00 1.33
264 3.85 2.04 A Taylor 3.60 3.90 2.05 3.40 3.75 2.00
279 4.06 4.58 A Marriner 1.80 4.00 4.60 1.73 3.80 4.50
287 3.70 4.04 S Attwell 2.00 3.70 4.00 1.91 3.75 4.00
297 4.81 1.48 M Atkinson 7.00 5.00 1.45 7.00 4.33 1.50
312 6.10 1.31 C Pawson 11.00 6.00 1.30 10.00 5.50 1.30
322 4.45 1.56 A Marriner 6.25 4.50 1.55 6.00 4.20 1.57
332 3.65 3.27 A Taylor 2.25 3.60 3.30 2.20 3.50 3.30
340 4.65 1.55 L Mason 6.50 4.60 1.53 5.50 4.50 1.57
351 4.83 1.45 K Friend 8.50 4.80 1.40 8.00 4.33 1.44
361 4.35 1.57 A Marriner 6.50 4.33 1.55 7.00 3.75 1.57
366 3.90 3.75 G Scott 2.00 3.90 3.70 2.00 3.75 3.60
372 4.48 5.88 M Oliver 1.57 4.40 6.00 1.60 4.20 5.50
[38 rows x 65 columns]
Arsenal_homesgames = df.loc[(df.HomeTeam == "Arsenal"), ['HomeTeam', 'FTHG', 'FTAG', 'AwayTeam', ]]
Arsenal_awaygames = df.loc[(df.AwayTeam == "Arsenal"), ['HomeTeam', 'FTHG', 'FTAG', 'AwayTeam',]]
print(Arsenal_homesgames.to_string(index=False))
print(Arsenal_awaygames.to_string(index=False))
Arsenal_away_losses = Arsenal_awaygames.loc[Arsenal_awaygames.FTAG < Arsenal_awaygames.FTHG]
print(Arsenal_away_losses.to_string (index=False))
HomeTeam FTHG FTAG AwayTeam
Stoke 1 0 Arsenal
Liverpool 4 0 Arsenal
Watford 2 1 Arsenal
Man City 3 1 Arsenal
Bournemouth 2 1 Arsenal
Swansea 3 1 Arsenal
Tottenham 1 0 Arsenal
Brighton 2 1 Arsenal
Newcastle 2 1 Arsenal
Man United 2 1 Arsenal
Leicester 3 1 Arsenal
import base64
text = "J A M"
encoded_bytes = base64.b64encode(text.encode('utf-8'))
encoded_text = encoded_bytes.decode('utf-8')
print(encoded_text)
SiBBIE0=