ConferenceCorpus/statistics

From BITPlan Wiki
Revision as of 12:47, 18 May 2022 by Wf (talk | contribs)
Jump to navigation Jump to search

Ordinal histogramms

ceurws

Ordinalhistogramm event ceurws.png

orbackup

Ordinalhistogramm event orbackup.png

orclonebackup

Ordinalhistogramm event orclonebackup.png

confref

Ordinalhistogramm event confref.png

gnd

Ordinalhistogramm event gnd.png

wikicfp

Ordinalhistogramm event wikicfp.png

or

Ordinalhistogramm event or.png

orclone

Ordinalhistogramm event orclone.png

tibkat

Ordinalhistogramm event tibkat.png

dblp

Ordinalhistogramm event dblp.png

crossref

Ordinalhistogramm event crossref.png

wikidata

Ordinalhistogramm event wikidata.png

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

       Wikidata series completeness.png