{"id":3189,"date":"2017-04-16T20:16:59","date_gmt":"2017-04-17T01:16:59","guid":{"rendered":"http:\/\/commons.trincoll.edu\/amst-data-driven\/?p=3189"},"modified":"2017-04-16T20:17:29","modified_gmt":"2017-04-17T01:17:29","slug":"lab-5-an-excel-felina-to-standingrock","status":"publish","type":"post","link":"http:\/\/commons.trincoll.edu\/amst-data-driven\/2017\/04\/16\/lab-5-an-excel-felina-to-standingrock\/","title":{"rendered":"Lab 5 &#8211; an Excel Felina to #standingrock"},"content":{"rendered":"<p>Pie Graphin&#8217;<\/p>\n<p>I count 16 different languages &#8211; da, de, en, en-GB (which is totally a different language if it&#8217;s cockney), es, fr, hu, id, it, ja, ko, nl, pl, ru, sv, tr. Using the countIf function, I identified 2389 english tweets. The percentage of English tweets from my February 22-24th dataset is 2389\/2669 or 89.51% however, when I added the en-GB the percentage increased to 90.63%.<\/p>\n<p><img loading=\"lazy\" class=\"aligncenter wp-image-3227\" src=\"http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Pies-for-days-300x196.png\" alt=\"Pies for days\" width=\"457\" height=\"299\" srcset=\"http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Pies-for-days-300x196.png 300w, http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Pies-for-days-768x503.png 768w, http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Pies-for-days-1024x670.png 1024w, http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Pies-for-days.png 1077w\" sizes=\"(max-width: 457px) 100vw, 457px\" \/><\/p>\n<p>It certainly doesn&#8217;t surprise me that English accounted for over 90% of those tweeting #standingrock. However, I was very interested to see that #standingrock was referenced in 15 other languages. I do not see any meaningful trends in these other languages, but in thinking of my geolocation data, this lab actually revealed more geographical information that my geolocation did! I think it definitely makes sense that French speaking and Spanish speaking countries comprise larger percentages of the remaining 10% of tweets. These tweets might be coming from France or Spain &#8211; relatively liberal countries &#8211; or some areas of Spanish or French colonial influence who would certainly be supportive of indigenous rights. However, Hungarian, Italian, and German actually made up comparable or larger percentages than French or Spanish &#8211; a conclusion I would not have expected from my data. If I had to guess why the above languages were used to reference #standingrock, I think one of the few linking characteristics of these languages here would be their relation to western culture and thus western news. With the exception of Russia (who for all we know may have been trying to spread false claims in support of the DAPL), I feel as though the cultures of countries where tweets in these languages could reasonably be expected to be seen would be receptive to discourse regarding climate change. Even Korea and Japan pay media attention to turmoil in the United States, and especially with respect to Japan are countries whose culture would allow\/promote the importance of civil discourse regarding climate change.<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-medium wp-image-3402\" src=\"http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/McNoogitCrunch-300x180.png\" alt=\"McNoogitCrunch\" width=\"300\" height=\"180\" srcset=\"http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/McNoogitCrunch-300x180.png 300w, http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/McNoogitCrunch.png 752w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<table style=\"border-collapse: collapse;width: 415px;height: 78px\" border=\"0\" width=\"174\" cellspacing=\"0\" cellpadding=\"0\">\n<colgroup>\n<col style=\"width: 65pt\" span=\"2\" width=\"87\" \/> <\/colgroup>\n<tbody>\n<tr style=\"height: 16.0pt\">\n<td style=\"height: 16.0pt;width: 65pt\" width=\"87\" height=\"21\">Time<\/td>\n<td style=\"width: 65pt\" width=\"87\">Number of Tweets<\/td>\n<\/tr>\n<tr style=\"height: 16.0pt\">\n<td style=\"height: 16.0pt\" height=\"21\"><\/td>\n<td><\/td>\n<\/tr>\n<tr style=\"height: 16.0pt\">\n<td class=\"xl63\" style=\"height: 16.0pt\" height=\"21\">2\/22\/2017 &gt; 12:00<\/td>\n<td align=\"right\">401<\/td>\n<\/tr>\n<tr style=\"height: 16.0pt\">\n<td style=\"height: 16.0pt\" height=\"21\">2\/22\/2017 &lt; 12:00<\/td>\n<td align=\"right\">193<\/td>\n<\/tr>\n<tr style=\"height: 16.0pt\">\n<td class=\"xl63\" style=\"height: 16.0pt\" height=\"21\">2\/23\/2017 &gt; 12:00<\/td>\n<td align=\"right\">891<\/td>\n<\/tr>\n<tr style=\"height: 16.0pt\">\n<td class=\"xl63\" style=\"height: 16.0pt\" height=\"21\">2\/23\/2017 &lt; 12:00<\/td>\n<td align=\"right\">297<\/td>\n<\/tr>\n<tr style=\"height: 16.0pt\">\n<td class=\"xl63\" style=\"height: 16.0pt\" height=\"21\">2\/24\/2017 &gt; 12:00<\/td>\n<td align=\"right\">293<\/td>\n<\/tr>\n<tr style=\"height: 16.0pt\">\n<td class=\"xl63\" style=\"height: 16.0pt\" height=\"21\">2\/24\/2017 &lt; 12:00<\/td>\n<td align=\"right\">594<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>I used a countif(range, &#8220;&gt;12:00&#8221;) to calculate the number of tweets before and after noon for each of the three days I analyzed. Considering the events of 2\/22\/17 i.e. the forced removal of water protectors from the sacred stone camp, it actually makes a lot of sense to me that the number tweets on 2\/22\/17 would be smaller than on 2\/23 or 2\/24. This presents lag time between the actual removal and the twitter discussion of the events, which definitely aligns with a sad theme of solidarity in #standingrock: many supporters of the Sioux are much more inclined to do so from the safety of their computers or phones than by actually going to the Standing Rock reservation. On 2\/23, tweets from #standingrock spiked &#8211; evidence that more people were talking about the events &#8211; and this can be accounted for by increased media coverage of this terrible development in the Standing Rock movement. Thus people noticed something new had happened, rather than actually being aware of different facets concerning the movement. For instance, when I search standing rock 2\/22, the results are far less involved than those on 2\/23. For 2\/22\/, the first link returned is a facebook post, the second a CBS story about protesters removed, and the subsequent links from various smaller news sources (except CNN &#8211; they had one further down the page). Meanwhile, for 2\/23, the first result returned is this:<\/p>\n<p>https:\/\/www.facebook.com\/402298239798452\/photos\/a.422881167740159.110630.402298239798452\/1551708291524102\/?type=3 &#8211; a public statement from the Standing Rock Sioux. The next link was coverage of the removal from The Guardian, a British newspaper with a large international circulation. I imagine there were people who tweeted #standingrock on 2\/23 and 2\/24 internationally who read that article.<\/p>\n<p>My mean tweets were 889, my median was 887, and mode was not available. My total tweets was 2699, while my max, min, and range were 1188, 594 , and 594. The fact that my min and range were equivalent is oddly troubling, however, I am going to hope I did everything correctly! I did not feel as though my data was an outlier from my peers. None of my descriptive statistics presented an extreme in the class data, and furthermore, I believe my data evidences that #standingrock is a day to day trending hashtag. In other words, it will spike when something new happens, but otherwise, it is not a constantly trending topic on twitter. Perhaps in relation to Gillespie, this points to Twitter&#8217;s calculated approach to creating the circles of discussion we mapped in the last lab. If twitter is keeping trends within certain groups, then it would make sense that I saw similar twitter handles in the last lab when mapping data on Feb 22-24. And if twitter is keeping trends within groups that are receptive to them, then no wonder my max, min, and range were so eerily similar. \u00a0My descriptive statistics did not really tell me anything I didn&#8217;t already know. In fact, I found this to be the least revealing analysis of my data thus far. I would expect this too! I am just using simple functions to analyze my data, when in reality, my data requires much more complex functions to properly and adequately analyze.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Pie Graphin&#8217; I count 16 different languages &#8211; da, de, en, en-GB (which is totally a different language if it&#8217;s cockney), es, fr, hu, id, it, ja, ko, nl, pl, ru, sv, tr. Using the countIf function, I identified 2389 english tweets. The percentage of English tweets from my February 22-24th dataset is 2389\/2669 or&#8230;<\/p>\n","protected":false},"author":1965,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[11],"tags":[],"_links":{"self":[{"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/posts\/3189"}],"collection":[{"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/users\/1965"}],"replies":[{"embeddable":true,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/comments?post=3189"}],"version-history":[{"count":4,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/posts\/3189\/revisions"}],"predecessor-version":[{"id":3404,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/posts\/3189\/revisions\/3404"}],"wp:attachment":[{"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/media?parent=3189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/categories?post=3189"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/tags?post=3189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}