最近用自家产品做了一次关于沃尔玛的自动调查,总体来看,沃尔玛这个品牌似乎蛮受欢迎的,正面评价为主,褒贬指数达到正48,是相当不错了。指责抱怨也有,主要针对一些负面事件(狐狸肉冒充牛肉、对伪劣产品乱发合格证上架等)。进一步挖掘(drill down)发现了令人惊奇的现象:好话大多是网民自发的评价,而挖掘出来的负面信息几乎一律出自国家新闻机构(CCTV等)的报道。社会媒体挖掘的本意是自动民调,了解客户对于品牌和产品的意见,正式新闻有机构或国家宣传的因素在,是应该加以区分的。可是目前,这种区分还做得不好,很多有影响的传统媒体的新闻被反复在社会媒体中转发传播,与民意混杂在一起。 Some further analysis and findings: 1. The existing data are not very large (400k mentions a year), but the results make sense with decent data quality 2. From geos stats, we know most data on Walmart come from China (dark color) instead of overseas sources 3. From domains stats, the data actually include data from Sina Weibo ( weibo.com ) and Tencent Weibo ( t.qq.com ) although the data flow from these two important Microblog sources is not stable at this point. Also the domains stats show that the major domains are all from China. I know that Walmart is a very influential brand in China and has many stores in cities of China. 4. The net sentiment 48% is fairly high, which is reflected in the emotions stats ( data quality very good ) : big green fonts emotional terms include 放心 (piece of mind) ,喜欢 (like) ,乐 (happy) ,支持 / 推 (support) ,很好 (very good), 不错 (not bad) ,成功 (success) etc. The negative emotional words (in small red font) are not many, including 差劲 (bad) ,抱怨 (complain) ,不喜欢 (dislike) ,垃圾 (garbage) ,很一般 (very so-so: meaning not as good as expected). 5. In the proscons word cloud, the likes include money-saving (省钱/便宜)and first-class service(服务一流); more interesting insights come from the dislikes, including (1) fake beef (using fox meat 狐狸肉事件); (2) recall (召回some product?); (3) cheating(欺诈); (4) scandal(丑闻) etc. 6. In order to drill down to see what negative incidents led to the above dislikes, the Walmart_con_sample shows some related sound bites which look like negative news on some incidents: 1 st sound bite reports CCTV news on Walmart’s fake alcohol and fake meat (using fox meat) incidents; 2 nd sound bite reports using fox meat to fake beef and donkey meat and using chicken to fake beef in the sold burgers at its Sam’s Club; the third sound bite reports three incidents of Walmart at different times and its apologies, including using cheap frozen meat to fake organic green food; using cheap fox meat to fake beef; and its lack of quality control in importing low quality products for sale, having issued 200 permits within 7 years for disqualified products to be on shelf. 7. Note that the above sound bites are selectively collected to show that our system can indeed capture detailed negative incidents of the brand in the media. When I drill down, there are quite some duplicates in our sound bites (one bad news gets re-posted everywhere); another thing is that the negative comments are not mainly from social media users, but from news (state-run news which get posted in social media too). 8. Unlike the overwhelming positive terms in emotions word cloud and the summary, the behavior word cloud shows more or bigger negative behavior terms than the positive terms. This is understandable because of the heavily reported incidents as shown above in the sample sound bites. Eye-catching negative behavior terms include “revealed”(被曝), “take to court”/”being sued”(告上法庭); “closed”(关闭); “have to take off shelf” (下架)etc. 9. From the above negative behavior terms, I drilled down to see more details in the sample sound bites below, which is similar to the sample discussed in 6. These two sound bites both come from negative news of Walmart, which originated from traditional news and got spread all over Internet. 中国新闻媒体对美国的跨国公司的负面报道跟民意没什么关系,倒往往由某种国际关系的大气候所致。当年为了打压谷歌,硬是给谷歌搜索按上了黄色监管不力的莫须有的大帽子,无视国内的搜索、视频和很多其他网站黄色泛滥到令人发指的露骨程度。欲加之罪,何患无辞。 不仅如此,最近还听说,由于中美相互指责对方利用网络偷窃情报,IT 业关系恶化,以至于谷歌和苹果等公司在中国遭到进一步打压,连做学问的信息利器 Google Scholar 都被封杀了。造孽啊,城门失火,殃及池鱼。 【置顶:立委科学网博客NLP博文一览(定期更新版)】
昨天晚和今天飓风''艾琳''来到纽黑文。早在上周时就收到几封邮件,告知全体师生飓风将至,请做好防护措施。 昨天上午趁飓风还未来,与先生一起跑到stop shop 买点应急的食物和饮料储备。结果超市人气比平常周六高3-4倍,最明显的是超市的桶装水早已抢购一空。购物回来后,室友说到沃尔玛买水没有买到,也已空空如也。 接下来,周六整晚和周日全部窝在家,躲避艾琳。果然,跟天气预报一样,艾琳如期而至。狂风暴雨大作。 今天早上一室友开车出去工作在马路上被人民警察拦回家。警察将所有高速路口封闭。 早上很快收到学校发的邮件,告知大家艾琳行踪和影响。 由此看来,美国人民应对自然灾害,行动和信息迅速/通畅,有效安定人心和尽量降低灾害造成的影响,做得很到位。 附上收到的几封邮件: 1. Hurricane Irene Dear Faculty and Staff, As Hurricane Irene approaches Connecticut, I write to update you on campus operations during the next two days. The Yale shuttles will stop running tonight at 9:00PM and will resume only when conditions are safe. Many events have been cancelled and galleries and museums will be closed. The full schedule of cancellations may be found at www.yale.edu/secretary/emergency . Also we will be posting other information and updates related to the hurricane at this same site. We will have on campus overnight and throughout the weekend cohorts of staff to ensure that all essential services are maintained. Yale is closely connected to the State’s Emergency Operations Center and we have been informed in the last hour, that tropical storm winds are predicted to reach our region by 11:00 PM tonight. Hurricane force winds, at least 70 mph, are expected to start at 7:00AM Sunday and last for at least three hours. Unless you providing essential services, we strongly urge you to remain indoors and not return to campus until you receive a follow up communication indicating that roads are clear and there is no danger from downed power lines or similar hazards. We hope that operations will be able to return to normal on Monday but will be monitoring conditions closely over the next 36 hours and will keep you updated. If there are mandatory delays in the start of the work day on Monday, you will receive a Yale Alert message around 6:00AM. I hope that you have made good preparations at home and that you will be safe and secure throughout the storm. Linda Lorimer 2. Campus Hurricane Update-Sunday 7 am I just wanted to signal that there were no serious problems last night on or around campus: Yale Facilities reported only scattered debris and no basement water issues more severe than “regular” storms. However with up to six hours or more of rain ahead, basements may become a problem. (If students on campus see any facilities issues, please call the Facilities Hotline at 432- 6888.) Scattered trees are down (outside Battell, 221 Whitney, and at the Divinity School) but none is blocking a road or passage. The 5:15 am report from the New Haven City Emergency Center indicated that in the City of New Haven 7 power lines are down; 13 flood prone streets are closed due to rain, (not due to the storm surge) and winds were at 45 mph at 3 am. The City expects more trees, limbs and power lines to start coming down in the next few hours. We in New Haven, so far, are getting less rain (about 3 inches) than Fairfield County and the region north into Litchfield. The heaviest rain is expected through 2 pm. Power outages vary in townships where Yale faculty and staff live: 46% of Guilford is without power and 65% of Madison. 6710 residents in Milford are without power, and 826 in Woodbridge. The most recent report indicates 2,086 New Haven households are without power. These numbers are expected to increase. Given these power outages, I know that increasing numbers of individuals will not have access to these e-mail messages and thus we plan to send a Yale Alert in late afternoon with a summary report of the day's developments. The 5:15 am report from the State of Connecticut Emergency Center is that the hurricane will make landfall in the Stamford area around 11 am and that “hurricane force wind gusts may arrive along the coast by 9 am.” The State also reports that “After the passage of Irene, a second period of strong winds is likely this afternoon and early evening, with wind gusts to 65 mph at times.” Linda Lorimer 3. Hurricane Update - 9:30 am Several faculty and students living off-campus who have lost power (and thus TV coverage) but have Blackberry or other email service have asked that we post more regular updates about the storm, since these messages are their primary source of information. The storm has been downgraded to a Tropical Storm (maximum winds of 70) and has made landfall in New York. In the last hour, JFK airport posted winds of 54 mph, Bridgeport had 47 mph, and Willimantic 51 mph. New Haven posted winds of 32 mph gusting to 41 mph, with the expectations of some increase in the next two hours. However even with the downgrade, the situation poses hazard with increased power lines and trees down in New Haven. For example a tree “hangs” on a power line next to the Yale Human Resources building at 221 Whitney Avenue and there is a live power line down in Parking Lot 51 (behind the Graduate Club and next to the Music School). Some of the tarps around construction sites are starting to blow loose and Facilities will be working with the contractors to secure them as soon as it is safe to do so. These conditions reinforce the importance of not walking around the campus. Power outages have increased dramatically in the last two hours: New Haven –13,400 residents without power Woodbridge – 2,800 West Haven –4,000 East Haven -4,800 Hamden – 5,600 Branford – 47% of the residences without power Guilford – 70% Madison – 100% with power Linda Lorimer 4. Goodnight Irene! And plans for tomorrow Those of us in New Haven seem to have been mighty lucky relative to those to the west of us (where Bridgeport airport had over 6 inches of rain compared to our 3 inches in the City) or the east of us (where Old Saybrook and other shoreline towns took a beating) or to the north (where Durham had serious flooding). We were lucky that Irene was downgraded to a tropical storm and moved so quickly out of New Haven. Overall, the University fared well. We have some downed trees on streets, courtyards and walkways as well as a few downed power lines. All Yale power plants are in full operation and we have power throughout campus, with only a few exceptions. There is no power at 142 and 149 Elm Street (with power likely to be restored there by the end of Monday); also power is out at facilities at the Yale Bowl. The City Emergency Operations Center is reporting minor property damage throughout the City, well over 1,000 trees down (including trees in parks) and about 17,000 residents without power. At this time, the City is asking residents to stay home, so that crews are able to clean up the fallen trees and other debris. Even though the storm has passed, a few very large trees have fallen in just the last hour and the saturated ground and wind gusts may contribute to others still tumbling, so there is a need to take continued care. Yale Facilities has crews out to clean up trees and branches, and the City also has crews out, with a first priority towards trees that have fallen on power lines and trees blocking streets. Yale offices will be open for business as usual in the morning . We recognize there are some staff who may not be able to get to work because of conditions where they live. Those staff members who are not providing essential services may elect to take paid time off to cover their absence after conferral with their supervisor, and we are encouraging supervisors to grant this release whenever feasible. The Yale Shuttle will resume operations tomorrow at 5 am. Dining Services will resume operations tomorrow as planned with breakfast at Commons. Thank you to all who did so much good preparation in advance of the storm, and especially to those who staffed our essential services last night and today! Linda Lorimer