Spinorama.org into spreadsheet - howto?

[pavuol]

I'm always shy to call fo help but can someone tell how to get data from spinorama.org site into spreadsheet (.xls / .ods)? Simple copy past to LibreOffice doesn't work or at least I don't know what parameters (dividers) to insert with custom paste option. Or maybe use some tool to get data from its github repository?
(intended use is solely personal, condensed print layout, custom sorting, personal notes etc..)

 

[Curvature]

The website was created by @pierre

 

[pierre]

There is a lot of data there. Which ones do you want?

Some tools generate csv data:

./generate_stats.py --print=eq_txt

generates

2023-12-07 05:40:45,163 - generate_stats.py:main:166 - WARNING - Data ./docs/assets/metadata-155e2.json loaded (886 speakers)!
                                           | NBD  NBD  LFX   SM |  SCR | NBD  NBD  LFX   SM | SCR |  SCR|Pre AMP
Speaker                                    |  ON  PIR   Hz  PIR |  ASR |  ON  PIR   Hz  PIR |  EQ | DIFF|     dB
-------------------------------------------+--------------------+------+--------------------+-----+-----+-------
JBL Control HST V2                         | 0.09 0.12  22 0.49 | +7.4 | 0.10 0.07  22 0.96 | 8.6 | +1.3 |  +0.0
JBL Control 24CT                           | 0.13 0.15  29 0.64 | +7.1 | 0.10 0.10  22 0.97 | 8.6 | +1.5 |  +0.0
Infinity IL60                              | 0.23 0.20  20 0.93 | +6.8 | 0.20 0.16  20 0.94 | 8.2 | +1.4 |  +0.0
Perlisten s7t                              | 0.24 0.17  45 0.94 | +6.6 | 0.19 0.13  22 0.96 | 8.2 | +1.6 |  +0.0
KEF Blade 1 Meta (vendor-v1-20220217)      | 0.23 0.21  24 0.92 | +7.6 | 0.19 0.16  21 0.95 | 8.2 | +0.5 |  +0.0
KEF LS60 Wireless                          | 0.25 0.22  20 0.97 | +8.0 | 0.24 0.19  20 0.97 | 8.2 | +0.1 |  +0.0
Infinity Prelude MTS                       | 0.29 0.26  20 0.85 | +7.5 | 0.25 0.15  20 0.93 | 8.1 | +0.6 |  +0.0
Kii Audio Three                            | 0.27 0.25  20 0.85 | +7.6 | 0.25 0.18  20 0.97 | 8.1 | +0.5 |  +0.0
Revel Ultima Salon                         | 0.32 0.23  22 0.74 | +7.1 | 0.25 0.13  21 0.94 | 8.1 | +1.0 |  +0.0

etc

I have a attached a zipped csv of the full table that you can easily import into Excel or Google Sheet.

Also the metadata used by the site are all in 1 large file on GitHub (corrections are welcome btw).
Jump to the metadata file. EQ and measurements for data are in the same directory.

datas/eq/name of speaker/all the eqs
datas/measurements/name of speaker/origin of measurement/version of measurement

Hope it helps!

 

[pavuol]

There is a lot of data there. Which ones do you want?

To feel spoiled I'd like to have all the columns from "Ranking view" of your page in the spreadsheet but I'm already very happy with the csv you provided.

I have to study how to use that "generate tool", hope I figure out. If you don't mind, feel free to write some quick tutorial, maybe beneficial to all ASR readers, as not all are "IT guys"..

Thank you for your kind reply, also big thumbs up for the project. There's a local price comparison site which allows to write reviews for all visitors (not just verified owners like the usual case for eshops) so I plan to write some short "objective stats reviews" for some popular models and mention your site there to raise some public awareness
Keep up the good work and I wish you a nice Advent.

 

[pierre]

To feel spoiled I'd like to have all the columns from "Ranking view" of your page in the spreadsheet but I'm already very happy with the csv you provided.
View attachment 332186

I have to study how to use that "generate tool", hope I figure out. If you don't mind, feel free to write some quick tutorial, maybe beneficial to all ASR readers, as not all are "IT guys"..

Thank you for your kind reply, also big thumbs up for the project. There's a local price comparison site which allows to write reviews for all visitors (not just verified owners like the usual case for eshops) so I plan to write some short "objective stats reviews" for some popular models and mention your site there to raise some public awareness
Keep up the good work and I wish you a nice Advent.

I made some changes in python and generated more columns. To make it easy, just jump to https://docs.google.com/spreadsheet...jgnACyouN6Q_HkJHh56iaJHm4/edit#gid=1746706388
You should have access.

I added a quick example if you are not familiar with spreadsheets

If you find some interesting data, please let us know.

 

[pavuol]

I made some changes in python and generated more columns. To make it easy, just jump to https://docs.google.com/spreadsheet...jgnACyouN6Q_HkJHh56iaJHm4/edit#gid=1746706388

Thank you very much. Columns "w/sub" & "w/both" are still missing though, or?

If you find some interesting data, please let us know.

I'm still far from erudite audio expert, so I can add just some personal thoughs "for fun".

I'm curious for example, what are the top "transformers" (highest difference "w/both" score minus "basic tone score") ...columns note above.
From a glimpse at your web I can see e.g. Presonus Eris E3.5, that goes from 1.4 to 8.2 (6.8 difference). They would be catapulted even over the basic score of the expensive tech-supercar Kii Three, this is insane for "basic PC speakers" for below 100 Euros...

Lately I have bought Pioneers SP-BS22-LR (used/"like new" from Germany) which I have chosen solely on the price/basic score ratio. They were most likely sold only in North America (maybe Japan and Australia as well) which made me think that we don't have quite an alternative in Europe. I mean "cheap/budget" passive speakers ~80-150 Euros/pair with basic score ~5 (with actives things are way better). [cheapest close in rank are Polk ES20 Elite 290Eur score 4.7 / Elac B6.2 230Eur score 5,0... idealo.de prices]
Are there some gems still waiting to be discovered through measurements, like Denon SC-M41, Auna Linie 501 BS or pricier Edifier P17? I doubt it..

Spoiler: we have seen flying cars already, but...

..take Avantone Pro MixCubes & just Mix one more Cube with them and you can turn a submarine into a plane!

PS: another excellent "product chartshow" site like yours is ssd-tester.com, run by some austrian guy, we simply need more of these