Talk:DTU Compute

From Brede Wiki
Jump to: navigation, search

Contents

[edit] Altmetrics

[edit] Number of works (recorded in Wikidata)

SELECT ?person ?personLabel (COUNT(?WORK) AS ?number_of_works) WHERE {
  ?person wdt:P1416 ?SECTION .
  ?SECTION wdt:P361 wd:Q23048689 .
  ?WORK wdt:P50 ?person .
  service wikibase:label { bd:serviceParam wikibase:LANGUAGE "da" . } 
} 
GROUP BY ?person ?personLabel
ORDER BY DESC(?number_of_works)

Try it!

[edit] Number of citations (recorded in Wikidata)

SELECT ?person ?personLabel (COUNT(?citing_work) AS ?number_of_citations) WHERE {
  ?person wdt:P1416 ?SECTION .
  ?SECTION wdt:P361 wd:Q23048689 .
  ?WORK wdt:P50 ?person .
  ?citing_work wdt:P2860 ?WORK .
  service wikibase:label { bd:serviceParam wikibase:LANGUAGE "da" . } 
} 
GROUP BY ?person ?personLabel
ORDER BY DESC(?number_of_citations)

Try it!

[edit] Google Scholar citations

from everything import *
 
query = """
select ?person ?label ?googlescholar where {
  ?person wdt:P1416 ?section .
  ?section wdt:P361 wd:Q23048689 .
  optional { ?person wdt:P1960 ?googlescholar . }
  optional { ?person rdfs:label ?label . filter (lang(?label) = 'da') }
}
"""
 
service = sparql.Service('https://query.wikidata.org/sparql', method='GET')
response = service.query(query)
df = DataFrame(response.fetchall(), columns=response.variables)
 
url_prefix = "https://scholar.google.com/citations?user="
headers = {'User-Agent': 'fnielsenbot'}
labels = ['citations', 'citations5', 'h_index', 'h_index5', 'i10_index', 'i10_index5']
for label in labels:
    df[label] = np.nan
 
 
for idx, person in df.iterrows():
    if person.googlescholar is not None:
        try:
            print(person.label.value)
            url = url_prefix + person.googlescholar.value
            response = requests.get(url, headers=headers)
            element = BeautifulSoup(response.text, "lxml").find(attrs={'id': 'gsc_rsb_st'})
            extracted = element.find_all(text=True)
            citations_for_person = Series([int(extracted[n]) for n in [4, 5, 7, 8, 10, 11]], index=labels)
            df.ix[idx, labels] = citations_for_person
        except:
            # Could be deleted Google Scholar account
            print("Error for idx={} url={}".format(idx, url))
        sleep(5)
 
 
print(df.fillna('').to_html())   # Further editing are need to make it sortable and look "nice"

[edit] Table 2017-02-16

person label googlescholar citations citations5 h_index h_index5 i10_index i10_index5
0 http://www.wikidata.org/entity/Q1045720 Carsten Thomassen zYIE3FMAAAAJ 9316 3058 51 29 153 81
1 http://www.wikidata.org/entity/Q2574238 Lars Ramkilde Knudsen YayQtGUAAAAJ 9664 4039 40 24 97 49
2 http://www.wikidata.org/entity/Q12340430 Vagn Lundsgaard Hansen zyD3pIQAAAAJ 975 254 16 8 24 5
3 http://www.wikidata.org/entity/Q20980928 Finn Årup Nielsen 9cagBQYAAAAJ 3526 1628 28 20 47 29
4 http://www.wikidata.org/entity/Q20984804 Lars Kai Hansen gQVuJh8AAAAJ 14306 5405 53 34 170 90
5 http://www.wikidata.org/entity/Q22329229 Christian Damsgaard Jensen
6 http://www.wikidata.org/entity/Q24265825 Kristoffer Hougaard Madsen 2SFcdW0AAAAJ 2611 2091 18 17 28 23
7 http://www.wikidata.org/entity/Q24265879 Matthew G. Liptrot n0NYEY0AAAAJ 842 499 12 10 12 10
8 http://www.wikidata.org/entity/Q24283608 Jan Larsen 6Y_3isIAAAAJ 3947 1512 33 18 83 42
9 http://www.wikidata.org/entity/Q24290415 Ole Winther 7VAwhzUAAAAJ 4070 2293 30 22 70 46
10 http://www.wikidata.org/entity/Q24341856 Per Christian Hansen 1OLw6UgAAAAJ 18740 7760 45 30 94 60
11 http://www.wikidata.org/entity/Q24389216 Jakob E. Bardram pRriaUQAAAAJ 6004 2590 38 29 82 63
12 http://www.wikidata.org/entity/Q24390693 Sune Lehmann wvkUbiUAAAAJ 2696 2116 16 15 21 19
13 http://www.wikidata.org/entity/Q24449285 Allan P. Engsig-Karup UbWFbIkAAAAJ 436 338 10 10 11 10
14 http://www.wikidata.org/entity/Q24449294 Helle Rootzén 1H5MPiIAAAAJ 492 138 12 5 12 4
15 http://www.wikidata.org/entity/Q24573487 Knut Conradsen
16 http://www.wikidata.org/entity/Q24573507 Rasmus R. Paulsen UkOaTWAAAAAJ 471 308 12 9 15 8
17 http://www.wikidata.org/entity/Q24573646 Michael Kai Petersen qR0gmxIAAAAJ 225 180 6 5 5 4
18 http://www.wikidata.org/entity/Q24718233 Jan Madsen 6K3uX7oAAAAJ 2197 854 25 16 53 25
19 http://www.wikidata.org/entity/Q24730879 Henrik Madsen jwRQrkAAAAAJ 12376 7279 55 41 239 147
20 http://www.wikidata.org/entity/Q25927688 Flemming Nielson QUVToEgAAAAJ 8218 2057 42 19 123 40
21 http://www.wikidata.org/entity/Q25927874 Hanne Riis Nielson 5U0XVHUAAAAJ 7210 1869 35 18 106 35
22 http://www.wikidata.org/entity/Q25931571 Jakob Eg Larsen EztREm4AAAAJ 487 442 12 11 13 12
23 http://www.wikidata.org/entity/Q25931588 Bjarne Kjær Ersbøll
24 http://www.wikidata.org/entity/Q25931597 Barbara Weber iEBRDLkAAAAJ 5167 3958 37 34 79 72
25 http://www.wikidata.org/entity/Q25932562 Per Bruun Brockhoff Gw8WMDgAAAAJ 3845 2526 32 22 59 40
26 http://www.wikidata.org/entity/Q25932641 Anders Bjorholm Dahl WsgfNRMAAAAJ 421 402 11 10 13 11
27 http://www.wikidata.org/entity/Q25935231 Morten Brøns MJ-eQQUAAAAJ 1243 509 18 12 34 20
28 http://www.wikidata.org/entity/Q25935243 Mads Peter Sørensen Va9EeXEAAAAJ 1817 619 25 13 56 20
29 http://www.wikidata.org/entity/Q25935257 Jørgen Fischer Nilsson
30 http://www.wikidata.org/entity/Q25935274 Paul Fischer 18o5q3AAAAAJ 2873 1945 12 6 12 5
31 http://www.wikidata.org/entity/Q25935293 Michael Pedersen GmEaLu8AAAAJ 489 181 12 7 14 5
32 http://www.wikidata.org/entity/Q25935308 Jens Sparsø UDM68ncAAAAJ 3528 1254 23 17 40 24
33 http://www.wikidata.org/entity/Q25935328 Anders Stockmarr jWnA798AAAAJ 1278 751 16 14 26 21
34 http://www.wikidata.org/entity/Q25939218 J. Andreas Bærentzen if2X4wkAAAAJ 1360 717 16 13 30 17
35 http://www.wikidata.org/entity/Q25939334 Henrik Aanæs WTjCRE8AAAAJ 1314 814 16 15 28 17
36 http://www.wikidata.org/entity/Q25939338 Line H. Clemmensen _S285OAAAAAJ 608 535 10 9 10 9
37 http://www.wikidata.org/entity/Q25939354 Ekkart Kindler W40V498AAAAJ 3873 1189 31 17 63 29
38 http://www.wikidata.org/entity/Q26720269 Morten Mørup RQonsgMAAAAJ 2046 1378 23 20 41 33
39 http://www.wikidata.org/entity/Q26837108 Tobias Andersen XvMDbHkAAAAJ 591 334 10 9 11 9
40 http://www.wikidata.org/entity/Q27435889 Nathan W. Churchill
41 http://www.wikidata.org/entity/Q27764899 Ivana Konvalinka lOM8LloAAAAJ 595 564 8 8 8 8
42 http://www.wikidata.org/entity/Q27899406 Koen Van Leemput PQLyawoAAAAJ 4564 2609 25 22 42 34
43 http://www.wikidata.org/entity/Q27902595 Thomas Bolander FxFF9kMAAAAJ 445 261 13 9 13 8
44 http://www.wikidata.org/entity/Q28778166 Trine Julie Abrahamsen 8ZxOWScAAAAJ 81 67 5 5 4 3
45 http://www.wikidata.org/entity/Q28789957 Tue Herlau fhBfXAcAAAAJ 62 61 5 5 1 1
46 http://www.wikidata.org/entity/Q28025541 Mikkel Nørgaard Schmidt IjF4ExkAAAAJ 1299 974 19 16 26 22
47 http://www.wikidata.org/entity/Q28045195 Andrea Cuttone 7H3MVo4AAAAJ 141 141 6 6 3 3
48 http://www.wikidata.org/entity/Q28045211 Arkadiusz Stopczynski zGuKpwQAAAAJ 430 426 11 11 12 12
49 http://www.wikidata.org/entity/Q28045348 Per Bækgaard cxw9UPUAAAAJ 4 4 1 1 0 0
50 http://www.wikidata.org/entity/Q28361465 Carsten Stahlhut _ug9GaoAAAAJ 319 313 8 7 7 7
51 http://www.wikidata.org/entity/Q28362071 Dan Svenstrup
52 http://www.wikidata.org/entity/Q28419094 Piotr Sapiezynski
53 http://www.wikidata.org/entity/Q28419095 Vedran Sekara
54 http://www.wikidata.org/entity/Q28419093 David Kofoed Wind
55 http://www.wikidata.org/entity/Q28423414 Kasper Winther Andersen p_3ErLgAAAAJ 277 213 9 7 9 6
56 http://www.wikidata.org/entity/Q28477702 Søren Hauberg M1fMGOMAAAAJ 1491 987 12 12 16 13
57 http://www.wikidata.org/entity/Q28477916 Sofie Therese Hansen h3t8HrAAAAAJ 21 21 2 2 0 0
58 http://www.wikidata.org/entity/Q28478844 Rasmus Troelsgård cFc6owMAAAAJ 3 3 1 1 0 0
59 http://www.wikidata.org/entity/Q28486007 Lasse Lohilahti Mølgaard fMnLCPQAAAAJ 52 26 4 3 3 0
60 http://www.wikidata.org/entity/Q28526623 Allan Aasbjerg Nielsen gDrl3sIAAAAJ 2805 1422 21 15 43 21
61 http://www.wikidata.org/entity/Q28598505 Bjørn Sand Jensen
62 http://www.wikidata.org/entity/Q28681282 Rasmus Bonnevie
63 http://www.wikidata.org/entity/Q28778132 Laura Frølich

[edit] Table 2016-07-20

person label googlescholar citations citations5 h_index h_index5 i10_index i10_index5
0 http://www.wikidata.org/entity/Q1045720 Carsten Thomassen
1 http://www.wikidata.org/entity/Q2574238 Lars Ramkilde Knudsen YayQtGUAAAAJ 9001 4205 39 24 95 53
2 http://www.wikidata.org/entity/Q12340430 Vagn Lundsgaard Hansen zyD3pIQAAAAJ 711 187 15 6 22 2
3 http://www.wikidata.org/entity/Q20980928 Finn Årup Nielsen 9cagBQYAAAAJ 3269 1658 28 22 47 31
4 http://www.wikidata.org/entity/Q20984804 Lars Kai Hansen gQVuJh8AAAAJ 13362 5697 51 34 168 95
5 http://www.wikidata.org/entity/Q22329229 Christian Damsgaard Jensen
6 http://www.wikidata.org/entity/Q24265879 Matthew G. Liptrot n0NYEY0AAAAJ 727 469 10 9 10 9
7 http://www.wikidata.org/entity/Q24283608 Jan Larsen 6Y_3isIAAAAJ 3640 1583 31 19 81 43
8 http://www.wikidata.org/entity/Q24290415 Ole Winther 7VAwhzUAAAAJ 3602 2199 28 20 60 41
9 http://www.wikidata.org/entity/Q25927688 Flemming Nielson QUVToEgAAAAJ 7931 2199 41 18 121 41
10 http://www.wikidata.org/entity/Q25927874 Hanne Riis Nielson 5U0XVHUAAAAJ 6950 2016 34 18 103 36
11 http://www.wikidata.org/entity/Q25931571 Jakob Eg Larsen EztREm4AAAAJ 401 366 10 10 11 10
12 http://www.wikidata.org/entity/Q25931588 Bjarne Kjær Ersbøll
13 http://www.wikidata.org/entity/Q25931597 Barbara Weber iEBRDLkAAAAJ 4592 3738 35 33 72 68
14 http://www.wikidata.org/entity/Q25932562 Per Bruun Brockhoff Gw8WMDgAAAAJ 3268 2187 30 22 56 45
15 http://www.wikidata.org/entity/Q25932641 Anders Bjorholm Dahl WsgfNRMAAAAJ 340 333 11 11 13 13
16 http://www.wikidata.org/entity/Q24341856 Per Christian Hansen 1OLw6UgAAAAJ 17311 7850 43 30 92 59
17 http://www.wikidata.org/entity/Q24389216 Jakob E. Bardram
18 http://www.wikidata.org/entity/Q24390693 Sune Lehmann Jørgensen wvkUbiUAAAAJ 2353 1975 16 14 18 17
19 http://www.wikidata.org/entity/Q24449285 Allan P. Engsig-Karup UbWFbIkAAAAJ 361 292 8 8 8 7
20 http://www.wikidata.org/entity/Q24449294 Helle Rootzén 1H5MPiIAAAAJ 470 147 12 5 12 5
21 http://www.wikidata.org/entity/Q24573487 Knut Conradsen
22 http://www.wikidata.org/entity/Q24573507 Rasmus R. Paulsen UkOaTWAAAAAJ 427 304 11 10 15 12
23 http://www.wikidata.org/entity/Q24573646 Michael Kai Petersen qR0gmxIAAAAJ 205 168 5 5 5 4
24 http://www.wikidata.org/entity/Q24718233 Jan Madsen 6K3uX7oAAAAJ 2018 864 24 16 48 26
25 http://www.wikidata.org/entity/Q24730879 Henrik Madsen jwRQrkAAAAAJ 11005 6968 50 38 226 149
26 http://www.wikidata.org/entity/Q25935231 Morten Brøns MJ-eQQUAAAAJ 1159 536 18 12 32 20
27 http://www.wikidata.org/entity/Q25935243 Mads Peter Sørensen Va9EeXEAAAAJ 1653 655 24 14 52 22
28 http://www.wikidata.org/entity/Q25935257 Jørgen Fischer Nilsson
29 http://www.wikidata.org/entity/Q25935274 Paul Fischer 18o5q3AAAAAJ 2561 1886 11 6 12 5
30 http://www.wikidata.org/entity/Q25935293 Michael Pedersen GmEaLu8AAAAJ 474 221 11 8 14 6
31 http://www.wikidata.org/entity/Q25935308 Jens Sparsø UDM68ncAAAAJ 3282 1368 21 16 37 24
32 http://www.wikidata.org/entity/Q25935328 Anders Stockmarr jWnA798AAAAJ 1184 761 16 13 25 20

[edit] 2016-07-21

person label googlescholar citations citations5 h_index h_index5 i10_index i10_index5
0 http://www.wikidata.org/entity/Q25939338 Line H. Clemmensen _S285OAAAAAJ 513 473 10 9 10 9
1 http://www.wikidata.org/entity/Q25939354 Ekkart Kindler W40V498AAAAJ 3648 1297 31 17 58 30
2 http://www.wikidata.org/entity/Q24341856 Per Christian Hansen 1OLw6UgAAAAJ 17312 7851 43 30 92 59
3 http://www.wikidata.org/entity/Q24389216 Jakob E. Bardram
4 http://www.wikidata.org/entity/Q24390693 Sune Lehmann Jørgensen wvkUbiUAAAAJ 2353 1975 16 14 18 17
5 http://www.wikidata.org/entity/Q24449285 Allan P. Engsig-Karup UbWFbIkAAAAJ 361 292 8 8 8 7
6 http://www.wikidata.org/entity/Q24449294 Helle Rootzén 1H5MPiIAAAAJ 470 147 12 5 12 5
7 http://www.wikidata.org/entity/Q24573487 Knut Conradsen
8 http://www.wikidata.org/entity/Q24573507 Rasmus R. Paulsen UkOaTWAAAAAJ 427 304 11 10 15 12
9 http://www.wikidata.org/entity/Q24573646 Michael Kai Petersen qR0gmxIAAAAJ 205 168 5 5 5 4
10 http://www.wikidata.org/entity/Q24718233 Jan Madsen 6K3uX7oAAAAJ 2018 864 24 16 48 26
11 http://www.wikidata.org/entity/Q24730879 Henrik Madsen jwRQrkAAAAAJ 11012 6975 50 38 226 149
12 http://www.wikidata.org/entity/Q1045720 Carsten Thomassen
13 http://www.wikidata.org/entity/Q2574238 Lars Ramkilde Knudsen YayQtGUAAAAJ 9001 4205 39 24 95 53
14 http://www.wikidata.org/entity/Q12340430 Vagn Lundsgaard Hansen zyD3pIQAAAAJ 711 187 15 6 22 2
15 http://www.wikidata.org/entity/Q20980928 Finn Årup Nielsen 9cagBQYAAAAJ 3269 1658 28 22 47 31
16 http://www.wikidata.org/entity/Q20984804 Lars Kai Hansen gQVuJh8AAAAJ 13363 5698 51 34 168 95
17 http://www.wikidata.org/entity/Q22329229 Christian Damsgaard Jensen
18 http://www.wikidata.org/entity/Q24265879 Matthew G. Liptrot n0NYEY0AAAAJ 727 469 10 9 10 9
19 http://www.wikidata.org/entity/Q24283608 Jan Larsen 6Y_3isIAAAAJ 3641 1584 31 19 81 43
20 http://www.wikidata.org/entity/Q24290415 Ole Winther 7VAwhzUAAAAJ 3602 2199 28 20 60 41
21 http://www.wikidata.org/entity/Q25927688 Flemming Nielson QUVToEgAAAAJ 7931 2199 41 18 121 41
22 http://www.wikidata.org/entity/Q25927874 Hanne Riis Nielson 5U0XVHUAAAAJ 6950 2016 34 18 103 36
23 http://www.wikidata.org/entity/Q25931571 Jakob Eg Larsen EztREm4AAAAJ 401 366 10 10 11 10
24 http://www.wikidata.org/entity/Q25931588 Bjarne Kjær Ersbøll
25 http://www.wikidata.org/entity/Q25931597 Barbara Weber iEBRDLkAAAAJ 4592 3738 35 33 72 68
26 http://www.wikidata.org/entity/Q25932562 Per Bruun Brockhoff Gw8WMDgAAAAJ 3269 2188 30 22 56 45
27 http://www.wikidata.org/entity/Q25932641 Anders Bjorholm Dahl WsgfNRMAAAAJ 340 333 11 11 13 13
28 http://www.wikidata.org/entity/Q25935231 Morten Brøns MJ-eQQUAAAAJ 1159 536 18 12 32 20
29 http://www.wikidata.org/entity/Q25935243 Mads Peter Sørensen Va9EeXEAAAAJ 1653 655 24 14 52 22
30 http://www.wikidata.org/entity/Q25935257 Jørgen Fischer Nilsson
31 http://www.wikidata.org/entity/Q25935274 Paul Fischer 18o5q3AAAAAJ 2563 1888 11 6 12 5
32 http://www.wikidata.org/entity/Q25935293 Michael Pedersen GmEaLu8AAAAJ 474 221 11 8 14 6
33 http://www.wikidata.org/entity/Q25935308 Jens Sparsø UDM68ncAAAAJ 3282 1368 21 16 37 24
34 http://www.wikidata.org/entity/Q25935328 Anders Stockmarr jWnA798AAAAJ 1185 762 16 13 25 20
35 http://www.wikidata.org/entity/Q25939218 J. Andreas Bærentzen if2X4wkAAAAJ 1241 681 16 11 28 16
36 http://www.wikidata.org/entity/Q25939334 Henrik Aanæs WTjCRE8AAAAJ 1176 790 16 14 26 20
Personal tools