WhoScored.com data

[Arseshavin]

Hi,

Does anyone know how I could extract the squad data in the link below from these tables to be able to present them in a different way. I just want to be able to compare defenders from different teams more easily.

http://www.whoscored.com/Teams/13" onclick="window.open(this.href);return false;

[Surprised]

You can't extract the data ina different format as you don't control how the data is displayed on the webpage.
What you can do is download the data in 1 sheet and then use another sheet to manipulate the data by extracting the items you want from the first sheet.

Probably easier from this page
http://www.whoscored.com/Regions/252/To ... -2012-2013" onclick="window.open(this.href);return false;

as it gives all teams and means only 1 download.

How would you want the data presented?

[bloggie]

Probably a spreadsheet extraction method.I only use notepad and excel as a viewer so someone may think of some code.Here's some in the non excel version anyhow.

Code: Select all

Arsenal
Pos	Age	cm	kg	Apps	Goal	A Yel Red SpG	PS%	AW	MoM	Rt	
Laurent Koscielny
D(C)	27	186	75	2(1)	1	-	-	-	0.3	82.6	2	1	6.75	
Per Mertesacker	
D(C)	28	198	90	5	-	-	1	-	0.6	91.5	2	-	7.1	
Thomas Vermaelen	
D(CL)	26	180	75	5	-	-	1	-	1.4	87.1	3.2	-	7.4
Johan Djourou	
D(CR)	25	192	90	-	-	-	-	-	-	-	-	-	-
Kieran Gibbs	
D(L)	23	178	70	6	-	-	-	-	0.5	88.3	1.2	-	7.5
André Santos	
D(L)	29	180	73	0(1)	-	-	-	-	-	100	-	-	6.1
Carl Jenkinson	
D(R)	20	185	77	6	-	-	-	-	0.3	83	1.5	-	7.1

Aston Villa
Joe Bennett	
D	22	183	74	1(1)	-	-	-	-	1	83.3	0.5	-	6.39
Derrick Williams	
D	19	-	-	-	-	-	-	-	-	-	-	-	-
Ron Vlaar	
D(C)	27	189	80	6	-	-	1	-	0.7	76.3	2.8	1	7
Nathan Baker	
D(CL)	21	188	75	2	-	-	-	-	-	69.5	7.5	1	7.67
Ciaran Clark	
D(CL),DM(C)	23	188	76	6	1	-	2	1	1.2	76.4	2.7	-	6.71
Eric Lichaj	
D(L)	23	175	70	3(1)	-	1	3	-	0.3	65.5	0.8	-	6.65
Matthew Lowton	
D(R)	23	180	78	6	1	-	1	-	0.3	77.8	0.8	-	6.88
Chelsea
John Terry	
D(C)	31	187	90	4(1)	-	-	-	-	0.2	90.5	2.6	-	6.98
Gary Cahill	
D(C)	26	188	71	3(1)	1	-	-	-	0.5	91.6	2.5	-	7.09
David Luiz	
D(C)	25	188	84	5	-	-	3	-	1.4	79.2	1.4	-	7.11
Branislav Ivanovic	
D(CR)	28	188	84	6	2	-	-	-	0.8	81.9	2.7	-	7.38
Ashley Cole	
D(L)	31	176	66	6	1	1	-	-	0.8	91.2	0.5	1	7.47
Ryan Bertrand	
D(L)	23	179	85	3(1)	-	-	1	-	0.5	85.7	1	-	6.69
Paulo Ferreira	
D(R)	33	181	76	-	-	-	-	-	-	-	-	-	-
César Azpilicueta	
D(R)	23	178	70	-	-	-	-	-	-	-	-	-	-
Everton
Shane Duffy	
D	20	193	76	-	-	-	-	-	-	-	-	-	-
Bryan Oviedo	
D	22	172	69	0(2)	-	-	-	-	-	100	-	-	6.05
Phil Jagielka	
D(C)	30	183	83	6	-	1	-	-	0.3	82.1	2.3	-	7.4
Sylvain Distin	
D(C)	34	193	87	4(1)	-	-	1	-	0.4	82.1	4.4	-	7.08
Johnny Heitinga	
D(C),DM(C)	28	182	69	2(2)	-	-	-	-	0.5	92.9	0.5	-	6.65
Leighton Baines	
D(L)	27	170	74	6	1	2	-	-	0.8	84.2	0.5	-	7.82
Tony Hibbert	
D(R)	31	175	71	2(1)	-	-	1	-	-	83.1	0.7	-	6.94
Philip Neville	
D(R),DM(C)	35	180	69	6	-	-	2	-	0.2	88.8	0.8	-	6.56
Fulham
Alex Smith	
D	20	175	54	0(1)	-	-	-	-	1	100	-	-	6.1
Rafik Halliche	
D	26	187	77	-	-	-	-	-	-	-	-	-	-
Brede Hangeland	
D(C)	31	195	85	6	-	-	1	-	0.2	89.3	2.7	-	6.77
Chris Baird	
D(CLR),DM(C)	30	185	76	3(1)	-	-	1	-	0.3	86.3	0.8	-	6.98
Aaron Hughes	
D(CR)	32	183	71	6	-	-	1	-	0.3	89.5	2	-	6.79
Sascha Riether	
D(CR),DM(C),M(R)	29	174	70	6	-	-	-	-	0.2	88.3	0.7	-	6.76
John Arne Riise	
D(L)	32	185	77	5	-	1	-	-	0.6	82.4	1.8	-	7.03
Matthew Briggs	
D(L)	21	184	76	1(1)	-	-	-	-	0.5	75	0.5	-	6.63
Kieran Richardson	
D(L),DM(C),M(L)	27	173	71	1	-	-	-	-	1	81	-	-	5.97
Stephen Kelly	
D(LR)	29	184	82	-	-	-	-	-	-	-	-	-	-
Liverpool
Andre Wisdom	
D	19	186	78	1	-	-	-	-	1	95.8	2	-	7.27
Sebastián Coates	
D(C)	21	196	85	1	-	-	-	-	-	82.8	1	-	6.58
Martin Skrtel	
D(C)	27	191	81	6	1	-	2	-	0.5	91.7	2.2	-	6.39
Daniel Agger	
D(CL)	27	188	79	5	-	-	-	1	0.8	90.8	2.2	-	6.41
Jamie Carragher	
D(CR)	34	185	76	0(3)	-	-	-	-	-	95.5	-	-	6.03
José Enrique	
D(L)	26	184	76	1(1)	-	-	-	-	-	83.6	-	-	6.31
Glen Johnson	
D(LR)	28	178	70	6	-	-	1	-	1.2	86.2	1.7	-	6.72
Martin Kelly	
D(R)	22	191	77	4	-	-	-	-	0.5	85.7	2	-	6.46

[ctibbits]

Thanks, I was looking for a site like this.

[Arseshavin]

Thanks for the replies everyone.

Ideally what I was looking for was a way to extract the data into Excel or another package and each time I refresh it gives me the latest available data.

Is this how you do it bloggie?

[Surprised]

Thanks for the replies everyone.

Ideally what I was looking for was a way to extract the data into Excel or another package and each time I refresh it gives me the latest available data.

Is this how you do it bloggie?

It can normally be done by web queries but it seems to be blocked on this site as they don't like people downloading data.

[WilBert]

Copies very nicely from firefox

http://vvcap.net/db/pX4rzR3M2AdT3lXCr8Z-.htp" onclick="window.open(this.href);return false;

Not used it but this looks promising
https://addons.mozilla.org/en-US/firefo ... bletools2/" onclick="window.open(this.href);return false;

[Surprised]

Cut and paste is fine but it will be a lot of work to do that weekly!

[Arseshavin]

For sure.

One copy and paste would be fine, but twenty each week is a bit excessive.

Any further ideas? The firefox extension looks great if it could copy the whole lot.