ConferenceCorpus/statistics

From BITPlan Wiki
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

confref

sql query

SELECT 
   seriesId,
   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_confref
Where ordinal is not null 
group by seriesId
order by 6 desc

histogramm

Confref series completeness.png

wikicfp

sql query

SELECT 
   seriesId,
   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_wikicfp
Where ordinal is not null 
group by seriesId
order by 6 desc

histogramm

Wikicfp series completeness.png

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