X-Git-Url: https://code.communitydata.science/covid19.git/blobdiff_plain/5ffb2cacd695e3d9b20b8d61099356479cf34fd0..c54d8ba28ac8fe22b3da3ee171277fbabffe64fb:/wikipedia_views/scripts/fetch_daily_views.py

diff --git a/wikipedia_views/scripts/fetch_daily_views.py b/wikipedia_views/scripts/fetch_daily_views.py
new file mode 100755
index 0000000..5ce989f
--- /dev/null
+++ b/wikipedia_views/scripts/fetch_daily_views.py
@@ -0,0 +1,98 @@
+#!/usr/bin/env python3
+
+###############################################################################
+#
+# This script assumes the presence of the COVID-19 repo.
+# 
+# It (1) reads in the article list and then (2) calls the Wikimedia API to 
+# fetch view information for each article. Output is to (3) JSON and TSV.
+#
+###############################################################################
+
+
+import requests
+import argparse
+import json
+import csv
+import time
+import os.path
+import datetime
+#import feather
+
+
+
+def parse_args():
+
+    parser = argparse.ArgumentParser(description='Call the views API repeatedly.')
+    parser.add_argument('-o', '--output_folder', help='Where to save output', default="../data/", type=str)
+    parser.add_argument('-i', '--article_file', help='File listing article names', default="../resources/articles.txt", type=str)
+    parser.add_argument('-d', '--query_date', help='Date if not yesterday, in YYYYMMDD format please.', type=str)
+    args = parser.parse_args()
+
+    return(args)
+
+
+def main():
+
+    args = parse_args()
+
+    outputPath = args.output_folder
+    articleFile = args.article_file
+
+    if (args.query_date):
+        queryDate = args.query_date
+    else:
+        yesterday = datetime.datetime.today() - datetime.timedelta(days=1)
+        queryDate = yesterday.strftime("%Y%m%d")
+
+    queryDate = queryDate + "00" #requires specifying hours
+
+
+    articleList = []
+#1 Load up the list of article names
+
+    with open(articleFile, 'r') as infileHandle:
+        theInfile = csv.reader(infileHandle)
+        next(theInfile) #skip header
+        for currentLine in theInfile:
+            articleList.append(currentLine)
+
+    j_Out = outputPath + "dailyviews" + queryDate + ".json"
+    t_Out = outputPath + "dailyviews" + queryDate + ".tsv"
+
+    j = []
+
+    i = 0 #iterator to deal with end of file
+
+#2 Repeatedly call the API with that list of names
+
+    for a in articleList:
+        a = a[0] #destringify
+        i = i+1
+        url= "https://wikimedia.org/api/rest_v1/metrics/pageviews/per-article/en.wikipedia/all-access/all-agents/"
+        url= url + a + "/daily/" + queryDate + "/" + queryDate #for now, single date at a time
+        response = requests.get(url)
+        if response.ok:
+            jd = json.loads(response.content)
+            j.append(jd["items"][0])
+            time.sleep(.1)
+
+#3 Save results as a JSON and TSV
+
+    #all data in j now, make json file
+    with open(j_Out, 'w') as j_outfile: 
+        json.dump(j, j_outfile, indent=2)
+
+    with open(t_Out, 'w') as t_outfile:
+        dw = csv.DictWriter(t_outfile, sorted(j[0].keys()), delimiter='\t')
+        dw.writeheader()
+        dw.writerows(j)
+
+
+    f_Out = outputPath + "dailyviews" + queryDate + ".feather"
+    #read the json back in and make a feather file? 
+
+
+if __name__ == "__main__":
+
+    main()