Data Explorer (SEDE)

« first day (1359 days earlier) ← previous day next day → last day (752 days later) »

4:44 AM

@MartinSleziak But the query you refer to is quite short(?) -- What makes getting what I described notably more difficult? (Sorry if my question is stupid -- I don't know much about the programming language for SEDE queries.) — Stefan Kohl ♦ 8 hours ago

1 hour later…

Martin

5:53 AM

Q: SQL for computing h-score (h-index)

According to wikipedia: A scientist has index h if h of his/her Np papers have at least h citations each, and the other (Np − h) papers have no more than h citations each. Imagine we have SCIENTISTS, PAPERS, CITATIONS tables with 1-n relation between SCIENTISTS and PAPERS and 1-n relation ...

rene

6:49 AM

@Martin first time I heard about h-index. Even looking at the sample query I'm struggling to get my head around it. I think this should use a RANK maybe combined with the LAST windowed function and needs either two queries (one two get the h-index for each score, another to find the exsct cut-of) or a recursive CTE. Let me think about it for a few minutes

Easter Sunday

Martin

7:04 AM

@rene h-index is commonly used in scientometrics. E.g., a scientist has h-index equal to 10 if they have published at least 10 papers such that each of them has at least 10 citations.

I'd guess this is something which would be more straightforward to calculate in a procedural language such as C++.

In any case, I would suppose that on the part of the MO mod who asked about it, this is more about idle curiosity than about something seriously needed.

It might be interesting to know the h-index for various users - but basically it's just one additional vanity metric.

rene

Yeah, that is probably why that SEDE query uses a while loop. I still think it are two sets that needs be joined and ordered on a count to find the h-index.

2 hours later…

rene

9:24 AM

@Martin I think this one does it: data.stackexchange.com/mathoverflow/query/1580631 but I've only point checked two accounts. Used a rank over score

Martin

9:41 AM

I have added usernames to the first of those three queries: Top users by h-index.

I will try to look into that - to understand at least roughly what is done here.

I suppose that to get similar query for questions/answers, one only has to add restriction on PostTypeId.

rene

Yeah, that should work.

7 hours later…

Martin

4:26 PM

A minor modification of the above query which can work for questions, answers or all posts.

@StefanKohl Creating such query would be beyond my knowledge of SQL - but you can have a look what other users suggested. — Martin Sleziak 12 secs ago

1 hour later…

rene

5:28 PM

Q: Modified h-index for questions and answers?

In academia, the h-index is a measure of how much of an impact a researcher has. It's defined as follows: You have an h-index of k if you have published at least k papers that each have k or more citations. The reason I bring this up is that it might be interesting to adapt this to work fo...