Most Liked Zodiacs - Data.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1		Tweet Analysis							User Analysis					Sentiment Analysis
2	Zodiac	Number of Tweets	Average Number of Likes	Average Number of Retweets	Number of Romantic Tweets	%RomanticTweets	Number of "Flame" Tweets	%FlameTweets	Number of Users with Starsign in Bio	Number of Romantic Users	%RomanticUsers	Number of "Flame" Users	%"Flame" Users	Number of Tweets Analysed	Positive Tweets	%Positive Tweets	Negative Tweets	%NegativeTweets	Positive/Negative Ratio
3	Aquarius	241642	5.819	0.76253	64068	27%	278	0.12%	2545	632	25%	33	1.3%	40000	18284	46%	644	2%	28.39
4	Virgo	220026	4.829	0.55852	5197	2%	130	0.06%	2508	592	24%	19	0.8%	40000	17188	43%	1998	5%	8.60
5	Gemini	259231	4.989	0.83896	29794	11%	280	0.11%	2997	726	24%	23	0.8%	40000	15691	39%	947	2%	16.57
6	Libra	251451	4.642	0.55057	5957	2%	171	0.07%	2552	647	25%	30	1.2%	40000	13532	34%	6635	17%	2.04
7	Sagittarius	212555	4.104	0.50356	3248	2%	303	0.14%	1353	331	24%	21	1.6%	40000	13397	33%	254	1%	52.74
8	Leo	354930	6.466	0.80500	24059	7%	1058	0.30%	3992	1050	26%	54	1.4%	40000	11201	28%	5895	15%	1.90
9	Pisces	242798	5.486	0.67545	7925	3%	217	0.09%	2558	632	25%	13	0.5%	40000	10554	26%	3541	9%	2.98
10	Scorpio	257834	4.069	0.50167	6583	3%	235	0.09%	2819	730	26%	28	1.0%	40000	10385	26%	3537	9%	2.94
11	Capricorn	216783	4.315	0.51551	3971	2%	107	0.05%	1593	413	26%	18	1.1%	40000	10315	26%	491	1%	21.01
12	Taurus	214293	5.135	0.64722	4987	2%	157	0.07%	1851	460	25%	23	1.2%	40000	9566	24%	525	1%	18.22
13	Aries	238227	4.212	0.48850	26434	11%	555	0.23%	2296	591	26%	62	2.7%	40000	5354	13%	10423	26%	0.51
14	Cancer**	21328	4.719	5.25938	4503	21%	106	0.50%	8556	394	5%	24	0.3%	22998	2777	12%	10262	45%	0.27
15
16
17	**Due to cancer the disease being commonly tweeted about, separating the tweets for star sign only is tricky, as a result, the number of tweets and further analysis is likely underestimated.
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100