Keyword frequencies in popular tech media (01.2016-04.2019)

Sources with weights

• Euractiv 5%
• The Conversation 5%
• Politico Europe 5 %
• IEEE Spectrum 5 %
• Techforge 5%
• Fastcompany 5%
• The Guardian (Tech) 12%
• Arstechnica 5%
• Reuters 5%
• Gizmodo 9%
• ZDNet 9%
• The Register 12%
• The Verge 9%
• TechCrunch 9%

Methodology

• Frequency of appearances for all unigrams and bigrams in the texts
• Frequency: number of appearances of every term divided by the number of published articles (for every month and source)
• This measure reveals how many times an expression has been mentioned on average per article
• Several media sources: a representative index is calculated with weighted average (weights as above)
• Average monthly change in the analised term's frequency is calculated by OLS regressions
• The dependent variable of the estimation is the frequency index, while the number of months since the beginning of the analysed period (January 2016) is the independent variable
• The regression coefficient (referred to as coef) shows by how much on average the analysed expression’s frequency changed with every observed month (marginal change of the frequency), revealing which keywords had the biggest monthly growth

Files

The dataset contains two files:

Unigrams: coefs_1weighted_site.csv

Bigrams: coefs_2weighted_site.csv

Columns

freq_months (e.g. freq_2019-04): the average frequency of the term

coef: the regression coefficient

coef_norm: the regression coefficient divided by the mean frequency of the keyword

coef_norm_max: the regression coefficient divided by the maximum frequency of the keyword