Using ‘full_data’, calculate the total streams over the year 2021…
Question Using ‘full_data’, calculate the total streams over the year 2021… Using ‘full_data’, calculate the total streams over the year 2021 by grouping the data by “Track.Name”. Sort the songs based on the total streams and select the top 5 songs streamed for the year. Next, calculate the total streams over the sample period by grouping the data by “Artist”. Sort the artist based on the total streams and select the top 5 artists streamed. In total, you should have 5 most listened songs and 5 most listened artists. Report them as Table 2. Code for full data: full_data = pd.DataFrame()for csv in os.listdir(“C:/Users/kazer lv/Documents/Week13 BUSS511”): if csv.endswith(“.csv”): print(csv) data = pd.read_csv(csv) full_data = pd.concat([full_data, data])full_data.head()output: Apr21.csvAug21.csvFeb21.csvJan21.csvJul21.csvJun21.csvMar21.csvMay21.csvOct21.csvSep21.csvUse full data to complete the question above. Full data is all the csv files merged in 1 CSV Link-https://drive.google.com/drive/folders/1F72mqoshg2EHnd-WROD7hlYrFSMWUbap?usp=sharing Computer Science Engineering & Technology Python Programming BBUS 511 Share QuestionEmailCopy link Comments (0)
