Monday, August 15, 2016

In-flight 720p streaming video plans compared

Update 2: Govt. regulatory body TRAI allows In-flight Cellular services.
Catch more details here:
https://timesofindia.indiatimes.com/india/trai-allows-wifi-and-mobile-services-on-board-for-flyers-in-and-over-india/articleshow/62570754.cms
https://www.ndtv.com/india-news/telecom-regulator-recommends-internet-in-flight-mobile-calls-in-india-1802235 


Update: A very useful collection of traveller's reviews: https://www.sleepinginairports.net


The today's SMH article mentioning that Quantas has decided to offer free in-flight Wi-Fi is a really good news for frequent travellers and road warriors who need to catch up with their weekly dose of entertainment. Be it the live streaming of Olympic games from Rio or watching the latest Game of Thrones episode, in-flight Wi-Fi can be a real time saver.

I decided to create a hypothetical scenario in which all the passengers in an Airbus-A320 Neo decide to watch the video content for the entire duration of flight. A quick google search threw up these numbers:
A full flight can accommodate 195 passengers.
A minute of 720p video consumes 10MB of bandwidth.
An Airbus can fly for 7 hours on a full tank.
So the maximum data that can be consumed by a flight full of passengers in a flight is:
195*7*60*10= 819,000MB or 819GB (a mammoth size)
Dividing it by the number of passengers, we are looking at an average data consumption of 4.2GB per passenger during a flight. (another very unlikely figure)

I searched for plans of the airlines that satisfied my requirement for video streaming and landed up with this article. I used the plans mentioned on the page and extrapolated numbers for some plans as needful and then plotted the points on a scatter plot to see the relative positions of the 12 airlines.

The graph is as under and the presentation is linked here:

Download the linked presentation.
The readers are invited to point out improvements to the approach. Thanks.

Wednesday, July 20, 2016

Strategic petroleum reserves: India

Hello,

Some time back, I had written an article on nature of Strategic Petroleum Reserves.
You can read it here:
STRATEGIC PETROLEUM RESERVES AND ‘UN-FLAT’ NESS OF THE WORLD

Today, I have read another article related to growth of Strategic Petroleum Reserves in India.
Read it here: India responds to growth in oil imports

Currently, a 13 day reserve for India is being planned which is proposed to be increased to 90 days worth. So, which are the countries that are suitably covered by this 13 day storage?

Locations and travelling times for an oil tanker to travel from their port to an Indian Port of Paradip:


Thus, a SPR of 13 days will reduce the Indian dependency on Gulf states but will not cover the oil imports from African and South American countries. Details of port and OPEC annual production data are as under:



An SPR of 90 days will however cover all the oil imports requirements from the 13 places considered. However, we don't have the volumetric import data of India from each of these place which would help in preparing an optimization study.

Thank you.


References:

1. Transit Times and Distance using https://www.searates.com

Monday, July 18, 2016

Comparison of top 10 and bottom 11 Fortune 500 firms

Hello readers,

A text analytics based comparison was done to find unique characteristics of firms belonging in the two clusters:

Cluster 1:
Rank 1: Walmart
Rank 2: Exxon Mobil
Rank 3: Apple
Rank 4: Berkshire Hathaway
Rank 5: McKesson
Rank 6: United Health Group
Rank 7: CVS Health
Rank 8: General Motors
Rank 9: Ford Motor
Rank 10: AT&T

Cluster 2:
Rank 490: Rockwell Collins
Rank 491: Lam Research
Rank 492: Fiserv
Rank 493: Spectra Energy
Rank 494: Navient
Rank 495: Big Lots
Rank 496: Telephone & Data Systems
Rank 497: First American Financial
Rank 498: NVR
Rank 499: Cincinnati Financial
Rank 500: Burlington Stores

Download report:
Detailed report containing observation commentary, correlation plots and word clouds is available for download here: Report


Correlation plot for Ford Motor
R programming language (along with packages "tm", "RGraphviz", "graph" and "slam") was used to prepare this analysis report. Citation for each has been provided below.

Do leave comments below. Thanks.



Citations:
  • R Core Team (2016). R: A language and environment for statistical computing. R Foundation for Statistical Computing, Vienna, Austria. URL https://www.R-project.org/.
  • Kurt Hornik, David Meyer and Christian Buchta (2016). slam: Sparse Lightweight Arrays and Matrices. R package version 0.1-35. https://CRAN.R-project.org/package=slam
  • Kasper Daniel Hansen, Jeff Gentry, Li Long, Robert Gentleman, Seth Falcon, Florian Hahne and Deepayan Sarkar (2016). Rgraphviz: Provides plotting capabilities for R graph objects. R package version 2.16.0.
  • R. Gentleman, Elizabeth Whalen, W. Huber and S. Falcon (2016). graph: graph: A package to handle graph data structures. R package version 1.50.0.
  • Ingo Feinerer and Kurt Hornik (2015). tm: Text Mining Package. R package version 0.6-2. https://CRAN.R-project.org/package=tm 
  • Ingo Feinerer, Kurt Hornik, and David Meyer (2008). Text Mining Infrastructure in R. Journal of Statistical Software 25(5): 1-54. URL: http://www.jstatsoft.org/v25/i05/.
  • Latest annual reports were collected from individual websites of each of the 21 companies analyzed in the report.

Thursday, July 7, 2016

Chilcot Report : Text analytics (Wordcloud and correlation plots)

Hello readers,

The Chilcot Report has been published.
You can read the report here:
http://www.iraqinquiry.org.uk/the-report/

I have taken a shot at it by merging all the 58 PDF files into a merged PDF document.
I then converted it into text and made a wordcloud.
The wordcloud is as under:
More analysis to follow.
Thanks.

UPDATE:

The correlation plot has been prepared. It can be viewed from the following link:
CHILCOT REPORT ANALYSIS

Saturday, June 4, 2016

Sentiment analysis of e-Commerce firms in India: May 2016

The results are as under.
Detailed report available only via solicitation.
Send requests through comments below.




(Twitter Sentiment Score by months)



(Spread of positive and negative tweets for May 2016)

Thank you.

Monday, May 2, 2016

Sentiment analysis of Indian travel planning companies- April 2016

Hello readers,


We bring to you a look at how have some of the travel firms in India been doing on Twitter this month!

Download detailed report here: APRIL 2016 REPORT

We have carried out the sentiment analysis of following Indian travel planning firms:

MakeMyTrip - @makemytrip
GoIbibo - @goibibo
Cleartrip - @cleartrip
Yatra.com - @YatraHolidays

5000 tweets posted between 01/04/2016 and 30/04/2016 have been analysed.


RANKS:

1: MAKEMYTRIP WITH A SCORE OF 82/100
2: CLEARTRIP WITH A SCORE OF 54/100
3: GOIBIBO WITH A SCORE OF 32/100
4: YATRA HOLIDAYS WITH A SCORE OF 0/100



MakeMyTrip is again number 1 with a very high score of 82/ 100.
Cleartrip is second with a score of 54/100 and is followed by Yatra and GoIbibo.




The comparison of twitter sentiment survey results with previous month are as shown under:


 (Click on image to enlarge)


Data files are available on request.  Leave request in comments.


Thanks,
N. Singh






Sunday, May 1, 2016

Sentiment Analysis of telecom operators in India: April, 2016

Hi readers,


We sought 10,000 tweets and measured the response at the official hashtags of the following telecom operators:

Airtel ~ @airtelindia,
BSNL Mobile ~ @bsnlmobileindia,
Reliance Mobile ~ @RelianceMobile,
Tata Docomo ~ @tatadocomo,
Idea Cellular ~ @ideacellular &
Vodafone ~ @VodafoneIN

(Click on the picture to enlarge)




The Twitter Sentiment Score is calculated as follows:

TSS = 100* (Total positive tweets/ Total tweets)

A higher score is better and shows an overall positive sentiment among twitter feedback left with respective company's official hashtag. Positive tweets have score more than +2 and negative tweets have score less than -2.


(Click on the picture to enlarge)


Detailed score is as under:

(Click on the picture to enlarge)




Please note that BSNL  did return only 8 tweets from its hashtag @bsnlmobileindia.
Last month, the count was 4 tweets only.




Word clouds are in report. Download the report HERE.

The individual data files are available on request.
Please leave your requests in comments section below this post.


Best regards,
N

Your Release Just Wrote Its Own Docs

  Every release ships with a shadow task nobody wants: writing the docs. The README needs updating. The changelog needs to actually reflect...