Given the following pandas dataframe df2, write a line of code to return the sum of the wins of the sports teams. “Sport” “Wins” “Rating” “Braves” “Baseball” 15 4.8 “Falcons” “Football” 17 4.5  

Create a 1-dimensional array called a1 that contains 25 numbers 1 through 50 (inclusive), and datatype of float.

For the following questions, indicate what will be printed to the Python shell when the code is executed. Do not include quotes around strings when they are printed. 

Given the following pandas dataframe named df1, what will the type be of x when the following code is executed (what would print(type(x)) return?) x = df1.loc 1 2 3 “a” 45 50 55 “b” 7 14 21

Which of the following does not access a single row from a pandas dataframe named df.

Given the first pandas dataframe called df1, write a line of code that returns the second (smaller) dataframe called df2. df1: 1 2 3 “a” 45 50 55 “b” 7 14 21 df2: 1 2 “a” 45 50 “b” 7 14

Given the following pandas dataframe called dessert, write a line of code that finds the average rating of all the desserts.  name price rating 0 brownies 3 10 1 cake pops 2 6 2 lemon bars 5 7    

For each of the following, follow the instructions and write a one-line solution to the coding problems. You may assume re has already been imported.

For the following question, indicate what will be printed to the Python shell when the code is executed. All answers must be case-sensitive.

Using the re module, write a one-line expression that will return a list of all the phone numbers in the given string. Hint: Be careful with metacharacters. Target string:target = “My favorite area code is (321). Today, I called these phone numbers: (678) 132-9851, (770) 298-2993, (404) 981-3272. ” Expected result: