Question: please solve extra credit question Assignment Below is the code that creates data for the assignment. tweet_creation_date = ['2020-10-15 00:00:01, 2020-10-20 02:32:38', 2020-10-23 17:01:53','2020-10-28 12:23:38','2020-11-01

please solve extra credit questionplease solve extra credit question Assignment Below is the code that createsdata for the assignment. tweet_creation_date = ['2020-10-15 00:00:01, 2020-10-20 02:32:38', 2020-10-23 17:01:53','2020-10-2812:23:38','2020-11-01 16:58:18', 2020-11-03 17:07:47', 2020- 11-04 12:45:00', '2020-11-05 17:34:53', '2020-11-06 20:16:16', '2020-11-07

Assignment Below is the code that creates data for the assignment. tweet_creation_date = ['2020-10-15 00:00:01, 2020-10-20 02:32:38', 2020-10-23 17:01:53','2020-10-28 12:23:38','2020-11-01 16:58:18', 2020-11-03 17:07:47', 2020- 11-04 12:45:00', '2020-11-05 17:34:53', '2020-11-06 20:16:16', '2020-11-07 21:39:00'] tweet = ['#Elecciones2020 En #Florida: #JoeBiden dice que #Donald Trump solo se preocupa por l mismo. El demcrata fue anfitrin de encuentros de electores en #Pembroke Pines y #Miramar. Clic AQU OO \ nhttps://t.co/qhIWplUXsT _ #ElSolLatino #yobrilloconelsol https://t.co/6FICBWf1 Mi', 'President #Trump Attacked for Giving Offering While at Church in Las Vegas via @WestJournalism https://t.co/kYEQdqj256', 'Do you remember the first time you squatted your bodyweight? Well, I recently squatted my bodyweight using homemade weights for the very first time and this is how it went: https://t.co/f1dhAa1UhE + #fitness #bodybuilding #chencha #FridayFeeling #streaming #fridaymorning #Trump', "You're a joke and nobody fucks you Unless you pay them money And they'll laugh at your micropenis when you're gone #FakeMelania #trump #stormydaniels Drumpf https://t.co/gbQxeAm6FY via @YouTube", '@White House @realDonald Trump Falsehood lies !!! Do not buy their lies ! #trump tariffs have cost you the #American consumer 100' sof dollarsonmajor purchases, whathepenalizedoverseastheyjust jackeduppricestocoverhi sbssowepayforitnotchina ! Factcheckthatawasherordryerup 120 2buy', '@ammcsalles Orange Vote. #MAGA #Trump', 'I wish President Trump victory!!us #Trump #Trump2020 \u3000\u3000\u3000\u3000\u3000\u3000From Japan up https://t.co/9N3wCm25m8', 'Whatever advantage #Trump had in the swing states is gradually decreasing as voting progress... Be it in #Georgia, #Pensylvania or #Nevada, #Biden is catching up with him. Trump reiterates that he will challenge #Democrat results, though. #USElections2020 #TrumpvsBiden', 'La decencia de periodistas y medios estadounidenses negndose a reproducir las barbaridades y mentiras de #Trump es digna de elogio. Lastima que haya ocurrido cuando ya no pinta nada. Habra sido ms efectivo y digno hacerlo desde el primer da de mandato. Peeeero.', I'm just wondering how the chancer, opportunist n greedy bastard @Nigel_Farage is feeling right now. His dear friend is shrinking... No more free hotel, drink, cigar etc for you. Shameful prick! #haveseveralseats #Trump #Trumpspoppet #Election 2020results https://t.co/IJGhxwEEDp'] likes = [0.0, 0.0, 0.0, 0.0, 1.0, 2.0, 0.0, 24.0, 15.0, 0.0] retweets = [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 3.0, 0.0] user_name = ['El Sol Latino News', 'Paul Elephant','Mr Nice Guy','Chris Shepard', 'Leonardo W','Mrcio Chagas JB38','SHIRO - 8000 7_NEST','KeralaBoxofficeStats (#StayHomeStaySafe)','Sonia', ' dagi'] user_name = ['El Sol Latino News', 'Paul Elephant', 'Mr Nice Guy','Chris Shepard', 'Leonardo W', 'Mrcio Chagas JB38','SHIRO - 600 7_NEST','KeralaBoxofficeStats (#StayHomeStaySafe)','Sonia','dagi'] state = ['Florida', np.nan, 'Gauteng', 'Virginia', np.nan, np.nan, np.nan, np.nan, np.nan, 'England'] elections_data = np.array([tweet_creation_date, tweet,likes,retweets,user_name,state]) The instructions start here Illustrate Insert and Delete operations Insert a row (5 pts) Delete a row (5 pts) Change the data type of the row corresponding to tweet_creation_date Use np.datetime64 as data type (5 pts) Change the data type of the rows corresponding to likes and retweets Use np.int32 as data type (5 pts) Calculate the duration of the tweets on Twitter Substract the current date to the row corresponding to the tweet_creation_date (5 pts) Add 1 to the row corresponding to the number of retweets, and calculate the division number of likes per retweet (5 pts) Return an array corresponding to the results of the comparison between retweets and likes (5 pts) Slicing and indexing Return the 2nd and 4th rows - the 2nd row corresponds to tweet, and the 4th row corresponds to retweets (5 pts) Return the 4th and 7th columns (5 pts) Return the cells located at 2nd or 4th rows) and (4th or 7th columns) (5 pts) Returns the tweets that have at least one like (5 pts) Mathemetical and statistical methods Return the mean of likes and the sum of retweets (5 pts) Extra Credit (15 pts) . Return the tweets created during the month of October 2020 Return the tweets created during the month of November 2020 Calculate the mean of likes of all the tweets created during the month of October 2020 Calculate the mean of likes of all the tweets created during the month of November 2020 Calculate the mean of retweets of all the tweets created during the month of October 2020 Calculate the mean of retweets of all the tweets created during the month of November 2020 Conclude which month between October and November has the highest number of likes, and the highest number of retweets Considering that the elections took place early November 2020, what can you conclude? Did the elections affect the number of likes and retweets? Assignment Below is the code that creates data for the assignment. tweet_creation_date = ['2020-10-15 00:00:01, 2020-10-20 02:32:38', 2020-10-23 17:01:53','2020-10-28 12:23:38','2020-11-01 16:58:18', 2020-11-03 17:07:47', 2020- 11-04 12:45:00', '2020-11-05 17:34:53', '2020-11-06 20:16:16', '2020-11-07 21:39:00'] tweet = ['#Elecciones2020 En #Florida: #JoeBiden dice que #Donald Trump solo se preocupa por l mismo. El demcrata fue anfitrin de encuentros de electores en #Pembroke Pines y #Miramar. Clic AQU OO \ nhttps://t.co/qhIWplUXsT _ #ElSolLatino #yobrilloconelsol https://t.co/6FICBWf1 Mi', 'President #Trump Attacked for Giving Offering While at Church in Las Vegas via @WestJournalism https://t.co/kYEQdqj256', 'Do you remember the first time you squatted your bodyweight? Well, I recently squatted my bodyweight using homemade weights for the very first time and this is how it went: https://t.co/f1dhAa1UhE + #fitness #bodybuilding #chencha #FridayFeeling #streaming #fridaymorning #Trump', "You're a joke and nobody fucks you Unless you pay them money And they'll laugh at your micropenis when you're gone #FakeMelania #trump #stormydaniels Drumpf https://t.co/gbQxeAm6FY via @YouTube", '@White House @realDonald Trump Falsehood lies !!! Do not buy their lies ! #trump tariffs have cost you the #American consumer 100' sof dollarsonmajor purchases, whathepenalizedoverseastheyjust jackeduppricestocoverhi sbssowepayforitnotchina ! Factcheckthatawasherordryerup 120 2buy', '@ammcsalles Orange Vote. #MAGA #Trump', 'I wish President Trump victory!!us #Trump #Trump2020 \u3000\u3000\u3000\u3000\u3000\u3000From Japan up https://t.co/9N3wCm25m8', 'Whatever advantage #Trump had in the swing states is gradually decreasing as voting progress... Be it in #Georgia, #Pensylvania or #Nevada, #Biden is catching up with him. Trump reiterates that he will challenge #Democrat results, though. #USElections2020 #TrumpvsBiden', 'La decencia de periodistas y medios estadounidenses negndose a reproducir las barbaridades y mentiras de #Trump es digna de elogio. Lastima que haya ocurrido cuando ya no pinta nada. Habra sido ms efectivo y digno hacerlo desde el primer da de mandato. Peeeero.', I'm just wondering how the chancer, opportunist n greedy bastard @Nigel_Farage is feeling right now. His dear friend is shrinking... No more free hotel, drink, cigar etc for you. Shameful prick! #haveseveralseats #Trump #Trumpspoppet #Election 2020results https://t.co/IJGhxwEEDp'] likes = [0.0, 0.0, 0.0, 0.0, 1.0, 2.0, 0.0, 24.0, 15.0, 0.0] retweets = [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 3.0, 0.0] user_name = ['El Sol Latino News', 'Paul Elephant','Mr Nice Guy','Chris Shepard', 'Leonardo W','Mrcio Chagas JB38','SHIRO - 8000 7_NEST','KeralaBoxofficeStats (#StayHomeStaySafe)','Sonia', ' dagi'] user_name = ['El Sol Latino News', 'Paul Elephant', 'Mr Nice Guy','Chris Shepard', 'Leonardo W', 'Mrcio Chagas JB38','SHIRO - 600 7_NEST','KeralaBoxofficeStats (#StayHomeStaySafe)','Sonia','dagi'] state = ['Florida', np.nan, 'Gauteng', 'Virginia', np.nan, np.nan, np.nan, np.nan, np.nan, 'England'] elections_data = np.array([tweet_creation_date, tweet,likes,retweets,user_name,state]) The instructions start here Illustrate Insert and Delete operations Insert a row (5 pts) Delete a row (5 pts) Change the data type of the row corresponding to tweet_creation_date Use np.datetime64 as data type (5 pts) Change the data type of the rows corresponding to likes and retweets Use np.int32 as data type (5 pts) Calculate the duration of the tweets on Twitter Substract the current date to the row corresponding to the tweet_creation_date (5 pts) Add 1 to the row corresponding to the number of retweets, and calculate the division number of likes per retweet (5 pts) Return an array corresponding to the results of the comparison between retweets and likes (5 pts) Slicing and indexing Return the 2nd and 4th rows - the 2nd row corresponds to tweet, and the 4th row corresponds to retweets (5 pts) Return the 4th and 7th columns (5 pts) Return the cells located at 2nd or 4th rows) and (4th or 7th columns) (5 pts) Returns the tweets that have at least one like (5 pts) Mathemetical and statistical methods Return the mean of likes and the sum of retweets (5 pts) Extra Credit (15 pts) . Return the tweets created during the month of October 2020 Return the tweets created during the month of November 2020 Calculate the mean of likes of all the tweets created during the month of October 2020 Calculate the mean of likes of all the tweets created during the month of November 2020 Calculate the mean of retweets of all the tweets created during the month of October 2020 Calculate the mean of retweets of all the tweets created during the month of November 2020 Conclude which month between October and November has the highest number of likes, and the highest number of retweets Considering that the elections took place early November 2020, what can you conclude? Did the elections affect the number of likes and retweets

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!