EXAM 3 INFORMATION:
This is very important. Do not confuse your Exam 3 date and time. Know what section you are in. There is no make up!
Exam 3 Date & Time:
Section 4: May 8 (Wed), 10:30 – 11:30am
Here is the extra credit question. Due 4/29/2019!
In our class today, we are hosting Dr. Atay Kizilaslan as our guest speaker. His talk will start at 1pm in Alter 607. His short bio is below. Please come to class because there will be an extra-credit assignment […]
Here are the files you will need:
Driver (software) if Tableau gives error.
Here is the guideline: Sentiment Analysis Using Excel
Here is the file for analysis: Sentiment Analysis Tools
Sezgin Ayabakan wrote a new post, ICE 12.1 Manually Determining the Sentiment of Text Data, on the site Data Science – Spring 2019 – Section 4 and 5 4 months, 2 weeks ago
Here is the ICE details: ICE 12.1 Manually Determining the Sentiment of Text Data.docx
Negative – “I’m not happy. My Cherry Coke Zero now says Cherry Coke Zero Sugar on it. I bet it will taste like shit like Coke Zero Sugar. If it does, Coke is history with me.” – When it says I am not happy, it shows it is negative
Positive- “Coca Cola makes me happy, I drank some diet today” – When it says it makes me happy and that they drink it, shows it is positive
a) Original tweet: Heart to heart in the cutest dresses and softest sets: precious moments of fun and play. #HMKids #HMConscious http://hm.info/1chx3
b) Comment: Que hermosa ropa! Beautiful clothes!!!!!!!🥰
a) Orginial tweet: Don’t just dream of a place on the podium. Dream of a place in history. #justdoit
b) Comment: I dont know about that Nike, ever since this kid mark parker has been CEO he’s been pretty schemey, starting up all these programs for minorities to rally up people to buy shoes, if Parker really cared he wouldn’t have in kids in sweatshops in Vietnam making them for $2 a piece
Positive: “When is the cereal coming back? I’ll buy ten.” This is positive because a user is asking when another product is coming back, showing that they like the product.
Negative: “Disappointed with the lack of frosting” and also puts a picture of a Poptart. This is clearly negative due to the unsatisfied customer, but the twitter account responds with how they can get a refund.
– Matt Bergeron, Isaac Parlow, Paul Wendt
Positive: “It is delicious!!! My barista makes it perfectly!!! I do always ask for extra ice, which makes it so cold and extra yum”
This statement indicates a positive sentiment given the positive adjectives such as “delicious” and “yum,” as well as the compliment to the Starbucks barista’s skills. This customer seems pleased.
Negative: “I went to order this today and they said they were out of the cloud foam… Boo! 0/10….”
This statement indicates a negative sentiment given the use of “Boo” towards Starbucks and rating the experience “0/10.” It does not seem like this customer is pleased.
Nike tweeted “Welcome to the family, @Naomi_Osaka_ .” (Naomi is a professional tennis player that just signed a deal with Nike).
One of the top positive replies said “Good news. Welcome to the family”
A top negative reply said “I’m sure all the sweatshop workers are delighted with this news” Even though the sentimental word in this tweet, “delighted” is positive world, in this context, it is clear that the user is being sarcastic.
Brandon Tejada and Crystal Touch
Class 2:00-2:50 P.M.
Positive Tim MacMahonVerified account @espn_macmahonMore
Dirk is wearing customized Nikes tonight. LOYALTY across the right toes, LEGACY across the left toes. 41.21.1 on the heels.
Tim MacMahon is giving a positive feed about Nike making customize Nike shoes for Dirk.
Negative- Michael Avenatti- The documents I dropped clearly establish @Nike paid illegal bribes to players to go to certain colleges. How can colleges like @DukeU continue to do business with Nike? Do they routinely do business with companies that pay illegal bribes? This is the example they set?
This is a negative comment because Michael Aventatti is accusing Nike for doing Illegal business.
Negative- “WE LOVE WOMAN. PURCHASE OUR UNHEALTHY CARBONATED SUGAR WATER. THIS IS NOT A COLD HEARTLESS ADVERTISEMENT.” In response to an international women’s day tweet. The sarcasm is palpable as is the frustration with what they perceive as Coke using International Women’s Day for monetary gain.
Poistive- “I love that you’re featuring art from talented female artists today! Speaking of honoring talented ladies in the workforce, @CocaCola, what does your family leave policy look like?” Response to the same tweet. This tweet recognizes the power of a major, powerful company recognizing a holiday meant to honor women and uses the opportunity to start an important and constructive conversation*.
*I acknowledge that Twitter is hardly ever a platform for constructive conversation and a bad place for important conversations
Boeing Negative Tweet: “Truth is you were relentlessly focussed on profits & market share, not safety. Safety was something considered worth cutting corners on, to sell as an optional add-on. Regulation of corporations & capitalism doesn’t stifle innovation; it saves lives. Shame on you all”
Tjis is negative because the person is extremely un happy with the way they handled business.
Boeing Positive Tweet: On this #InternationalWomensDay, we celebrate all our female employees who make us better and stronger. #BalanceForBetter
This tweet shows Boeing’s appreciation for the female employees.
Here is the link to the assignment details.
You can access it under the Assignments menu tab above too.
Due Apr 24 at 11:59pm.
Here is the guideline: ICE 11.2 Working with Pivot Tables in Tableau
Here is the data: NCAA 2013-2014 Player Stats
Here is the guideline: ICE 11.1 Creating a Database
Guideline is here: ICE 9.2 Creating Interactive Dashboards
Data file for Tableau: Pew Story Data (Jan – May 2012)
On Canvas submit your Tableau file along with answers to the four questions given at the […]
Here is the exam study guide: Exam 2 Study Guide.docx
Exam Date: March 29, 2019 (Friday)
KNOW YOUR SECTION BEFORE YOU PROCEED!
Section 4: From 1:00 to 1:50pm
Section 5: From 2:00 to 2:50pm
Please use this link to vote for your desired time of Exam 2 review session next week.
Please login to your Gmail using your Temple account and vote!
Sean then will pick the time with the most votes.
Here is the guideline: ICE 9.1 Connecting Data Sets.docx
First dataset: 2012 Presidential Election Results by District.xlsx
Second dataset: Portrait 113th Congress.xlsx
This is NOT a graded ICE.
Our ITAs will be holding extra office hours next week for Assignment 2. Please have your questions ready when you visit them. This means you have to work on the assignment prior to your visit! You can visit Sean […]
Details on Assignment 3 are revealed. Please follow the link or click on the Assignments tab on top and select Assignment 3.
Here is the guideline you will need: ICE 8.2 word doc
Here is the data file you will use: OnTime Airline Stats excel file
This is a graded ICE–will be counted towards your attendance.
Here is the guideline: ICE 8.1
This is not graded.
Here is the Assignment 2 details.
Here is your guideline: Finding Bad Data in Excel.docx
Here is the dataset: Vandelay Orders by Zipcode.xlsx
This is a graded ICE
Here is the guideline: How Data Gets Dirty.docx
Here is the supporting documents: Supporting Documents – How Data Gets Dirty.pdf
- Load More