forum

Downloading the Leaderboard + Stats Project

posted
Total Posts
11
Topic Starter
galactiknight
Is there a way to download the leaderboard of the top 1000 or more players? I want to make sure the rankings don't change as I am getting data.
I need to do a Stats project and I'm trying to see if there is an association between performance points and number of times played


edit: Is there also a way to see the leaderboards of songs past #50?
jaaakb
Topic Starter
galactiknight
Ok, I'm not sure how to use this.

Am I supposed to make a program to use this?

Edit: god im a noob, need help.
xenal
Yes, you need a program to do so (don't manually do that anyway, would be too long)

More details that is kinda useless because you should actually go read that wiki

galactiknight wrote:

Is there also a way to see the leaderboards of songs past #50?

https://github.com/ppy/osu-api/wiki#apiget_scores with limit option set to 100 (max)

galactiknight wrote:

if there is an association between performance points and number of times played

https://github.com/ppy/osu-api/wiki#apiget_beatmaps to get maps (in there is the playcount) and https://github.com/ppy/osu-api/wiki#apiget_scores have the pp. Also add ranked date in your stats, 3d stats. There is a relation between ranked date and playcount, famous songs ranked in the early days were played a lot (mostly for the song).
Topic Starter
galactiknight
I have been trying to use https://osu.ppy.sh/p/api/ as the address in Postman, but it's not working for me.

I don't know what the url is to use the api as the one given doesn't seem to work, and I don't know what whether the key I got would work for other applications or how to use the key

edit: im doing it manually in excel for the world leaderboards, not the songs
I spending too much time trying to do this

further help would be helpful, im interested to know how to do this.

edit: thanks xenal (original post that was here was deleted)
7ambda
You'll love this: https://osu.ppy.sh/community/forums/topics/408541

works on new site btw
Topic Starter
galactiknight
oh, h(Minecraft server) yeah.

I'll try it out

edit:
here's the file in its current state if y' all want to see it
https://1drv.ms/x/s!Ai_-tIyVvFU8g3oqL4D_ZlLA4CJe

I manually plugged it into excel and got the stuff. Faster than expected, only 10 minutes.
it's only the pp and play count of the world leaderboards, not any of the songs like I wanted to do originally. I'm sort of in a time crunch, I think what I got will do.

Thanks for all who helped :)
Topic Starter
galactiknight
Ok here is the project that I turned in, for anyone is curious.

It was due today so I wasn't able to use the API, but using the global leaderboard worked for my purposes on excel.

This project took me 2 days when I realized that it was due today due to some jank schedule adjustments. Pulled an all nighter to do this essentially last minute.



Links to Data and Stuff
https://1drv.ms/x/s!Ai_-tIyVvFU8g34n2HXPTngNxcb2

https://1drv.ms/p/s!Ai_-tIyVvFU8g3_0myW59Y0yzEOV
7ambda

galactiknight wrote:

Ok here is the project that I turned in, for anyone is curious.

It was due today so I wasn't able to use the API, but using the global leaderboard worked for my purposes on excel.

This project took me 2 days when I realized that it was due today due to some jank schedule adjustments. Pulled an all nighter to do this essentially last minute.



Links to Data and Stuff
https://1drv.ms/x/s!Ai_-tIyVvFU8g34n2HXPTngNxcb2

https://1drv.ms/p/s!Ai_-tIyVvFU8g3_0myW59Y0yzEOV
!!!
Full Tablet
You defined the population as All osu! players, but your sampling only included random players from the top 1000 in the leaderboards. Either redefine what is the population you are studying, or find a way to sample random players from all osu! players.

Also, if you had data from all top 1000 players, why did you not use all those data points?
Topic Starter
galactiknight
I was trying to get a sample from a sample I guess. What confused me during class was how to get a sample of volunteers without getting voluntary response bias. So by doing this, I would get a random sample of a sample and hopefully reduce this.

Considering these players weren't willing, I could have just taken a random sample of 100 players or something along those lines. At that point, my "population" would have been the top 10,000 players.

I see your point, but it's a bit too late for me to fix that :P.
Thanks anyway! :)
Please sign in to reply.

New reply