Social media and its data?are both a challenge and an opportunity for managers. Please follow the instruction in?Text Social Data Analytics?to use Orange software for mining text data from social media. You need to submit the completed Orange file an
Social media and its data are both a challenge and an opportunity for managers. Please follow the instruction in Text Social Data Analytics to use Orange software for mining text data from social media. You need to submit the completed Orange file and the sentiment analysis Excel file as a zipped file attachment.
If Twitter did not approve your application for a developer account, please feel free to use any of the 4 files with tweets data posted in the zipped folder above titled "Tweets Data For Project 7". Instead of using the Twitter widget, use the Corpus widget to upload the excel file of your choice (see video 2) and follow the steps shown in the video.
Project Week 6 Text Social Data Analytics.pdf
Lecture Notes INFS 6340 Week 6 – Text Social Data Analytics
Dr. Murad Moqbel https://media.readthedocs.org/pdf/orange3-text/latest/orange3-text.pdf 1
Text Social Data Analytics 1. Install Text Mining Add-on: Open Orange software => go to Options tab => Add-ons => Text => restart orange for the add-on to appear. 2. Get Twitter API Key: Drag and drop Twitter to canvas => double click on Twitter icon => click on Twitter API Key – you will need to log in into
your twitter account and get the API key (https://youtu.be/y4Nsgy3YTv8) from there using the following URL: https://apps.twitter.com/
3. 4. Query Word: enter query word of your choice or any trending topic on Twitter via www.trendsmap.com like Tornado 😊 => limit your
tweets to 100 so that they can be extracted quickly => click search.
5. View tweets/content: To view your tweet content, grab and drop DataTable widget from the Data section => connect the Twitter widget with the Data Table widget => double click the Data Table to view content.
6. Pre-process: Drag and drop Pre-Process Text widget into the canvas => connect it to the Twitter widget => double click the Preprocess Text Widget and you will see: (1) Transformation section which transforms all words into lowercase. (2) Tokenization which converts text into individual words and removes the punctuations. (3) Filter section allows you to specify your own stop words (remove unwanted
words such as https…).
7. Customized Stop-words: open a notepad and list your stop-words one word in each row. Save the file into your computer and upload int the stop-word section as shown below.
Lecture Notes MIT 5602 Week 7 – Text Social Data Analytics
Dr. Murad Moqbel 2
8. Word Cloud: to view word cloud, in which the size of the words represents the frequency they were mentioned drag and drop Word Cloud widget into the canvas and connect it to the Pre-process Text widget => double click Word Cloud widget to view
9. Sentiment Analysis: drag and drop Sentiment Analysis widget into the canvas => connect it to Pre-process Text widget => now drag and drop Data Table widget and connect it to Pre-process Text widget
10. View sentiment analysis results: Double-click the Data Table widget and look at the Pos, Neg, and Neutral, compound columns which represent the sentiment level in each tweet.
Exercise: Choose a word/topic of your own choice and conduct a sentiment analysis similar to the one above. Save your Orange file and post it into Week 7 Dropbox.
Tweets Data.zip
Halloween Tweets.csv
| Author | Content | Date | Language | Location | Number of Likes | Number of Retweets | In Reply To | Author Name | Author Description | Author Statuses Count | Author Favourites Count | Author Friends Count | Author Followers Count | Author Listed Count | Author Verified | Longitude | Latitude |
| discrete | string | time | discrete | discrete | continuous | continuous | discrete | discrete | string | continuous | continuous | continuous | continuous | continuous | discrete | continuous | continuous |
| class | meta title=True | meta | meta | meta | meta | meta | meta | meta | meta | meta | meta | meta | meta | meta | meta | meta | meta |
| @DogMomAF_ | I cannot wait for the new Halloween movie ���🔪🔪🔪 | 2018-10-09 00:09:57 | en | US | 0.0 | 0.0 | Jasminnn(: | 🙃�💛 | 3754.0 | 3654.0 | 165.0 | 125.0 | 0.0 | False | |||
| @MexiBassMonkey | @gamesEnlisted Why would you NOT use Pumpkinhead if you're going as Sora for HALLOWEEN. Honestly why don't they try to market his HT get-up? | 2018-10-09 00:09:57 | en | 0.0 | 0.0 | @gamesEnlisted | MBM | Look at this nerd. What's his deal? | 30644.0 | 21530.0 | 587.0 | 1999.0 | 15.0 | False | |||
| @AZAYUKl | i wanna go to a nail artist and have them make sardines yuki nails,,,,, OR HALLOWEEN AZAYUKI NAILS yes bitch | 2018-10-09 00:09:57 | en | 0.0 | 0.0 | sof @ AZAYUKI CG BITHCHC!!!! | sof/sofi / 20 / she/her || just a dumb lesbian who's too emotional sometimes || � @infernosquaring � | 9023.0 | 1758.0 | 148.0 | 43.0 | 1.0 | False | ||||
| @radmermaid_ | When your actually considering being lady Gaga for Halloween and realize she sells the Joanne hat but also realize… https://t.co/uk6V3qTOae | 2018-10-09 00:09:57 | en | 0.0 | 0.0 | Emily Rose | ��✨ | 13167.0 | 8853.0 | 483.0 | 305.0 | 1.0 | False | ||||
| @ShebaNoMore | Puta a los cabros del liceo se les ocurrió hacer una fiesta de disfraces pa halloween. | 2018-10-09 00:09:56 | es | 0.0 | 0.0 | Choclo con mayo | Zurdo (de mano), del Colo, guitarrero. Le hablo y le traduzco en inglés. Grammar nazi y recaà en mi adicción a la Coca…Cola. WINTER IS COMING. | 347228.0 | 2437.0 | 2747.0 | 3989.0 | 20.0 | False | ||||
| @hinfantttttt | me as ramona flowers for halloween: a concept | 2018-10-09 00:09:55 | en | 0.0 | 0.0 | (-: | 19444.0 | 12746.0 | 250.0 | 384.0 | 3.0 | False | |||||
| @therock0829 | I liked a @YouTube video https://t.co/zCwsX0vdf8 8th Day of Halloween: Mandy REVIEW | 2018-10-09 00:09:55 | en | 0.0 | 0.0 | The Horror Miser | Know as The Horror Miser Monty G on YouTube!! Check out my channel!! | 6290.0 | 12086.0 | 997.0 | 1111.0 | 10.0 | False | ||||
| @shahlock | Monster Math (Part 2) The Blob is a clustering algorithm gone wrong. A ghost's shape follows a paranormal distribu… https://t.co/AH2uJPEOoI | 2018-10-09 00:09:53 | en | 0.0 | 0.0 | @shahlock | M Shah | 26627.0 | 1009.0 | 504.0 | 1426.0 | 129.0 | False | ||||
| @Popt2014 | Amanda Dorzweiler Eschliman Congratulations!!! You are the winner of the HALLOWEEN UNICORN KETTLE CAKE! | 2018-10-09 00:09:53 | en | 0.0 | 0.0 | Popt! Popcorn | 235.0 | 0.0 | 0.0 | 3.0 | 0.0 | False | |||||
| @jba_music | Me ha gustado un vÃdeo de @YouTube (https://t.co/rSpwt95Fgq – GLAM DE MUERTE! Halloween 2018! Laura Sanchez). | 2018-10-09 00:09:52 | es | 0.0 | 0.0 | JBA Music | 24. Músico, Productor y Cantante de Legendarios | 6816.0 | 139.0 | 949.0 | 984.0 | 4.0 | False | ||||
| @GinaBonini | I’ll never understand ppl that drop a fortune on a costume for ECU Halloween weekend | 2018-10-09 00:09:51 | en | 0.0 | 0.0 | Gina | ECU ☠� | KΔ 💚 | Molecular Biology 🔬 | 552.0 | 497.0 | 235.0 | 150.0 | 1.0 | False | ||||
| @Haunt_Feed | Perfectly Spooktacular #Halloween Desserts – Food Network https://t.co/lnjjzZf9vT | 2018-10-09 00:09:51 | en | 0.0 | 0.0 | HauntFeed | News, tips and more for and about professional #haunters, #homehaunters, #Halloween & #themeparks. Also other stuff. | 7927.0 | 3622.0 | 2331.0 | 2179.0 | 130.0 | False | ||||
| @jewbearlaflare | The Bub is going as Groot this year for Halloween. https://t.co/gzTL11LsWD | 2018-10-09 00:09:49 | en | 0.0 | 0.0 | DEATH OF A NOBODY 10/26 | Not Jewish. Visual Artist. 20 years old. email: [email protected] | 8839.0 | 1017.0 | 188.0 | 137.0 | 5.0 | False | ||||
| @bearwithbeardmx | How the Halloween zombies can help close your revenue gap https://t.co/NhV3XyG3qF https://t.co/jrihUiKToJ | 2018-10-09 00:09:48 | en | 0.0 | 0.0 | Pato | Hay preguntas que es mejor no hacerlas. Si llegaste por accidente: bienvenido. Si te gusto mi tweet, no te acostumbres… esto va a empeorar. | 10809.0 | 18.0 | 802.0 | 403.0 | 8.0 | False | ||||
| @Ms_Bananaa | @JuyenSebulba is it true your coming to Laredo for Halloween weekend?? 😱😱 | 2018-10-09 00:09:47 | en | 0.0 | 0.0 | @JuyenSebulba | f e r r🧛��♀� | SC:anaferrayala | 23394.0 | 18076.0 | 889.0 | 586.0 | 4.0 | False | |||
| @GabrielRosendo9 | Dia 27 temos a queridinha da ilha com o tema Halloween + festa neon, brota que vai dar bom #HalloweenDaArmagedom #FestaNeon | 2018-10-09 00:09:47 | pt | 0.0 | 0.0 | Rosendo ⚡ | / Só progresso / @Flamengo ⚽ / @FCBarcelona ⚽ | 10102.0 | 5159.0 | 391.0 | 631.0 | 0.0 | False | ||||
| @StyleBigPlay | Gostei de um vÃdeo @YouTube https://t.co/O2unMoj1mC HALLOWEEN GIVEAWAY ENTRY VIDEO🧟â€�♂ï¸�🧟â€�♀ï¸� GOOD LUCK ✅ | 2018-10-09 00:09:46 | en | 0.0 | 0.0 | StyleBig GamePlay | 8855.0 | 34.0 | 35.0 | 9.0 | 0.0 | False | |||||
| @nanamimi_4649 | #インカレ 秋å¦æœŸ #æ–°æ“ #大å¦ç”Ÿ 10/10æ°´12金17æ°´ 20時～ 10/14æ—¥ 17時～ 👻HALLOWEEN🎃パーティー🎉 10/19金24æ°´25木27土29月 20時～ 10/21æ—¥ 17時～ ç”·å�3000女å�1… https://t.co/PcxGFE1Oxe | 2018-10-09 00:09:46 | ja | 0.0 | 0.0 | ã�ªã�ªã�¿ | ディズニー好ã��ï¼�大å¦ç”Ÿ 神奈å·�→æ�±äº¬ 気軽ã�«ãƒ•ã‚©ãƒãƒ¼ã�—ã�¦ä¸‹ã�•ã�„ã�😊よã‚�ã�—ã��ï¼�ï¼� 優ã�—ã��ã�—ã�¦ã��れる人好ã��ã�«ã�ªã�£ã�¡ã‚ƒã�†ã�‹ã‚‚ï¼� 😆Merci所属 新宿 渋谷 横浜ã�«è‰¯ã��è¡Œã��よï¼�😉å�‹é�”登録よã‚�ã�—ã��ã�Šé¡˜ã�„ã�—ã�¾ã�™ðŸ˜Œ https://t.co/7AzourQEyo | 110.0 | 56.0 | 98.0 | 38.0 | 0.0 | False | ||||
| @RjJhonnatan | Me gustó un video de @YouTube https://t.co/N6dyAs2yst OFFICIAL HALLOWEEN GIVEAWAY ENTRY VIDEO🧟�♂�🧟�♀� GOOD LUCK ✅ | 2018-10-09 00:09:45 | en | 0.0 | 0.0 | El RJ Oficial | 1207.0 | 11.0 | 92.0 | 33.0 | 2.0 | False | |||||
| @BlanikIan | I really don’t understand how 4 major food stores actually don’t have Halloween cookies right now, fml bro | 2018-10-09 00:09:44 | en | 0.0 | 0.0 | ianblanik | 22.0 | 15.0 | 45.0 | 26.0 | 0.0 | False | |||||
| @elibisme | My Halloween flick pick #2 for the night is another M. Night Shyamalan movie: The Sixth Sense… "I see dead people… https://t.co/04ocT87pFW | 2018-10-09 00:09:43 | en | 0.0 | 0.0 | Elizabeth Belt | I am a middle-aged observer of life. I love to photograph nature, read voraciously, and write. | 5030.0 | 15440.0 | 576.0 | 664.0 | 1.0 | False | ||||
| @aeroeng11 | @Altsurrealist @ProperOpinion @playerhatersllc @PontiacGunfire I'm planning on handing out Olive Garden for Hallowe… https://t.co/xHO4Xj7ihO | 2018-10-09 00:09:41 | en | 0.0 | 0.0 | @Altsurrealist | aeroeng11 | Engineer, Reader of Books, Like Constructive Convo/Debate, Like Cooking, Space Is Cool, Dogs & Cats, Politically Independent | 2938.0 | 4852.0 | 238.0 | 57.0 | 0.0 | False | |||
| @13Mortalkombat | Halloween 4: The Return of Michael Myers (1988) – The Rooftop Chase https://t.co/CSQDRc6uzJ vÃa @YouTube | 2018-10-09 00:09:40 | en | 0.0 | 0.0 | SARA | 36879.0 | 808.0 | 2174.0 | 382.0 | 8.0 | False | |||||
| @bellareynolds03 | Imma need a nice Halloween party to go to this year js | 2018-10-09 00:09:40 | en | 0.0 | 0.0 | bella | 171.0 | 1766.0 | 145.0 | 173.0 | 0.0 | False | |||||
| @breezy1297 | My Little is listening to Christmas music, and as much as I love Christmas, even I don’t do that until after Halloween | 2018-10-09 00:09:40 | en | 0.0 | 0.0 | Bri â�ï¸�💕ðŸ��ðŸ��🎵ðŸ��🌸 | ΔΖ ðŸ�¢ðŸ’• | 14167.0 | 2816.0 | 525.0 | 274.0 | 2.0 | False | ||||
| @MommybitesNY | Don't Miss Out! Mommy and Me Halloween Parties 🎃👻 – https://t.co/qaV4FGFhGH | 2018-10-09 00:09:39 | en | 0.0 | 0.0 | Mommybites New York | Mommybites (formerly known as babybites) is the go-to community for free online parenting classes & parenting resources,support and education. | 4376.0 | 24.0 | 1307.0 | 5522.0 | 85.0 | False | ||||
| @mayelapenaa | I wanna be Tiffany for Halloween now lmao | 2018-10-09 00:09:39 | en | 0.0 | 0.0 | may | 22136.0 | 6870.0 | 368.0 | 496.0 | 0.0 | False | |||||
| @Hellshawn | Anyone that needs to know what I'll explain my name emojis… A hundred percent of American lucky dick boo it's Halloween | 2018-10-09 00:09:39 | en | 0.0 | 0.0 | SenseiShawn 💯🇺🇸ðŸ�€ðŸ�†ðŸŽƒ | Intellectual purveyor of pop culture. Know the secret to happiness. Uncommonly lucky. Multiple @Midnight viewer. Inventor of unique hashtags. | 3309.0 | 7668.0 | 2540.0 | 1107.0 | 20.0 | False | ||||
| @blakeman_al | Halloween is fun, but I’ve already watched #HocusPocus four times, so now I’m ready for Christmas | 2018-10-09 00:09:39 | en | 0.0 | 0.0 | Al Blakeman | 9.0 | 0.0 | 9.0 | 6.0 | 0.0 | False | |||||
| @mafs1393 | Quiero ir a halloween solo para cantar a todo pulmon puntos suspensivos de piso 21 | 2018-10-09 00:09:38 | es | 0.0 | 0.0 | Mafe Amador | Diseño Publi • Admi | 7447.0 | 174.0 | 185.0 | 97.0 | 0.0 | False | ||||
| @PrincesssDayDay | i’m going to be working daycare on halloween, i’m excited lol � | 2018-10-09 00:09:36 | en | 0.0 | 0.0 | dej🎃 | zayden 💙 mark 9:23 �� | 14257.0 | 8199.0 | 603.0 | 593.0 | 0.0 | False | ||||
| @karascx | @Rythayze hes a fraud, beats up little kids on halloween to steal their candy, and he doesnt say thank you after y… https://t.co/HGkuraB7QO | 2018-10-09 00:09:35 | en | 0.0 | 0.0 | @Rythayze | Jake ★彡 | wholesome boy & 11 year old twitter sensation | 7512.0 | 7805.0 | 402.0 | 9672.0 | 5.0 | False | |||
| @TheStonedNerd | Time to test out the Halloween costume. Let's get wasted and eat chicken fingers #TrailerParkBoys #SmokesLetsGo… https://t.co/t3ZjmrTc4C | 2018-10-09 00:09:34 | en | 0.0 | 0.0 | Mordecai The Saiyan | Aries/Taurus Artist | 7332.0 | 733.0 | 233.0 | 173.0 | 5.0 | False | ||||
| @dcabrona_ | Halloween is just around the corner👵�🎃 https://t.co/1ZnOf4KL6q | 2018-10-09 00:09:31 | en | US | 0.0 | 0.0 | destiny | count ya blessings | 20618.0 | 13075.0 | 301.0 | 689.0 | 0.0 | False | |||
| @URNotAloneFilm | If you missed the You Are Not Alone theatrical screenings in 2016, here's your chance to see the Pre-Show entertain… https://t.co/kVpbaaoW38 | 2018-10-09 00:09:30 | en | 0.0 | 0.0 | You Are Not Alone | Official Twitter of YOU ARE NOT ALONE A First-Person Thriller – https://t.co/87kPZCAO5l Available 6.23.16 on DVD and VOD | 759.0 | 619.0 | 2033.0 | 2090.0 | 28.0 | False | ||||
| @NatalieTegler | Does anyone have a kid I can borrow for Halloween so I can go trick or treating | 2018-10-09 00:09:30 | en | 0.0 | 0.0 | Natt | sc: natstyles66 | 4215.0 | 5653.0 | 170.0 | 297.0 | 0.0 | False | ||||
| @DjMattmattic | Halloween party going to be insane the 26th ! Get your tickets early people ! Hit me up for more details ! @ Fiesta… https://t.co/htbaelVUWk | 2018-10-09 00:09:30 | en | 0.0 | 0.0 | MattMattic | Just turned Super Sayian. | 14731.0 | 104.0 | 303.0 | 358.0 | 1.0 | False | ||||
| @StantonWidow151 | @ECMcLaughlin I was ordering Titans Halloween costume. | 2018-10-09 00:09:30 | en | 0.0 | 0.0 | @ECMcLaughlin | Jean Stanton | Independent thinker, what you see is what you get. I want to Spread Humanity Like a Disease. I have no time or energy to waste on ugly souls. | 2272.0 | 4895.0 | 54.0 | 51.0 | 0.0 | False | |||
| @TagYour_Friend | Tag your unfun friend, you know the one, they “outgrew� Halloween at 12 and are just unfun people ever since. #meme… https://t.co/krf1JpgqSa | 2018-10-09 00:09:29 | en | 0.0 | 0.0 | Tag Your Friend | Tag Your Friend is a cartoonish comedy web series about friendship and surviving each other’s faults. Real Friends. Really Exaggerated. By Fantasy Forge Films. | 142.0 | 10.0 | 5.0 | 13.0 | 0.0 | False | ||||
| @ShonnaU | #Halloween Mr. Buttinski 😂 https://t.co/zeEPnUh9Fk | 2018-10-09 00:09:29 | en | 0.0 | 0.0 | ~Red~ 🇺🇸⚜��� | Conservative �� 💯Trump #MAGA #NoForeignOil~NRA #ProLife God bless our Military/Vets followed by Wayne Dupree & James Rosen Blocked by Cher ⚜�🇺🇸#KAG #MAGA | 29994.0 | 22180.0 | 5988.0 | 5741.0 | 79.0 | False | ||||
| @djtrexbob | This is Halloween Theme! | Nerds Plays | The Building Game #1: https://t.co/ubTmjoCcjB via @YouTube | 2018-10-09 00:09:28 | en | 0.0 | 0.0 | Trexbob | I Play TONS of games like ,Zoo tycoon 2, Gmod, left 4 dead 2, minecraft and more 😀 | 357.0 | 2.0 | 58.0 | 20.0 | 0.0 | False | ||||
| @kkarlymolina | i was putting away halloween cookies and my sister was being annoying so i hit her in the head with the bag and it fUCKIN BROKE 😂😂😂 | 2018-10-09 00:09:27 | en | 0.0 | 0.0 | karly | damn bitch we out here tryna save the environment n shit | 36203.0 | 98967.0 | 1664.0 | 1798.0 | 6.0 | False | ||||
| @metalrulestv | Vintage CAF COUNT DRACULA HALLOWEEN PLUSH STUFFED SCARY HORROR ANIMAL DOLL https://t.co/ggAzbdE2p5 via @eBay | 2018-10-09 00:09:27 | en | US | 0.0 | 0.0 | Jeff Rappaport | Official account Metal Rules! TV & Ebay Powerseller! Follow for follow. Retweet for retweet! #metalrulestv #ebay #retweet #shopsmall #supporteachother | 109353.0 | 68.0 | 4845.0 | 4519.0 | 268.0 | False | |||
| @TayaRikki | “It’s a kayak, not a body� claims the man dragging a large object in a large bag out the door in @Walmart. “And thi… https://t.co/F9rhYBXEfS | 2018-10-09 00:09:26 | en | 0.0 | 0.0 | Taya DeRycke | Stupid humor from the brain of a wannabe actress/somehow actual business owner. | 6.0 | 2.0 | 38.0 | 5.0 | 0.0 | False | ||||
| @iRoNGiRL_YT | Me ha gustado un vÃdeo de @YouTube (https://t.co/elweQDvLvR – HA LLEGADO HALLOWEEN A LOS ZOMBIS 🎃🎃🎃). | 2018-10-09 00:09:26 | es | 0.0 | 0.0 | Iron Girl [+0.6k] | Lvl 21 | Estudio GS de Diseño Gráfico | PS4 (Cristina_Chuck) y PC (Iron Girl) | Subo vÃdeos a YouTube | «SIC • PARVIS • MAGNA» @Baraka_esports | 4721.0 | 1318.0 | 183.0 | 345.0 | 3.0 | False | ||||
| @itskattalv | I have 2 Halloween costumes so far. I’m ready 🎃� | 2018-10-09 00:09:24 | en | 0.0 | 0.0 | Katherin L. Alvarado | 13633.0 | 9311.0 | 427.0 | 571.0 | 5.0 | False | |||||
| @djtheutii | @HyenaAgenda hey, got your Halloween card 🙂 thanks https://t.co/SLcJvGk9tG | 2018-10-09 00:09:23 | en | 0.0 | 0.0 | @HyenaAgenda | Djt'Heutii | 1121.0 | 36961.0 | 254.0 | 70.0 | 0.0 | False | ||||
| @DesignsByRAJA | Bat Hero Felt Dress Up Ma
Collepals.com Plagiarism Free Papers Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers. Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS Why Hire Collepals.com writers to do your paper? Quality- We are experienced and have access to ample research materials. We write plagiarism Free Content Confidential- We never share or sell your personal information to third parties. Support-Chat with us today! We are always waiting to answer all your questions.  All Rights Reserved Terms and Conditions |