Big Data

	A	B	C	D	E	F	G	H	I	J
1		The predictions are trained on the data from the MusicMetrics tab, utilizing a LSTM trained on the current day and the past three days of itunes/spotify
2		audience/current day data, among others, to inform its prediction on the maximum days and audience that the song will have. Predictions from: lstmPredUnseen.py
3		The saved model/scaling and training is from: lstmKW.py. We can compare these results with those for the random forest (RandForest_MusicPreds tab).
4		The predictions are made for rising songs on 6/22/20. The predictions are arranged by predicted Peak Audience, in descending order.
5		We can see if being informed by previous day metrics (more data) leads to a more accurate result. It appears more conservative than the random forest.
6		Notes to Do SQL Text Data Storage.docx for python/sql notes needed for this project; https://colah.github.io/posts/2015-08-Understanding-LSTMs/
7		ArtistTitle	currDays	currAudience	currItunes	currSpotify	currAppleM	currShazam	predMaxDays	predPeakAud

8	1	The Weeknd - Blinding Lights	157	152.39	3	3	22	8	151	161
9	2	Justin Bieber - Intentions (feat. Quavo)	130	124.31	13	16	51	18	129	133.28
10	3	Harry Styles - Adore You	196	121.6	31	30	57	39	182	128.69
11	4	Megan Thee Stallion - Savage Remix (feat. BeyoncÃ©)	72	107.37	14	10	9	9	97	123.36
12	5	Lady Gaga & Ariana Grande - Rain On Me	24	57.23	5	13	34	26	95	115.4
13	6	DaBaby - ROCKSTAR (feat. Roddy Ricch)	34	63.98	4	1	3	2	128	113.14
14	7	SAINt JHN - Roses (Imanbek Remix)	56	69.86	12	12	32	1	142	108.31
15	8	Harry Styles - Watermelon Sugar	27	44.71	8	5	23	35	120	98.42
16	9	Maren Morris - The Bones	269	94.79	29	200	1500	48	233	96.73
17	10	Dua Lipa - Break My Heart	81	76.24	39	33	111	23	109	86.2
18	11	Trevor Daniel - Falling	129	75.97	89	35	167	12	135	84.93
19	12	Luke Bryan - One Margarita	47	48.12	2	158	280	73	116	83.22
20	13	Ariana Grande & Justin Bieber - Stuck with U	44	46.77	32	34	71	10	118	73.61
21	14	Surfaces - Sunday Best	72	51.03	9	14	42	11	130	71.17
22	15	Roddy Ricch - High Fashion (feat. Mustard)	87	67.21	194	49	20	25	95	70.97
23	16	Chris Brown & Young Thug - Go Crazy	29	43.79	69	77	11	4	117	69.13
24	17	Lil Mosey - Blueberry Faygo	57	65.9	113	4	13	17	82	69.1
25	18	Lewis Capaldi - Before You Go	99	61.36	20	61	63	15	119	68.25
26	19	Chris Janson - Done	56	33.15	86	200	1500	102	143	63.84
27	20	Powfu - death bed (feat. beabadoobee) [coffee for your head]	59	47.66	46	200	115	3	114	63.67
28	21	Miranda Lambert - Bluebird	57	40.64	17	200	1500	84	115	62.95
29	22	Thomas Rhett - Be a Light (feat. Reba McEntire, Hillary Scott, Chris Tomlin & Keith Urban)	50	30.4	24	200	1136	71	137	61.87
30	23	Scotty McCreery - In Between	119	54.38	123	200	1378	145	127	60.63
31	24	Keith Urban - God Whispered Your Name	81	32.97	53	200	1232	114	151	58.23
32	25	Ashley McBryde - One Night Standards	24	21.74	164	200	1372	160	144	57.72
33	26	Maddie & Tae - Die From A Broken Heart	49	31.28	91	200	673	76	124	57.1
34	27	Tim McGraw - I Called Mama	19	20.33	283	200	1500	219	146	57.07
35	28	LOCASH - One Big Country Song	84	36.49	138	200	865	146	135	56.72
36	29	Florida Georgia Line - I Love My Country	65	33.41	37	200	1084	159	135	53.86
37	30	Sam Hunt - Hard to Forget	75	44.44	6	200	146	24	107	53.22
38	31	Marshmello & Halsey - Be Kind	43	38.46	35	50	147	32	97	52.07
39	32	Katy Perry - Daisies	11	22.62	126	200	469	117	108	51.46
40	33	Kenny Chesney - Here and Now	107	52.55	206	200	1500	385	109	48.54
41	34	Jack Harlow - WHATS POPPIN	41	39.52	117	11	14	7	89	48.43
42	35	Kane Brown - Cool Again	12	21.96	305	200	593	226	106	48.39
43	36	Carrie Underwood - Drinking Alone	84	27.33	160	200	1362	239	156	47.26
44	37	JP Saxe & Julia Michaels - If the World Was Ending (feat. Julia Michaels)	36	36.12	45	105	171	20	84	45.94
45	38	Chase Rice - Lonely If You Are	7	17.65	484	200	884	271	102	43.99
46	39	Justin Moore - Why We Drink	76	32.58	48	200	974	242	136	42.64
47	40	Jhene Aiko - P***y Fairy (OTW)	49	34.34	1500	200	1500	1000	81	42.05
48	41	BENEE - Supalonely (feat. Gus Dapperton)	61	37.65	130	31	138	14	78	41.62
49	42	Young T & Bugsey - Don't Rush (feat. Headie One)	42	35.49	116	200	871	6	80	40.01
50	43	PARTYNEXTDOOR & Rihanna - BELIEVE IT	63	32.9	716	200	78	21	109	36.7
51	44	Skip Marley & H.E.R. - Slow Down	95	19.23	271	200	1500	58	176	35.15
52	45	Jonas Brothers - X (feat. KAROL G)	28	29.01	77	200	477	41	70	35.04
53	46	THE SCOTTS, Travis Scott & Kid Cudi - THE SCOTTS	34	26.51	186	6	26	34	64	33.04
54	47	Pop Smoke - Dior	69	28.54	446	127	59	49	76	29.7
55	48	Doja Cat - Like That (feat. Gucci Mane)	9	25.22	447	194	182	43	69	29.6
56	49	Moneybagg Yo - 123 f/Blac Youngsta	40	24.45	1500	200	1500	1000	71	28.59
57	50	JACKBOYS & Travis Scott - OUT WEST (feat. Young Thug)	63	21.87	449	87	58	55	66	25.28
58	51	Rotimi - In My Bed (feat. Wale)	24	19.22	579	200	1326	29	96	22.08
59	52	J.i The Prince Of Ny - Need Me	6	17.44	1500	200	1500	1000	29	15.6