1. Define a function extract_grade(x):• x: A string containing a student number and grade in the format "studentNum-Grade%"• Return: The student's grade as a float.(Hint: Use the .split() and .strip() methods)1. Define a function class_average(final_marks):final_marks: A list of strings, where each string is formatted as "studentNum-Grade%".• Return: The mean grade of the grades in final_marks calculated using equation (1) outlined below.(Hint: Use your extract_grade function and a for loop!)N-11x =Ni=02. Define a function class_std_dev(final_marks):final_marks: A list of strings, where each string is formatted as "studentNum-Grade%".Return: The standard deviation of the grades in final_marks calculated using equation (2) outlined below.(Hint: Use your class_average function and a for loop!)N-11O =i=0 Generating statistics from a set of data is a task that computers love. In this assignment, you will be implementing a grade processing system that willgenerate the mean and standard deviation for a set of final exam grades.We will assume that final grades are stored in a list, where each entry in the list is a string with the following format:"studentNum-finalGrade%"The string represents the final exam mark (finalGrade) that the student (studentNum) achieved. For example, the cell below contains a list of final exam marksfrom two students. Student 1007089 achieved a mark of 91%, and student 1009989 achieved a mark of 77.5%.grades = ['1007089-91%','1009989-77.5%' ]We want to calculate the mean final exam mark from a list of grades. If we assume that we have N grades, the mean x can be calculated from the followingformula:N-11(1)i=0The variable x; represents each grade in our list at index i. We assume that we start counting at 0.We also want to be able to calculate the standard deviation from a list of grades. The standard deviation measures the amount of variability in our data set. Forexample, let's say we want to compute the average and standard deviation for the grades [80, 90, 70, 60]. The average of these grades is 75, and thestandard deviation is 11.2. Now imagine we want to compute the average and standard deviation for the grades [80, 76 ,74, 70]. The average of these gradesis 75, but the standard deviation is 3.6. Although both sets of grades have the same average, the second set has a smaller standard deviation. The reason isbecause the grades are not as "spread out" as the grades in the first set. The grades in the second set deviate from their average by a small amount.The standard deviation o is calculated using our mean x and the following formula:N-11>(x; -(2)O =i=0

We need to Define a function extract_grade(x) , class_average(final_marks) ,std_dev(final_marks):

1. Define a function extract_grade(x): • x: A string containing a student number and grade in the format "studentNum-Grade%" • Return: The student's grade as a float. (Hint: Use the .split() and .strip() methods) 1. Define a function class_average(final_marks): final_marks: A list of strings, where each string is formatted as "studentNum-Grade%". • Return: The mean grade of the grades in final_marks calculated using equation (1) outlined below. (Hint: Use your extract_grade function and a for loop!) N-1 1 N i=0 2. Define a function class_std_dev(final_marks): • final_marks: A list of strings, where each string is formatted as "studentNum-Grade%". • Return: The standard deviation of the grades in final_marks calculated using equation (2) outlined below. (Hint: Use your class_average function and a for loop!) N-1 1 E(xi - O = N i=0

1. Define a function extract_grade(x): • x: A string containing a student number and grade in the format "studentNum-Grade%" • Return: The student's grade as a float. (Hint: Use the .split() and .strip() methods) 1. Define a function class_average(final_marks): final_marks: A list of strings, where each string is formatted as "studentNum-Grade%". • Return: The mean grade of the grades in final_marks calculated using equation (1) outlined below. (Hint: Use your extract_grade function and a for loop!) N-1 1 N i=0 2. Define a function class_std_dev(final_marks): • final_marks: A list of strings, where each string is formatted as "studentNum-Grade%". • Return: The standard deviation of the grades in final_marks calculated using equation (2) outlined below. (Hint: Use your class_average function and a for loop!) N-1 1 E(xi - O = N i=0

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Problem DNA: Subsequence markingA common task in dealing with DNA sequences is searching for particular substrings within longer DNA sequences. Write a function mark_dna that takes as parameters a DNA sequence to search, and a shorter target sequence to find within the longer sequence. Have this function return a new altered sequence that is the original sequence with all non-overlapping occurrences of the target surrounded with the characters >> and <<. Hints: ● String slicing is useful for looking at multiple characters at once. ● Remember that you cannot modify the original string directly, you’ll need to build a copy. Start with an empty string and concatenate onto it as you loop. Constraints: ● Don't use the built-in replace string method. All other string methods are permitted. >>> mark_dna('atgcgctagcatg', 'gcg') 'at>>gcg<<ctagcatg' >>> mark_dna('atgcgctagcatg', 'gc')…
C++ 1. Create a vector of 100 randomly generated integers. Use the count_if function and a lambda function to count the number of even numbers in the vector.2. Repeat Problem 1 for odd numbers.3. Write a function object that prints a number if it is less than 35. Use the function object with the for_each function to display the numbers greater than 50 created in one of the vectors from the problems above.
Scrabble Scrabble is a game where players get points by spelling words. Words are scored by adding together the point values of each individual letter. Define a function scrabble_score (word:str) -> int that takes a string word as input and returns the equivalent scrabble score for that word. score = {"a": 1, "c": 3, "f": 4, "i": 1, "1": 1, "o": 1, "r": 1, "u": 1, "t": 1, "x": 8, "z": 10} For example, "b": 3, "h": 4, "n": 1, Your Answer: == 20 assert scrabble_score("quick") assert scrabble_score("code") == 7 1 # Put your answer here 2 Submit "e": 1, "d": 2, "g": 2, "k": 5, "j": 8, "m": 3, "q": 10, "p": 3, "s": 1, "w": 4, "v": 4, "y": 4,
plaese code in python You are tasked with creating a square grid of values in which each value only appears once in each column and once in each row (think like a Sudoku). Write a function called grid that inputs a list and outputs a square grid of values of that list in which each value only appears once in each column and once in each row. Specifically, one in which each row is the one above it shifted by one item. Your answer should be in the form of a list of lists, where each sub-list is a row of the square. For example: grid([1, 2, 3, 4]) -> [[1, 2, 3, 4], [4, 1, 2, 3], [3, 4, 1, 2], [2, 3, 4, 1]]
Write the function data_tuple_from_line(line_str) that takes a line of input (with value separated by commas) and returns a tuple containing install_id, install_date, size, cost, subsidy, zip code, city, state. In the result tuple: The install_id, install_date, zip code, city, and state should all be strings. The size, cost, and subsidy should all be floats. The city should be in title case.
Homework 10-2 Programming Challenge: 12 - Password Verifier Use the string data type. Do not use arrays of type char or any functions in the old "C String" libraries. Six characters? Seriously? Set the minimum password length to twelve characters. We will also require that the password not contain any space characters. In addition to the requirement that the password contain at least one upper case letter, one lower case letter, and one digit, add the additional requirement that the password contain at least one "special" character. We will consider any character that is printable, not alphanumeric, and not a space character to be "special." That includes punctuation, but may include additional non-punctuation characters. Unfortunately at our level of C++ it's more or less impossible for us to actually test passwords like Señor_99 but the ñ (with a tilde) would count as a special character using our rules. Write functions to complete these tasks as appropriate.
Task 2: The formula for the area, A, of a triangle with sides of length a, b, and c is V[s(s – a)(s – b)(s – c)] A = Where (a + b + c) s = Write, test, and execute a function that accepts the values of a, b, and c as parameters from a calling function, and then calculates the values of s and [s(s - a)(s - b)(s - c)]. If this quantity is positive, the function calculates A. If the quantity is negative, a, b, and c do not form a triangle, and the function should set A = -1. The value of A should be returned by the function. Test the function by passing various data to it and verifying the returned value.
# dates and times with lubridateinstall.packages("nycflights13") library(tidyverse)library(lubridate)library(nycflights13) Qustion: Create a function called date_quarter that accepts any vector of dates as its input and then returns the corresponding quarter for each date Examples: “2019-01-01” should return “Q1” “2011-05-23” should return “Q2” “1978-09-30” should return “Q3” Etc. Use the flight's data set from the nycflights13 package to test your function by creating a new column called quarter using mutate()
The code should be in Python 1. Write a function that takes two sets of strings and returns a new set containing all elements of the first set that are not in the second set. 2. Write a function that takes two sets of strings and returns a new set containing all elements of the first set that are also in the second set.
Here is a function that is supposed to return True if word (any string) ends with "s" and False otherwise: def ends_with_s(word):if len(word) < 1:return False return word[-1] == "s" Here is the test function I am using to test ends_with_s: def test_ends_with_s(): assert(ends_with_s("cats")) # option 1 assert(ends_with_s("") is False) # option 2 assert(ends_with_s("apple") is False) # option 3 assert(ends_with_s("S")) # option 4 Rewrite ends_with_s so that the test passes
PYTHON Complete the function below, which takes two arguments: data: a list of tweets search_words: a list of search phrases The function should, for each tweet in data, check whether that tweet uses any of the words in the list search_words. If it does, we keep the tweet. If it does not, we ignore the tweet. data = ['ZOOM earnings for Q1 are up 5%', 'Subscriptions at ZOOM have risen to all-time highs, boosting sales', "Got a new Mazda, ZOOM ZOOM Y'ALL!", 'I hate getting up at 8am FOR A STUPID ZOOM MEETING', 'ZOOM execs hint at a decline in earnings following a capital expansion program'] Hint: Consider the example_function below. It takes a list of numbers in numbers and keeps only those that appear in search_numbers. def example_function(numbers, search_numbers): keep = [] for number in numbers: if number in search_numbers(): keep.append(number) return keep def search_words(data, search_words):
The programming language is - Python a. Write a function called daysOver that takes three arguments: a dictionary, a location (such as ‘Sydney’, ‘Adelaide’,etc) and a temperature and returns the number of days that were over the given temperature for the given location. For example, if we call the function using the line: total = daysOver(dictionaryData, ‘Adelaide’, 40) total will hold the number of days that Adelaide had a temperature greater than 40 celsius in the data. As a test, there were 54 days over 40 celsius in the data. Check that total is 54 for the example when you run your code. b. Use the daysOver function to print the number of days over 35 celsius for each of the following cities: 'Adelaide','Perth','Melbourne','Canberra','Sydney','Brisbane','Darwin' c. Which of the Australian cities has the most number of days over 35 celsius? My spreadsheet looks like this Since I cannot attach an excel file, my excel file name is "weatherAUS.csv"