{"id":485,"date":"2018-10-14T13:49:11","date_gmt":"2018-10-14T12:49:11","guid":{"rendered":"http:\/\/www.igfasouza.com\/blog\/?p=485"},"modified":"2021-05-20T14:30:10","modified_gmt":"2021-05-20T13:30:10","slug":"odc-appreciation-day-2018-tweet-analysis","status":"publish","type":"post","link":"http:\/\/www.igfasouza.com\/blog\/odc-appreciation-day-2018-tweet-analysis\/","title":{"rendered":"ODC Appreciation Day 2018 : Tweet analysis"},"content":{"rendered":"<p><b>How\u2019s the craic?<\/b><br \/>\n<small style=\"color:#9f9f9f\">2018\/10\/14<\/small><\/p>\n<p>Last Thursday was the Oracle Developer Community ODC Appreciation Day 2018 <a href=\"https:\/\/oracle-base.com\/blog\/2018\/09\/27\/oracle-developer-community-odc-appreciation-day-2018-thanksodc\/\" rel=\"noopener\" target=\"_blank\">#ThanksODC<\/a><\/p>\n<p>I came across with the #ThanksODC idea Thursday afternoon and of course, I join with a blog post as well. <a href=\"http:\/\/www.igfasouza.com\/blog\/odc-appreciation-day-2018-oracle-visual-builder-cloud-and-oracle-jet\/\" rel=\"noopener\" target=\"_blank\">Here<\/a><\/p>\n<p>And you can check the result of #ThanksODC <a href=\"https:\/\/oracle-base.com\/blog\/2018\/10\/12\/odc-appreciation-day-2018-its-a-wrap-thanksodc\/\" rel=\"noopener\" target=\"_blank\">here<\/a><\/p>\n<p>Today I decided to do my tweets analysis here and see some nice insights.<\/p>\n<p><strong>But just to clarify.<\/strong><\/p>\n<ul>\n<li>This is my blog, so views expressed here are my own and do not necessarily reflect the views of Oracle and I&#8217;m not contesting the result given by oracle-base.<\/li>\n<li>The idea here is just fun.<\/li>\n<li>I think I\u2019m the only Brazilian and the only person in Dublin to participate. (Two points that I couldn&#8217;t validate) <\/li>\n<\/ul>\n<p>You can check my old post to see an explanation about the idea and maths behind<\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"WTE0kOYjLe\"><p><a href=\"http:\/\/www.igfasouza.com\/blog\/six-nations\/\">Six Nations<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Six Nations&#8221; &#8212; Igfasouza.com\" src=\"http:\/\/www.igfasouza.com\/blog\/six-nations\/embed\/#?secret=xHD8IaODfW#?secret=WTE0kOYjLe\" data-secret=\"WTE0kOYjLe\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p><strong>Let&#8217;s check the data.<\/strong><\/p>\n<p>I run my script to get the tweets at 12\/10\/2018 14:00 Dublin time and I got 51 tweets.<\/p>\n<p>13 tweets at 12\/10 and 38 at 11\/10.<br \/>\nThe first tweet at 11\/10 was 08:14:18 and the last one was 23:31:44.<br \/>\nThe last tweet that I got was 12\/10 at 12:31:34.<\/p>\n<p>I found 46 links to a blog post<br \/>\nI found 8 tweets with ODC Appreciation Day 2018<\/p>\n<p><strong>Counting Terms<\/strong><\/p>\n<p>Top 10<\/p>\n<p>[(&#8216;Appreciation&#8217;, 31), (&#8216;ODC&#8217;, 27), (&#8216;Day&#8217;, 25), (&#8216;the&#8217;, 19), (&#8216;to&#8217;, 17), (&#8216;for&#8217;, 14), (&#8216;I&#8217;, 11), (&#8216;a&#8217;, 11), (&#8216;and&#8217;, 10), (&#8216;in&#8217;, 9)]<\/p>\n<p><strong>without Stop-words<\/strong><\/p>\n<p>Top 10<\/p>\n<p>[(&#8216;Appreciation&#8217;, 32), (&#8216;ODC&#8217;, 28), (&#8216;Day&#8217;, 26), (&#8216;Oracle&#8217;, 9), (&#8216;2018&#8217;, 9), (&#8216;Wrap&#8217;, 6), (&#8216;posts&#8217;, 6), (&#8216;ORDS&#8217;, 5), (&#8216;may&#8217;, 5), (&#8216;blog&#8217;, 5)]<\/p>\n<p><strong>Languages<\/strong><\/p>\n<p>All tweets are in English, but I found six blogs in Spanish.<\/p>\n<ul>\n<li>\n<a href=\"https:\/\/plsql-argentina.blogspot.com\/2018\/10\/odc-appreciation-day-muchas-gracias-la.html\" rel=\"noopener\" target=\"_blank\">https:\/\/plsql-argentina.blogspot.com\/2018\/10\/odc-appreciation-day-muchas-gracias-la.html<\/a>\n<\/li>\n<li>\n<a href=\"https:\/\/descubriendooracle.blogspot.com\/2018\/10\/odc-appreciation-day-2018-evangelizando.html?spref=tw\" rel=\"noopener\" target=\"_blank\">https:\/\/descubriendooracle.blogspot.com\/2018\/10\/odc-appreciation-day-2018-evangelizando.html?spref=tw<\/a>\n<\/li>\n<li>\n<a href=\"http:\/\/oracleparatodos1.blogspot.com\/2018\/10\/odc-appreciation-day-operaciones-online.html\" rel=\"noopener\" target=\"_blank\">http:\/\/oracleparatodos1.blogspot.com\/2018\/10\/odc-appreciation-day-operaciones-online.html<\/a>\n<\/li>\n<li>\n<a href=\"https:\/\/edelweissoraclebi.blogspot.com\/2018\/10\/odc-appreciation-day-autonomous-data.html\" rel=\"noopener\" target=\"_blank\">https:\/\/edelweissoraclebi.blogspot.com\/2018\/10\/odc-appreciation-day-autonomous-data.html<\/a>\n<\/li>\n<li>\n<a href=\"http:\/\/oracleparatodos1.blogspot.com\/2018\/10\/odc-appreciation-day-operaciones-online.html\" rel=\"noopener\" target=\"_blank\">http:\/\/oracleparatodos1.blogspot.com\/2018\/10\/odc-appreciation-day-operaciones-online.html<\/a>\n<\/li>\n<li>\n<a href=\"http:\/\/dbaoraclesoporte.blogspot.com\/2018\/10\/odc-apprecitaion-day-2018-sql-tuning.html\" rel=\"noopener\" target=\"_blank\">http:\/\/dbaoraclesoporte.blogspot.com\/2018\/10\/odc-apprecitaion-day-2018-sql-tuning.html<\/a>\n<\/li>\n<\/ul>\n<p>Tweets 100% English<br \/>\nBlog post 40 English 6 Spanish<\/p>\n<p><strong>Sentiment Analysis<\/strong><\/p>\n<p>Here the API gives a value between -1 and 1.<br \/>\n-1 to negative, 0 to neutral and 1 to positive.<\/p>\n<p>The result is 88% positive, 11% neutral and 1% negative.<\/p>\n<p><strong>Retweets<\/strong><\/p>\n<p>Top Retweets -> 12<br \/>\n@oraclebase &#8211; ODC Appreciation Day 2018 : It\u2019s a Wrap (#ThanksODC) : https:\/\/t.co\/RYOeFzyHAs https:\/\/t.co\/cQsj0N5xVB<\/p>\n<p><strong>Likes<\/strong><\/p>\n<p>Top Likes -> 28<br \/>\n@HeliFromFinland &#8211; Oracle SQL Developer Data Modeler is my favourite tool #ThanksODC https:\/\/t.co\/ZXr3GI2LXV<\/p>\n<p><strong>Hashtag<\/strong><\/p>\n<p>If we have a look at the most common hashtags, we need to consider that #ThanksODC will be in all tweets because I used as a filter, so we can exclude it from the list. This leaves us with:<\/p>\n<p>2 #ThanksOTN<br \/>\n2 #oow18<br \/>\n1 #oracle<br \/>\n1 #SOASuite<br \/>\n1 #ThanksOracleBase<br \/>\n1 #OrclDB<br \/>\n1 #ThanksTim<br \/>\n1 #oracleace<br \/>\n1 #ODCAppreciationDay<br \/>\n1 #ThanksOTNOTN\/ODC<br \/>\n1 #orclepm<br \/>\n1 #orclbi<br \/>\n1 #Terraform<br \/>\n1 #ThanksTim<br \/>\n1 #plsql<br \/>\n1 #sq<br \/>\n1 #SeeYouAtOpenWorld<br \/>\n1 #ACED<\/p>\n<p>number of hashtags per tweet<\/p>\n<p>1 tweet with 4 hashtags<br \/>\n4 tweet with 3 hashtags<br \/>\n3 tweet with 2 hashtags<\/p>\n<p>number of @<\/p>\n<p>8 @oracleace<br \/>\n7 @oraclebase<br \/>\n2 @OracleDevsLA<br \/>\n2 @connor_mc_d<br \/>\n1 @rickProdManager<br \/>\n1 @odtug<br \/>\n1 @OracleDevs<br \/>\n1 @joelkallman<br \/>\n1 @OraPubInc<br \/>\n1 @oravirt<br \/>\n1 @odevcommunity<br \/>\n1 @floo_bar<br \/>\n1 @oracle<br \/>\n1 @gwronald<br \/>\n1 @dhamijarohit<br \/>\n1 @wordpressdotcom<br \/>\n1 @FTisiot<\/p>\n<p>number of @ per tweet<\/p>\n<p>2 tweet with 4 @<br \/>\n3 tweet with 3 @<br \/>\n1 tweet with 2 @<\/p>\n<p><strong>Spelling mistakes<\/strong><\/p>\n<p>Here I remove all hashtags and I found just one mistake and was &#8220;mornging&#8221;<\/p>\n<p><strong>Source<\/strong><\/p>\n<p>23 Twitter Web Client<br \/>\n06 TweetDeck<br \/>\n05 WordPress.com<br \/>\n03 Twitter Lite<br \/>\n03 Twitter for Android<br \/>\n03 Twitter for iPhone<br \/>\n01 IFTTT<br \/>\n02 Tweetbot for Mac<br \/>\n01 Hootsuite Inc.<br \/>\n01 Twibble.io<br \/>\n01 dlvr.it<br \/>\n01 Tweetbot for i\u039fS<br \/>\n01 Twitter Ads Composer<\/p>\n<p>Number of tweets per user<\/p>\n<p>4 LucasBednarek<br \/>\n3 oraculix<br \/>\n2 debralilley<br \/>\n2 RobbieDatabee<br \/>\n2 Makker_nl<br \/>\n2 kibeha<br \/>\n2 oraclebase<br \/>\n2 ZedDBA<br \/>\n2 Igfasouza<br \/>\n2 amitzil<br \/>\n1 orana<br \/>\n1 daanbakboord<br \/>\n1 orclDBblogs<br \/>\n1 ITProjectsToday<br \/>\n1 EdelweissK<br \/>\n1 signal006<br \/>\n1 ritan2000<br \/>\n1 Nikitas_Xenakis<br \/>\n1 mathiasmag<br \/>\n1 simon_haslam<br \/>\n1 PeterRaganitsch<br \/>\n1 HeliFromFinland<br \/>\n1 gassenmj<br \/>\n1 FranckPachot<br \/>\n1 SvenWOracle<br \/>\n1 opal_EPM<br \/>\n1 reguchi_br<br \/>\n1 rodrigojorgedba<br \/>\n1 svilmune<br \/>\n1 swesley_perth<br \/>\n1 dw_pete<br \/>\n1 oraesque<br \/>\n1 RonEkins<br \/>\n1 connor_mc_d<br \/>\n1 Addidici<br \/>\n1 dan_ekb<br \/>\n1 rittmanmead<br \/>\n1 FTisiot<\/p>\n<p>My preferred tweet:<br \/>\nI really should go to sleep \ud83d\udca4, but I\u2019m too busy reading everyone\u2019s #ThanksODC blog posts<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How\u2019s the craic? 2018\/10\/14 Last Thursday was the Oracle Developer Community ODC Appreciation Day 2018 #ThanksODC I came across with the #ThanksODC idea Thursday afternoon and of course, I join with a blog post as well. Here And you can&hellip; <a href=\"http:\/\/www.igfasouza.com\/blog\/odc-appreciation-day-2018-tweet-analysis\/\" class=\"more-link\">Continue Reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[30],"tags":[],"class_list":["post-485","post","type-post","status-publish","format-standard","hentry","category-python"],"_links":{"self":[{"href":"http:\/\/www.igfasouza.com\/blog\/wp-json\/wp\/v2\/posts\/485","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.igfasouza.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.igfasouza.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.igfasouza.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.igfasouza.com\/blog\/wp-json\/wp\/v2\/comments?post=485"}],"version-history":[{"count":11,"href":"http:\/\/www.igfasouza.com\/blog\/wp-json\/wp\/v2\/posts\/485\/revisions"}],"predecessor-version":[{"id":919,"href":"http:\/\/www.igfasouza.com\/blog\/wp-json\/wp\/v2\/posts\/485\/revisions\/919"}],"wp:attachment":[{"href":"http:\/\/www.igfasouza.com\/blog\/wp-json\/wp\/v2\/media?parent=485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.igfasouza.com\/blog\/wp-json\/wp\/v2\/categories?post=485"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.igfasouza.com\/blog\/wp-json\/wp\/v2\/tags?post=485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}