Keyword frequencies in popular tech media during the COVID-19 pandemic (01.2020-06.2020)

Sources: 

Euractiv

The Conversation

Politico Europe 

IEEE Spectrum 

Techforge 

Fastcompany 

The Guardian (Tech) 

Arstechnica 

Reuters 

Gizmodo 

ZDNet 

The Register 

The Verge 

TechCrunch 

Methodology is modified relative to the regular trend analysis due to the short period of analysis (weekly freqiencies)

Frequency of appearances for all unigrams and bigrams in the texts

Frequency: number of appearances of every term divided by the number of all terms (for every week) 

Several media sources: all articles are treated equally

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 weeks since the beginning of the analysed period (January 2020) 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 week (marginal change of the frequency), revealing which keywords had the biggest weekly growth

Columns

freq_2020_weeks (e.g. freq_2020_ww0): the average frequency of the term

coef: the regression coefficient

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