The data is separated as \t (delimiter) and it contains not only numerical data. For the numerical data it will return based on alphabetical order.

please write the code based and for the data bellow. (please do not write the answer in the comment section)

THE SCOTTS THE SCOTTS, Travis Scott & Kid Cudi 1 1 18.05 04:27

Blinding Lights The Weeknd 1 22 9.17 04:21

Toosie Slide 1 4 12.09 02:36

Savage Megan Thee Stallion 4 7 18.47 01:04

The Box Roddy Ricch 1 21 3.68 02:19

Say So Doja Cat 5 17 2.66 03:30

Don't Start Now Dua Lipa 2 26 4.53 04:63

Circles Post Malone 1 35 9.71 01:00

Intentions Justin Bieber Featuring Quavo 8 12 0.84 05:56

Adore You Harry Styles 6 21 5.34 01:09

Righteous Juice WRLD 11 1 4.71 01:48

Life Is Good Future Featuring Drake 2 16 6.77 04:06

My Oh My Camila Cabello Featuring DaBaby 12 21 15.51 05:32

ROCKSTAR DaBaby Featuring Roddy Ricch 9 2 12.04 04:10

The Bones Maren Morris 12 32 0.19 01:49

everything i wanted Billie Eilish 8 25 5.07 05:57

Someone You Loved Lewis Capaldi 1 51 8.59 05:55

Nobody But You Blake Shelton Duet With Gwen Stefani 18 16 16.17 03:62

I Hope Gabby Barrett 16 18 6.26 04:16

Blueberry Faygo Lil Mosey 16 12 5.37 05:55

Memories Maroon 5 2 32 7.75 04:01

Chasin' You Morgan Wallen 21 14 1.27 02:06

Roses (Imanbek Remix) SAINt JHN 22 6 9.7 02:02

Falling Trevor Daniel 22 24 19.79 05:30

High Fashion Roddy Ricch Featuring Mustard 20 18 14.6 02:05

death bed Powfu Featuring beabadoobee 26 7 9.88 03:09

Hot Girl Bummer blackbear 11 33 8.36 02:27

Sunday Best Surfaces 28 9 14.95 01:16

RITMO (Bad Boys For Life) The Black Eyed Peas X J Balvin 23 9.39 03:34

Does To Me Luke Combs Featuring Eric Church 30 7 1.48 03:45

Heart On Ice Rod Wave 25 25 3.83 03:29

Ballin' Mustard & Roddy Ricch 11 41 13.98 02:46

Roxanne Arizona Zervas 4 26 12.73 05:55

Dance Monkey Tones And I 4 30 2.95 05:25

WHATS POPPIN Jack Harlow 35 12 12.76 03:44

Break My Heart Dua Lipa 21 5 1.21 02:53

Heartless The Weeknd 1 23 7.5 01:50

HIGHEST IN THE ROOM Travis Scott 1 22 10.84 04:52

I Hope You're Happy Now Carly Pearce & Lee Brice 39 17 4.86 02:31

Beer Can't Fix Thomas Rhett Featuring Jon Pardi 40 7 10.29 02:38

Level Of Concern twenty one pilots 23 3 4.17 04:24

I Love Me Demi Lovato 18 8 16.16 01:25

More Hearts Than Mine Ingrid Andress 30 18 4.81 03:32

After A Few Travis Denning 44 5 3.63 03:05

All In Lil Baby 45 1 18.18 05:44

10,000 Hours Dan + Shay & Justin Bieber 4 30 17.47 05:07

Hard To Forget Sam Hunt 40 5 16.01 04:41

Supalonely BENEE Featuring Gus Dapperton 48 7 6.93 03:14

Goosebumps Travis Scott 32 35 5.08 02:34

Before You Go Lewis Capaldi 50 13 15.1 01:10

In Your Eyes The Weeknd 16 6 4.94 02:52

Dior Pop Smoke 30 11 11.07 03:31

Sum 2 Prove Lil Baby 16 16 3.88 02:44

Slide H.E.R. Featuring YG 43 19 15.88 01:16

Catch Brett Young 29 14 12.08 04:12

Walk Em Down NLE Choppa Featuring Roddy Ricch 56 6 4.41 02:14

Heartless Diplo Presents Thomas Wesley Featuring Morgan Wallen 57 14 14.22 01:59

JUMP DaBaby Featuring YoungBoy Never Broke Again 17 2 10.18 02:50

If The World Was Ending JP Saxe Featuring Julia Michaels 59 5 13.42 05:26

OUT WEST JACKBOYS Featuring Young Thug 38 16 14.22 04:05

Stupid Love Lady Gaga 5 9 02:28

Yo Perreo Sola Bad Bunny 53 7 13.81 05:42

I'm Ready Sam Smith & Demi Lovato 36 2 9.04 02:60

P*$$y Fairy (OTW) Jhene Aiko 40 15 6.53 03:25

Sasuke Lil Uzi Vert 65 1 14.32 01:29

Godzilla Eminem Featuring Juice WRLD 3 15 13.49 04:59

Find My Way DaBaby 22 4 7.48 03:43

Cool Again Kane Brown 68 1 14.9 03:16

BELIEVE IT PARTYNEXTDOOR & Rihanna 23 5 0.51 01:31

Bluebird Miranda Lambert 70 4 18.8 01:00

Emotionally Scarred Lil Baby 31 9 1.36 01:14

You should be sad Halsey 26 16 14.17 03:97

Here And Now Kenny Chesney 73 4 6.72 04:49

Turks NAV, Gunna & Travis Scott 17 5 7.26 03:11

Be A Light Thomas Rhett Featuring Reba McEntire, Hillary Scott, Chris Tomlin & Keith Urban 71 4 16.4 02:30

Slow Dance In A Parking Lot Jordan Davis 37 17 7.4 04:08

Come Thru Summer Walker & Usher 42 18 15.67 02:09

After Party Don Toliver 78 14.68 03:54

Homemade Jake Owen 39 14 10.04 05:08

Ride It. Regard 3 10.28 03:33

God Whispered Your Name Keith Urban 81 2 14.92 02:46

In Between Scotty McCreery 82 3 14.34 01:15

Ain't Easy YoungBoy Never Broke Again 83 1 12.73 05:05

Party Girl StaySolidRocky 84 1 6.46 05:35

Die From A Broken Heart Maddie & Tae 80 3 1.77 04:20

Diamonds YoungBoy Never Broke Again 86 1 16.61 03:41

Myron Lil Uzi Vert 13 7 14.86 02:35

July Noah Cyrus & Leon Bridges 85 9 13.44 05:43

Captain Hook Megan Thee Stallion 74 4 14.93 04:40

Bout My Business YoungBoy Never Broke Again Featuring Sherhonda Gaulden 90 1 16.64 04:34

That Way Lil Uzi Vert 20 9 15.21 04:52

Rough Ryder YoungBoy Never Broke Again 92 1 13.92 01:01

B.S. Jhene Aiko Featuring H.E.R. 24 6 2.96 03:11

Underdog Alicia Keys 69 5 1.36 04:01

I Love My Country Florida Georgia Line 81 2 11.13 01:98

NASTY DaBaby Featuring Ashanti & Megan Thee Stallion 50 2 14.0 03:01

Drinking Alone Carrie Underwood 97 1 4.55 04:48

PTSD 38 5 17.7 02:73

Thug Of Spades YoungBoy Never Broke Again Featuring DaBaby 99 1 9.89 01:21

Safaera Bad Bunny, Jowell & Randy & Nengo Flow 81 7 7.01 03:38

Task 2: Descriptive Statistics Menu (35 marks) You are tasked with creating a program that will give statistics regarding the top 100 data. The program is to present a console menu that will allow users to give a column and statistic (eg, "Duration" and "Average") and receive the appropriate information in return. Top 100 Information Centre 1. Minimum 2. Maximum 3. Average 4. Sum H. Help Q. quit Your code should have the following functionality: The menu function is to repeatedly ask the user for input until the user enters the value to quit. The menu is the handle both uppercase and lowercase input. If a user enters an column that is out of range, then the menu will ask for a valid column. Only columns with numeric data can be given to Average and Sum, otherwise the menu will ask for a valid column. Note: You are NOT allowed to use any built-in Python functions other than range(), len(), input(), print (), upper(), int() and isinstance(). Function header: menu (top_100) Input: top_100: the top_100 table read from the target file and processed in Assignment 1. Output: Console output. Based on user commands data has been conveniently provided as a CSV file, with the delimiter being a tab (represented in python as "\t") and each row is of the form: Song_name artist_name peak_position num_weeks Duration Price Task 2: Descriptive Statistics Menu (35 marks) You are tasked with creating a program that will give statistics regarding the top 100 data. The program is to present a console menu that will allow users to give a column and statistic (eg, "Duration" and "Average") and receive the appropriate information in return. Top 100 Information Centre 1. Minimum 2. Maximum 3. Average 4. Sum H. Help Q. quit Your code should have the following functionality: The menu function is to repeatedly ask the user for input until the user enters the value to quit. The menu is the handle both uppercase and lowercase input. If a user enters an column that is out of range, then the menu will ask for a valid column. Only columns with numeric data can be given to Average and Sum, otherwise the menu will ask for a valid column. Note: You are NOT allowed to use any built-in Python functions other than range(), len(), input(), print (), upper(), int() and isinstance(). Function header: menu (top_100) Input: top_100: the top_100 table read from the target file and processed in Assignment 1. Output: Console output. Based on user commands data has been conveniently provided as a CSV file, with the delimiter being a tab (represented in python as "\t") and each row is of the form: Song_name artist_name peak_position num_weeks Duration Price