Sentiment analysis of electronics firms [As on 31st Jan, 2016]

Dear readers,

A new gadget or a new appliance is a source of happiness and joy for the whole house, but what happens when it starts giving trouble very soon ? How do the consumers react  and how do the electronics goods manufacturing brands face such social uproar?

The sentiment analysis of the major electronic brands in India has been carried out and results are as under:

Complete report: DOWNLOAD

Sentiment analysis of airlines [As on 31 Jan., 2016]

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

Dear readers,

Most of the time passengers get a breezy service from airlines and their journeys are pleasant. What happens when things don't go so smooth and there are issues in quality of service ?

The response left by people using official hashtags of American Airways, Delta Airways and Ryanair have been analysed. We solicited and parsed through the latest 10,000 tweets and created a score based on sentiment analysis.

The new rankings of the airlines are as under:
Rank 1 Ryanair
Rank 2 Delta Airlines
Rank 3 American Airlines

(click on the image to enlarge)

Detailed report along with word clouds of individual tweet dumps is available here:
Download


Raw tweet dumps are also available on request.
Please leave your requests in comments below.

Suggestions for improvement are solicited.

Thanks.

Social media survey and sentiment analysis of e-commerce firms in India [As on Jan. 30, 2016]

Dear readers,

Last month, we had seen the ranking of 6 e-commerce firms based on the consumer sentiment derived by analysis of tweets at their Twitter handles. 10,000 tweets from each handles were solicited and parsed. The firms were:
Amazon ~ @amazonIN,
eBay ~ @ebayindia,
Flipkart~ @Flipkart,
Jabong ~ @JabongIndia,
Myntra ~ @myntra &
Snapdeal ~ @snapdeal

These firms have been 're-ranked' as on 30 Jan., 2016 as:
Rank 1 Snapdeal
Rank 2 Amazon
Rank 3 Flipkart
Rank 4 Myntra
Rank 5 Jabong
Rank 6 eBay

Rankings as on 30 Jan., 2016 (click to enlarge)

The new ranking report containing graphs and word stems of individual firms has been published. Report can be downloaded from the URL below:

REPORT

Detailed data dumps used in analysis are also available on request.
Please leave your requests in the comments section below.

Feedback is solicited.

Thanks.

Sentiment Analysis of telecom firms in India: As on 30 Jan., 2016

Hello readers,

Last month, we had analysed the tweets from the official twitter handles of 6 telecom firms operating in India. The purpose of analysis was to discover the opinion of people who are associated with the brands.

As a continuation to the effort, please find below the results of sentiment analysis of the 6 firms namely Airtel, BSNL, Idea, Reliance, Tata Docomo and Vodafone.

You can also download the complete results, graphs and word stems in PDF from the following link:
Telecom Jan 2016

Data dump used in the survey is available on request. Please leave requests in the comment box and we will get back to you.

Rankings (click to enlarge the image)

Your comments and feedback are solicited.
Thanks.

An unconventional analysis of the old and new 7 sisters in oil and gas sector

We began with the following hypotheses:

• Most of the finished goods of oil firms are commodities and so are the raw materials (crude, labour, finance) ; therefore, it is very difficult to create price differentials unless product is non-homogenous and brand (intangible assets) is strong.

• In case of a homogenous product and non-differentiated pricing, the only way to larger bottom-line is through cost efficiency achieved from better processes developed either by RnD or by services of external domain consultant.

(click to enlarge)

Data and result files can be downloaded from the following links:

Data 

Results 

Observations 

Thanks.

Social media popularity ranking for the automobile manufacturing firms in India

Hello readers,

Download complete report here:  https://goo.gl/tV4Yk6 

Twitter is a popular social medium to popularize a brand and is therefore an apt place to measure a brand’s impactful presence. In this analysis, we have analyzed and ranked the brand presence of 11 automobile manufacturing firms and their operations in India. Latest 1000 tweets as on 24.01.2016 have been analyzed.

Brand rankings

Sl. No.	Automobile Mfg. firms	Sample set	very.pos. count	very.neg. count	very.tot	Brand Score
1	@MahindraRise	928	81	3	84	96
2	@TataMotors	804	163	11	174	94
3	@Maruti_Corp	796	129	21	150	86
4	@DatsunIndia	1000	94	18	112	84
5	@RenaultIndia	351	36	11	47	77
6	@FordIndia	1000	68	36	104	65
7	@HyundaiIndia	524	52	28	80	65
8	@volkswagenindia	965	39	22	61	64
9	@Toyota_India	185	9	10	19	47
10	@HondaCarIndia	1000	52	194	246	21
11	@Chevrolet_India	27	0	2	2	0

Observations

1.     The surprising entry in top ranks is undoubtedly Datsun India and more so because their car models had been labelled as unsafe for driving on roads. Surprising losers are Honda who despite having good cars, affordable servicing and international repute have scored pretty low.

2.     Also, despite being a new entrant to Indian car scene, Datsun has managed to put more than 1000 tweets on its twitter handle. This shows that they are managing their social media strategy very well. Chevrolet India on the other hand has 27 tweets on their main handle. Please note that some car manufacturers have individual handles for their car brands which have not been parsed in this analysis. However, if those handles included an attribution to parent twitter handle, then those tweets have been collected in this analysis.

Mahindra @MahindraRise (Rank 1 of 11)

Word frequency table (Top 10)

word	frequency
kuv	408
mahindrakuv	190
mahindra	181
anandmahindra	158
new	146
diesel	138
engine	117
odmag	113
delhi	107
launches	95

Wordcloud (“mahindrarise” dropped for excessive repetition)

The wordclouds are heavy image files. To check them out, download the complete report here: 

https://goo.gl/tV4Yk6 

Tata Motors @TataMotors (Rank 2 of 11)

Word frequency table (Top 10)

word	frequency
new	174
ceo	169
butschek	165
guenter	140
tata	125
welcome	88
join	80
extending	79
warm	79
httpstcoxvnwadbf	78

Wordcloud ("tatamotors" dropped for excessive repetition)

The wordclouds are heavy image files. To check them out, download the complete report here: 

https://goo.gl/tV4Yk6 

Maruti @Maruti_Corp (Rank 3 of 11)

Word frequency table (Top 10)

word	frequency
maruti	143
contest	129
enter	127
win	127
rideofrenzy	121
brezza	96
car	89
vitara	89
vitarabrezza	88
nexa	84

Wordcloud ("maruticorp" dropped for excessive repetition)

The wordclouds are heavy image files. To check them out, download the complete report here: 

https://goo.gl/tV4Yk6 

Datsun @DatsunIndia (Rank 4 of 11)

Word frequency table (Top 10)

word	frequency
dream	327
yes	266
dreams	232
say	210
join	131
life	131
conversation	115
work	113
just	104
take	95

Wordcloud ("datsunindia","datsun","isayyes" dropped for excessive repetition)

The wordclouds are heavy image files. To check them out, download the complete report here: 

https://goo.gl/tV4Yk6 

Apparently, Datsun has successfully attracted the social media users by leveraging their emotions using words like dreams.

Renault @RenaultIndia (Rank 5 of 11)

Word frequency table (Top 10)

word	frequency
kwid	57
win	41
contest	39
renault	39
autoexpo	38
car	37
know	27
get	26
sale	23
bbfinalewithsalman	21

Wordcloud ("renaultindia" dropped for excessive repetition)

The wordclouds are heavy image files. To check them out, download the complete report here: 

https://goo.gl/tV4Yk6 

Ford @FordIndia (Rank 6 of 11)

Word frequency table (Top 10)

word	frequency
new	188
launched	147
ford	125
live	117
launch	110
lakh	87
suv	77
httpst	71
watch	71
will	61

Wordcloud ("endeavour", "fordindia", "allnewfordendeavour" dropped for excessive repetition)

The wordclouds are heavy image files. To check them out, download the complete report here: 

https://goo.gl/tV4Yk6 

Hyundai @HyundaiIndia (Rank 7 of 11)

Word frequency table (Top 10)

word	frequency
car	63
creta	50
contest	37
enter	37
baleno	36
compact	35
iamsrk	31
part	31
timesofindia	31
autoexpo	30

Wordcloud ("hyundaiindia", "hyundai" dropped for excessive repetition)

The wordclouds are heavy image files. To check them out, download the complete report here: 

https://goo.gl/tV4Yk6 

Volkswagen @volkswagenindia (Rank 8 of 11)

Word frequency table (Top 10)

word	frequency
polo	412
cars	391
accident	390
features	389
safety	387
due	385
damage	384
recounts	384
rushikesh	384
averted	383

Wordcloud ("volkswagenindia","volkswagen" dropped for excessive repetition)

The wordclouds are heavy image files. To check them out, download the complete report here: 

https://goo.gl/tV4Yk6 

Toyota @Toyota_India (Rank 9 of 11)

Word frequency table (Top 10)

word	frequency
safety	38
india	37
toyotaatautoexpo	37
fortuner	34
new	34
expo	33
mascot	31
thums	31
fordindia	30
endeavour	29

Wordcloud ("toyotaindia" dropped for excessive repetition)

The wordclouds are heavy image files. To check them out, download the complete report here: 

https://goo.gl/tV4Yk6 

[UPDATE]
This analysis deserves some more observations.
We found that the twitter dump obtained from using Toyota handle had references to its rival fordindia and endeavor. Toyota's Fortuner is a rival of Ford Endeavour and therefore, it is interesting to note that the comparison of them on official Twitter handle suggests a larger number of fence sitters. In such a situation, the rival providing an attractive price point will attract potential buyers. However, product homogeneity is also an important factor to be considered before arriving at conclusions. It has not been checked here.

Honda @HondaCarIndia (Rank 10 of 11)

Word frequency table (Top 10)

word	frequency
health	234
vehicle	228
monitoring	152
honda	140
risk	126
can	124
engine	119
car	112
service	110
breaking	109

Wordcloud ("hondacarindia","hangoutwithhonda","hondaconnect" dropped for excessive repetition)

The wordclouds are heavy image files. To check them out, download the complete report here: 

https://goo.gl/tV4Yk6 

Chevrolet @Chevrolet_India (Rank 11 of 11)

Word frequency table (Top 10)

word	frequency
autoexpo	17
aetms	9
chevrolet	9
gtgt	9
beat	7
cruze	7
india	7
corvette	6
new	6
spin	6

Wordcloud ("chevroletindia" dropped for excessive repetition)

The wordclouds are heavy image files. To check them out, download the complete report here: 

https://goo.gl/tV4Yk6 



We have not followed the individual product twitter hash tags for the firms and that is, apparently, the major reason of low number of tweets coming from Cherolet's official handle. But, if a tweet from its product handle, say Chevrolet Beat, also has a hash tag of Chevrolet India, then those tweets have been read and parsed in this analysis.