Difference between revisions of "ConferenceCorpus/statistics"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
= Ordinal histogramms = | = Ordinal histogramms = | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
== confref== | == confref== | ||
| − | [[File:ordinalhistogramm_event_confref.png|600px]] | + | [[File:ordinalhistogramm_event_confref.png|600px]] |
| + | [[File:zipf_event_confref.png|600px]] | ||
| − | == | + | == Crossref== |
| − | [[File: | + | [[File:ordinalhistogramm_event_crossref.png|600px]] |
| + | [[File:zipf_event_crossref.png|600px]] | ||
| − | == | + | == dblp== |
| − | [[File: | + | [[File:ordinalhistogramm_event_dblp.png|600px]] |
| + | [[File:zipf_event_dblp.png|600px]] | ||
| − | == | + | == GND== |
| − | [[File: | + | [[File:ordinalhistogramm_event_gnd.png|600px]] |
| + | [[File:zipf_event_gnd.png|600px]] | ||
| − | == | + | == OpenResearch== |
| − | [[File:ordinalhistogramm_event_orclone.png|600px]] | + | [[File:ordinalhistogramm_event_orclone.png|600px]] |
| − | + | [[File:zipf_event_orclone.png|600px]] | |
| − | == | + | |
| − | [[File:ordinalhistogramm_event_tibkat.png|600px]] | + | == TIBKAT== |
| − | + | [[File:ordinalhistogramm_event_tibkat.png|600px]] | |
| − | + | [[File:zipf_event_tibkat.png|600px]] | |
| − | [[File: | ||
| − | == | + | == WikiCFP== |
| − | [[File: | + | [[File:ordinalhistogramm_event_wikicfp.png|600px]] |
| + | [[File:zipf_event_wikicfp.png|600px]] | ||
| − | == | + | == Wikidata== |
| − | [[File:ordinalhistogramm_event_wikidata.png|600px]] | + | [[File:ordinalhistogramm_event_wikidata.png|600px]] |
| + | [[File:zipf_event_wikidata.png|600px]] | ||
| + | |||
= Eventseries completeness = | = Eventseries completeness = | ||
== dblp == | == dblp == | ||
Revision as of 07:59, 19 May 2022
Ordinal histogramms
confref
Crossref
dblp
GND
OpenResearch
TIBKAT
WikiCFP
Wikidata
Eventseries completeness
dblp
sql query
SELECT
series,
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_dblp
Where ordinal is not null
group by series
order by 6 desc
histogramm
openresearch
sql query
SELECT
inEventSeries,
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_orclone
Where ordinal is not null
group by inEventSeries
order by 6 desc
histogramm
tibkat
sql query
For tibkat a direct SQL query was not possible since the series info is not available. We therefore filtered by series acronym using python code to get an indication. 3136 series where identified this way and then the histogramm was created from the data
histogramm
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
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
