Question: I used Python as my programing language. Can you please tell me why my Problem 4 and 5 isn't working? If possible can you write

I used Python as my programing language. Can you please tell me why my Problem 4 and 5 isn't working?

If possible can you write the correct code?

I used Python as my programing language. Can you please tell me why my Problem 4 and 5 isn't working? If possible can you

Problem 4 Create a DataFrame caled mlax by importing the men's lacrosse tean roster from "httpa: iliund. com'sports'mlaxiroster". After previeving ti ax, you notice that the freshmen have no height, weight, home town and high school data. Remove the freshmen from the roster. Display the first 10 rows of mlax. Hint Go to the webpage to identify the HTML tables on the page and what kind of data is stored in them. B]: KeyErrot Traceback (nost recent ca11 last) in cinodula 1mlax = pd.read_htm1("https://und. con/sports/mlax/roster/* [ [a] 2 rows =mlax[ "Class"] != "Freshnat" 3m lax [rous] [cols] 4mlax. head (10) /usr/1sb/python3.7/site-packages/pandas/core/frane.py in petitent_ (selt, key) /usr/1ib/python 3.7/site-packages/pandas/core/indexing-py in get__1stlike_lidexer(self, key, axis) 1312 keyarr, indexer, new_indexer = ax__reindex_non_unique(keyarr) 1313 1314 1315 1316 If needs_18_conversion(ax.dtype) or isinstance( 1375 1376 not_found = list(ensure_index(key) [missing_mask.nonzero()[e]].unique()) KeyError: "None of [Index(['make', 'node1", 'year', "cylinder's", 'class', "transnissiontype'], dtype='object')] are In the [col unns] " Problem 5 Write code that continually prompts a user for a two-letter state code, assigns the input to a variable called haine_state and proceeds as follows: 1. If the input is a valid state code (i.e. exists in states) and there are players from the state in mlax, create a DataFrame called players with just those players and display it. 2. If the input is a valid state code and there are no players from the state in mlax, print a message that reads "There are nio player's fron "\{hone_state\}" ." 3. If the input is not a valid state code, print a message that reads "Invalld state code! Please try again. ". 4. If the input is "exit", stop the code. Hint: My solution looks something like this: while True: home_state = input("Enter a two-letter state code: ") if break= else: else: prlnt( "HI", "ID", "IL", "IN", "IA", "KS", "KY", "LA", "ME", "MD", "MA", "MI", "MN", "MS", "MO", "MT", "NE", "MV", "MA", "NJ", "SO", "TN", "TX", "UT", "VT", "VA", "WA", "WV", "WI", "WY"] while True: hone_state = input('Enter a two-letter' state code: ') hone_state.upper () if hone_state = "exil: : break else: 1f home_state in states: rows = mlax['Honetown' ].str. endswith(tione_state) players = nlax[rows] if len(players)=: print("There are no players from \{\}+, fornat(hone_state) ) else: display(players) else: print("Invalid state code! Please try again. ") Problem 4 Create a DataFrame caled mlax by importing the men's lacrosse tean roster from "httpa: iliund. com'sports'mlaxiroster". After previeving ti ax, you notice that the freshmen have no height, weight, home town and high school data. Remove the freshmen from the roster. Display the first 10 rows of mlax. Hint Go to the webpage to identify the HTML tables on the page and what kind of data is stored in them. B]: KeyErrot Traceback (nost recent ca11 last) in cinodula 1mlax = pd.read_htm1("https://und. con/sports/mlax/roster/* [ [a] 2 rows =mlax[ "Class"] != "Freshnat" 3m lax [rous] [cols] 4mlax. head (10) /usr/1sb/python3.7/site-packages/pandas/core/frane.py in petitent_ (selt, key) /usr/1ib/python 3.7/site-packages/pandas/core/indexing-py in get__1stlike_lidexer(self, key, axis) 1312 keyarr, indexer, new_indexer = ax__reindex_non_unique(keyarr) 1313 1314 1315 1316 If needs_18_conversion(ax.dtype) or isinstance( 1375 1376 not_found = list(ensure_index(key) [missing_mask.nonzero()[e]].unique()) KeyError: "None of [Index(['make', 'node1", 'year', "cylinder's", 'class', "transnissiontype'], dtype='object')] are In the [col unns] " Problem 5 Write code that continually prompts a user for a two-letter state code, assigns the input to a variable called haine_state and proceeds as follows: 1. If the input is a valid state code (i.e. exists in states) and there are players from the state in mlax, create a DataFrame called players with just those players and display it. 2. If the input is a valid state code and there are no players from the state in mlax, print a message that reads "There are nio player's fron "\{hone_state\}" ." 3. If the input is not a valid state code, print a message that reads "Invalld state code! Please try again. ". 4. If the input is "exit", stop the code. Hint: My solution looks something like this: while True: home_state = input("Enter a two-letter state code: ") if break= else: else: prlnt( "HI", "ID", "IL", "IN", "IA", "KS", "KY", "LA", "ME", "MD", "MA", "MI", "MN", "MS", "MO", "MT", "NE", "MV", "MA", "NJ", "SO", "TN", "TX", "UT", "VT", "VA", "WA", "WV", "WI", "WY"] while True: hone_state = input('Enter a two-letter' state code: ') hone_state.upper () if hone_state = "exil: : break else: 1f home_state in states: rows = mlax['Honetown' ].str. endswith(tione_state) players = nlax[rows] if len(players)=: print("There are no players from \{\}+, fornat(hone_state) ) else: display(players) else: print("Invalid state code! Please try again. ")

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 Accounting Questions!

In Canada, income tax is paid to both federal and provincial governments. The provinces and territories also have tax brackets, which are different from the federal tax brackets and different from...

In Canada, sales tax rates vary between provinces and are made up of a provincial sales tax and the federal sales tax (GST) of 5%. Your job in this problem is to calculate the sales tax amount on...

When I run my code, I input the tolerance and then it doesn't return anything. Please tell me what in my code is causing this. This is my code: #include #include #include using namespace std; double...

INSTRUCTIONS This assignment testsyour ability to create a simple regression solution to a prediction problem. You will use a dataset of bike rentals fromCapital Bikeshare system, Washington D.C.,...

answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...

MATHEMATICIANS RISE TO A CHALLENGE ne of the theorems we teach in eighth grade is a + b= *, where c is the length of the hypotenuse of a right triangle in Euclidean space, and a and b are the lengths...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

Introduction and learning objectives When you were learning about operational analysis earlier in the term, we talked about jobs that require multiple visits to the CPU (or servers) to receive their...

Students will review examples and evaluate them. Review these documents and evaluate them (click on the link): https://1drv.ms/w/s!AoYu6G3CLyuakjVCGipkRkNSBVUB?e=jrPXX6...

What is the basis of Jason and Myras argument for the need for an arbitrary scales to address customer satisfaction?

TLC Lawn care, Inc., provides fertilizer and weed control lawn services to residential customers. Its seasonal service package, regularly priced at $250, includes several chemical spray treatments....

Paid tax preparers must comply with all of the following EXCEPT: Pregunta 1 4 Seleccione una: a . Charge a contingent fee. b . Pass a competency examination. c . Sign all tax returns they prepare. d...

2 By moving from a reliance on the explicit knowledge of written reports, towards an emphasis on implicit knowledge that can be shared and adapted, how can BP operate this successfully in different...

1 What are the likely cultural barriers to developing the learning organization concept in countries other than Anglo-Saxon ones?

1 How can BP best protect its unique know-how in view of its policy of allying with other, possibly competing organizations, within its concept of the learning organization?