Difference between revisions of "ConferenceCorpus/statistics"
Jump to navigation
Jump to search
(→acm) |
|||
| Line 35: | Line 35: | ||
== wikidata== | == wikidata== | ||
[[File:ordinalhistogramm_event_wikidata.png|600px]] | [[File:ordinalhistogramm_event_wikidata.png|600px]] | ||
| + | = Eventseries completeness = | ||
| + | == wikidata == | ||
| + | === sql query === | ||
| + | <source lang='sql'> | ||
| + | SELECT | ||
| + | eventInSeriesId, | ||
| + | min(ordinal) as minOrdinal, | ||
| + | max(ordinal) as maxOrdinal, | ||
| + | avg(ordinal) as avgOrdinal, | ||
| + | max(Ordinal)-min(Ordinal) as available, | ||
| + | (max(Ordinal)-min(Ordinal)) /(max(Ordinal)-1.0) as completeness | ||
| + | FROM event_wikidata | ||
| + | Where ordinal is not null | ||
| + | group by eventInSeriesId | ||
| + | order by 6 desc | ||
| + | |||
| + | </source> | ||
| + | === histogramm === | ||
| + | [[File:wikidata_series_completeness.png|600px]] | ||
Revision as of 13:47, 18 May 2022
Ordinal histogramms
ceurws
orbackup
orclonebackup
confref
gnd
wikicfp
or
orclone
tibkat
dblp
crossref
wikidata
Eventseries completeness
wikidata
sql query
SELECT
eventInSeriesId,
min(ordinal) as minOrdinal,
max(ordinal) as maxOrdinal,
avg(ordinal) as avgOrdinal,
max(Ordinal)-min(Ordinal) as available,
(max(Ordinal)-min(Ordinal)) /(max(Ordinal)-1.0) as completeness
FROM event_wikidata
Where ordinal is not null
group by eventInSeriesId
order by 6 desc
histogramm
