From: Aaron Shaw <aaronshaw@northwestern.edu>
Date: Sat, 28 Mar 2020 22:38:20 +0000 (-0500)
Subject: Merge pull request #8 from aaronshaw/master
X-Git-Url: https://code.communitydata.science/covid19.git/commitdiff_plain/c0e50fe2973328aeec49e9595606393bbf2d52c3?hp=033149776c8bebf2a566c36d4d4b0d3ab8c9c48f

Merge pull request #8 from aaronshaw/master

Update to load data from github url and include 3/28 data in output
---

diff --git a/transliterations/analysis/output/top5_queries_per_term_per_date.csv b/transliterations/analysis/output/top5_queries_per_term_per_date.csv
index 5ce1aa7..83b5aff 100644
--- a/transliterations/analysis/output/top5_queries_per_term_per_date.csv
+++ b/transliterations/analysis/output/top5_queries_per_term_per_date.csv
@@ -1,6 +1,11 @@
 "term","date","query.1","query.2","query.3","query.4","query.5"
-"coronavirus","2020-03-27",coronavirus update,corona,coronavirus symptoms,news coronavirus,coronavirus cases
-"covid-19","2020-03-27",covid-19 coronavirus,coronavirus,covid,covid-19 cases,covid 19
-"covid-19 pandemic","2020-03-27",coronavirus,covid-19 coronavirus pandemic,coronavirus pandemic,who,is covid-19 a pandemic
-"covid19","2020-03-27",covid,covid 19,coronavirus covid19,coronavirus,covid19 cases
-"sars-cov-2","2020-03-27",coronavirus,coronavirus sars-cov-2,covid-19,covid-19 sars-cov-2,sars
+"coronavirus",2020-03-27,coronavirus update,corona,coronavirus symptoms,news coronavirus,coronavirus cases
+"covid-19",2020-03-27,covid-19 coronavirus,coronavirus,covid,covid-19 cases,covid 19
+"covid-19 pandemic",2020-03-27,coronavirus,covid-19 coronavirus pandemic,coronavirus pandemic,who,is covid-19 a pandemic
+"covid19",2020-03-27,covid,covid 19,coronavirus covid19,coronavirus,covid19 cases
+"sars-cov-2",2020-03-27,coronavirus,coronavirus sars-cov-2,covid-19,covid-19 sars-cov-2,sars
+"coronavirus",2020-03-28,coronavirus update,corona,coronavirus symptoms,news coronavirus,coronavirus cases
+"covid-19",2020-03-28,coronavirus,coronavirus covid-19,covid,covid-19 cases,covid 19
+"covid-19 pandemic",2020-03-28,coronavirus pandemic,coronavirus,covid-19 coronavirus pandemic,is covid-19 a pandemic,who pandemic
+"covid19",2020-03-28,covid,covid 19,coronavirus covid19,coronavirus,covid19 cases
+"sars-cov-2",2020-03-28,coronavirus sars-cov-2,coronavirus,sars-cov-2 covid-19,covid-19,sars
diff --git a/transliterations/analysis/related_searches_example.R b/transliterations/analysis/related_searches_example.R
index 2576d4a..e1197b6 100644
--- a/transliterations/analysis/related_searches_example.R
+++ b/transliterations/analysis/related_searches_example.R
@@ -3,16 +3,24 @@
 ### 
 ### Minimal example analysis file using trending search data
 
-### Identify data source directory and file
-DataDir <- ("../data/output/")
-DataFile <- ("related_searches_top.csv")
-
 ### Import and cleanup data
-related.searches.top <- read.table(paste(DataDir,DataFile,
-                                 sep=""),
+
+DataURL <-
+    url("https://github.com/CommunityDataScienceCollective/COVID-19_Digital_Observatory/blob/master/transliterations/data/output/related_searches_top.csv")
+
+related.searches.top <- read.table(DataURL,
                            sep=",", header=TRUE,
                            stringsAsFactors=FALSE) 
 
+### Alternatively, uncomment and run if working locally with full git tree
+### Identify data source directory and file
+## DataDir <- ("../data/output/")
+## DataFile <- ("related_searches_top.csv")
+
+## related.searches.top <- read.table(paste(DataDir,DataFile, sep=""),
+##                                   sep=",", header=TRUE,
+##                                   stringsAsFactors=FALSE)
+
 ### Aggregate top 5 search queries by term/day
 top5.per.term.date <- aggregate(query ~ term + date,
                                 data=related.searches.top,