Showing posts with label wordcloud. Show all posts
Showing posts with label wordcloud. Show all posts

Friday, March 28, 2014

Word clouds of Putin Address

Yet another turn of events took place today with Putin phoning Obama to seek diplomatic solution to the international standoff over Ukraine. Neither side expressed much excitement so far, but dialogue during crisis is better than couple of monologues.

Meanwhile what drove Putin to reach out to Obama? Maybe he feels it's the time he holds all the cards? While easily guessing his cards are Crimea, military buildup on the border, and continuing instability in Ukraine, what would be the bargaining about?

I will try using simple text analysis give another perspective on Putin's campaign in Crimea. Russian president doesn't give speeches or  press-conferences often but always exceptionally prepared. There were 3 relevant appearances by Putin in last couple of months before and during Ukrainian crisis (all are official translations from his site):

  1. News conference following EU Summit on January 24th.
  2. Press-conference with media representatives to answer questions with regard to the situation in Ukraine on March 4th. 
  3. Address by President to State Duma on Crimea on March 18th.
So what is the Address on Crimea about:
Not surprisingly it refers to Ukraine, Crimea and Russia the most. These words could be excluded without loosing any insight: 
Now, cloud becomes all about will and people (supposedly applied to RussianUkrainianCrimean). Has anything changed since EU Summit when Putin made his address? One way to answer this is to place both transcripts into the text corpus and run TF-IDF statistic on the terms. This time our cloud is based on the TF-IDF scores (minimal frequency of term per document is 3) for the address and will reflect both frequency in the Address and importance compared to EU Summit (that is all other documents in the corpus):
The words above stand out when compared to EU Summit text. It's no surprise that Sevastopol didn't sound in January, but nor were Kosovo, residents, and law. To make it more convincing let's throw into the mix Putin's press conference on March 4th when he broke silence on Crimea. Now the text corpus includes 3 documents and this is the cloud of the highest TF-IDF scores for the Address document:

Again there are Sevastopol and city, but also importantly Russians, NATO, millions, ethnic, reality, Tatars, borders, and USSR are the words that stand out compared to what Putin said before. It is a clearly a mix of his concerns, goals, and, well, realities, but, it could be also about symbol of Russian glory - Sevastopol - at least to some degree? After checking his speech it is clear that he referred to Sevastopol each time Crimea, but there was one place where this city mentioned alone: 
"I simply cannot imagine that we would travel to Sevastopol to visit NATO sailors."
Would Putin roll back and yield to international condemnation? Very unlikely, but I cannot imagine at all he will give Sevastopol back.

Since Sevastopol was used along with Crimea which was removed from analysis the cloud below is version of last with Sevastopol excluded. Word clouds are always open to interpretation so I leave it here for the reader to make their own conclusions:

Wednesday, February 26, 2014

Deconstructing The French Laundry Wine List, Part II

Having more refined data than last time I focus on prices in this post.

Price Word Clouds 

Word clouds below use prices instead of frequency: size corresponds to average price of bottles of wine each term belongs to (hence, even if expression occurs only once but in very expensive wine it appears on top):


Let's remember that Domaine de la Romanée-Conti is less expensive than Château Petrus. Next, let's zoom in by splitting this into two clouds: for red and for white wines (some names will disappear from both because they don't belong to neither reds nor whites, e.g. Scion which belongs to fortified wines).

Red wine price cloud (1287 bottles total):


Now both Domaine de la Romanée-Conti and Château Petrus are first among equals. The hint why the former improved lies in the white wine price cloud (539 bottles total):
The Burgundian estate is present here but not so for the one from Bordeaux. It'll be shown momentarily that the prices of whites are consistently below reds so averages tend lower when computed across the board. This effect is not present for Château Petrus as it doesn't feature whites at all.

Last cloud for today is whites price cloud without outlier Domaine de la Romanée-Conti. Removing it makes viewing prestigious whites on The French Laundry list almost as pleasant as drinking (just kidding):
    

Gender Wine Inequality between Reds and Whites

Are whites cheaper than reds? Using population pyramid type of histogram we can compare them by price (think of white as female, red as male (or vice versa if you wish), and wine price as salary). And just like in population pyramid we have plots for each country (France, Italy, and US):

US makes the best case for inequality while France fares best for equality (longer history of wine democracy?). All 3 show consistent trends though: red prices are right skewed with fat tails, while white prices are more symmetric with lower centers of distribution. Of course, all results are subject to The French Laundry sommelier's bias in wine selection (and possibly the reason that Spain was heavily under-represented in whites so it didn't make this chart).

Compare median prices (dashed horizontal lines) across 3 countries: contrary to popular belief American wines are better value than European counterparts (assuming that all wines on the The French Laundry list are outstanding). American wines really represent the "budget" section of the list (prices under $200) while Europeans peak above $200. I will follow up on that in the future posts.

Sunday, February 23, 2014

The French Laundry Wine List Deconstructed

Not that I surprise you but my little exercise in deconstructing The French Laundry wine list  may help with planning your trip there. This word cloud is from the wine list offered by the restaurant (available here):
It includes expressions parsed from the wine names. Terms that occur less than 5 times were excluded.

Wine names usually do not include varietal, country, appellation, and other standard designations. But some exceptions do occur, so below is the same cloud with top exceptions removed:
Apparently, Domain de la Romanee-Conti is a big winner for Head Sommelier Dennis Kelly. This estate in Burgundy produces some of the world's most expensive bottles of wine.

What vintages are in favor at The French Laundry today?
I did hear that 2010 was a great vintage in California. Is it really American wines that contribute to 2010 success? Next 6 vintage clouds are by country:
Indeed, 2010 is popular in USA today, but so is in France, Germany and Austria. Noticeably, sommelier favors 1996, 2004, 2006 in Italy, 1994, 2004, 2005 in Spain, 2005 and 2009 in France, 1996, 2004, 2006 in Italy.

And, finally, let's see wine price histogram:
Selection peaks around $150 to $200, with plenty of choices in $250 to $500 range still. In case you started to worry, I removed wines with price tag above $2000 to improve this chart: there are plenty to choose above $2000, especially the wines from Domaine de la Romanee-Conti.

P.S. Found nothing worth trying or prices are too high? Feel free to bring your own bottle of wine keeping in mind restaurant's published corkage fee policy: "Guests are welcome to bring wines that are not represented on our wine list; however there will be a fee of $150 for each 750ml bottle with a limit of one bottle for every two guests at the table."