Stats question

[myofb]

Hi

I'm doing some research and need to get hold of some innings by innings stats for well over 200 batsmen in tests. The resulting dataset will be pretty big. Is there a dB out there I can query for free? Cricinfo does have what I need but I can't see a way to get all the data in one go and I'd prefer not to have to run 200 queries separately and collate all the data from web pages.

Thx

 

[Window]

This is something I’ve been meaning to lookup and work with myself. Finally bothered searching for it and seems like Cricsheet would be a good source?

Cricsheet

 

[myofb]

Thanks - but the trouble with cricsheet is, so far as I can tell, you can't get an innings by innings list from it. Have you found one? I know you can get ball by ball (from where it could be aggregated to inns by inns) since about 2005 but I need to go back way before that.

The cricinfo query tool is pretty advanced and looks like it will give what's required - but the results are delivered in web pages. Do you know if there's a way to download results (e.g. as csv) from cricinfo?

 

[RossTaylorsBox]

Easiest way would be to run a Python script on the Cricinfo results to scrape the data and turn it into a csv.

A quick Google search brings this up but it's from 5 years ago:

Scraping data from ESPNCricInfo StatsGuru in a .csv using Python

Please could you advise on how to scrape from the following URL: https://stats.espncricinfo.com/ci/engine/stats/index.html?class=1;filter=advanced;orderby=innings;size=200;spanmax1=07+Aug+2020;span...

stackoverflow.com

 

[Coronis]

Easiest way would be to run a Python script on the Cricinfo results to scrape the data and turn it into a csv.

A quick Google search brings this up but it's from 5 years ago:

Scraping data from ESPNCricInfo StatsGuru in a .csv using Python

Please could you advise on how to scrape from the following URL: https://stats.espncricinfo.com/ci/engine/stats/index.html?class=1;filter=advanced;orderby=innings;size=200;spanmax1=07+Aug+2020;span...

stackoverflow.com

I remember @srbhkshk grabbing a bunch of data from cricinfo (I think) with some sort of script when DoG made that 5 year/40 innings peak thread. Unsure if something like that could help.

 

[RossTaylorsBox]

I mean it shouldn't really be difficult, I could probably whip something up if you gave me enough time, but more importantly, enough money.

 

[Coronis]

I mean it shouldn't really be difficult, I could probably whip something up if you gave me enough time, but more importantly, enough money.

Yeah fair. I’m no coder but the amount of people wanting free stuff based on specialised skills on the internet is rising astronomically every year it seems.

 

[trundler]

Just chatgpt it

 

[srbhkshk]

Hi

I'm doing some research and need to get hold of some innings by innings stats for well over 200 batsmen in tests. The resulting dataset will be pretty big. Is there a dB out there I can query for free? Cricinfo does have what I need but I can't see a way to get all the data in one go and I'd prefer not to have to run 200 queries separately and collate all the data from web pages.

Thx

You don't need to run 200 queries, try looking at a couple of pages and check how the url changes when you change the batsman. Then code that change logic and run a loop to scrap data. I typically use R for it but it should be easy enough in Python and other languages as well.