Write a function that takes three input parameters: ‘mintCalorie’, ‘maxCalorie’, and ‘range’. Assuming that range is a vector of numerical ids, the function will iterate the records print the row if the calorie of the cereal falls in the range ‘minCalorie’ to ‘maxCalorie’. You need to use a ‘for loop’ and ’if statements Test the above function by making at least 10 different function calls.

Write a function that takes three input parameters: ‘mintCalorie’, ‘maxCalorie’, and ‘range’. Assuming that range is a vector of numerical ids, the function will iterate the records print the row if the calorie of the cereal falls in the range ‘minCalorie’ to ‘maxCalorie’. You need to use a ‘for loop’ and ’if statements Test the above function by making at least 10 different function calls.

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter8: Working With Advanced Functions

Section: Chapter Questions

Problem 4.4CP

See similar textbooks

Similar questions

3. Create a stored procedure named spDateRange that accepts two parameters, @DateMin and @DateMax, with data type varchar and default value null. If called with no parameters or with null values, raise an error that describes the problem. If called with non-null values, validate the parameters. Test that the literal strings are valid dates and test that @DateMin is earlier than @DateMax. If the parameters are valid, return a result set that includes the InvoiceNumber, InvoiceDate, InvoiceTotal, and Balance for each invoice for which the InvoiceDate is within the date range, sorted with earliest invoice first.
get_total_cases() takes the a 2D-list (similar to database) and an integer x from this set {0, 1, 2} as input parameters. Here, 0 represents Case_Reported_Date, 1 represents Age_Group and 2 represents Client_Gender (these are the fields on the header row, the integer value represents the index of each of these fields on that row). This function computes the total number of reported cases for each instance of x in the text file, and it stores this information in a dictionary in this form {an_instance_of_x : total_case}. Finally, it returns the dictionary and the total number of all reported cases saved in this dictionary.
Given the 5 records below stored in a file, write a code snippet that will extract two elements (fields) from a single record into two separate variables. Use string functions to identify the delimeter and extract the sub strings. Show the declaration of variables. Mohammed Farook;56 Asiphe Ndokani;75 David Johns;62 Craig Smith;81 Katlhego Ntshidi;45
Write a function called ValidSupplier(SupplierID) that takes as its only input a SupplierID. If the supplier exists in the database your function should return True otherwise it should return False
A user wants to write a C program for manipulating student records. The program contains a function for accessing the student file. The user wants to add some records to the file. Which of the following line of code is used to open the student file for implementing this functionality? Choose an answer A fp = fopen ("studentfile.dat", "r"); B ch = fgetc(fp); C fp = fopen ("studentfile.dat", "w"); D fputc (ch, fp);
in vaccine.txt it search how many vaccine are available. in dist.txt we have to import vaccines likes we have to store data in dist.txt and in vaccine.txt is should read data #include <stdio.h>#include <stdlib.h>#include <string.h> struct vacc{ char vaccName[15]; char vaccCode[2]; char country[15]; int qty; float population; }v[10]; // Function Declarations void create_inventory(); void update_vacc_qty(); int search_vaccine(); void display_vaccine(); // Main Function starts here int main() { //create_inventory(); //display_vaccine(); //search_vaccine(); update_vacc_qty(); return 0; } //Function to Create Vaccine.txt as per the given table void create_inventory() { int option = 1; // variables to collect data as per table given char vaccName[15]; char vaccCode[2]; char country[15]; int qty; float populaion; //File definition FILE *infile; infile = fopen("Vaccine.txt","w"); // file opening for writing if(infile == NULL) // Checking for the file…
Write a function called ValidSupplier(SupplierID) that takes as its only input a SupplierID. If the supplier exists in the database your function should return True otherwise it should return False For example: Test Result print(ValidSupplier(13)) True
10. Write another function called db_consistent that takes a dictionary of dictionariesin the format described in the previous question and returns Trueif and only if every one of the inner dictionaries has exactly the same keys.(This function would return False for the previous example, since RosalindFranklin's entry doesn't contain the 'author' key.)
Answer the given question with a proper explanation and step-by-step solution. For this question use the file data1.csv The file contains information on various customers. Each customer has a unique customer id. The data also has information on age income and Gender of the customers. Space can be used as a delimiter for this file. Find the following: A) The total number of the rows in the file. B) The number of unique customer ids in the datafile. For this question create a set object which will only allow you to add unique customer ids. C) The program asks user to provide an id and prints information about that customer. Make sure to take care for the errors due to invalid id (i.e., id does not present in data). Print “id not found” when id is not found. Save the file as Solution1.java. You can use either File Reader or Scanner classes to read the data in the csv file. Your program should print the following after filling the blanks with the appropriate values Outcome: The total…
In Dist.txt it will add vaccine in storage like how many vaccines are needed and from where is coming and Add search function in which from user it will check how many vaccines are available in storage this will be done in Vaccine.txt somewhat like in image given #include <stdio.h>#include <stdlib.h>#include <string.h> struct vacc{ char vaccName[15]; char vaccCode[2]; char country[15]; int qty; float population; }v[10]; // Function Declarations void create_inventory(); void update_vacc_qty(); int search_vaccine(); void display_vaccine(); // Main Function starts here int main() { //create_inventory(); //display_vaccine(); //search_vaccine(); update_vacc_qty(); return 0; } //Function to Create Vaccine.txt as per the given table void create_inventory() { int option = 1; // variables to collect data as per table given char vaccName[15]; char vaccCode[2]; char country[15]; int qty; float populaion; //File definition FILE *infile; infile = fopen("Vaccine.txt","w");…
Declare a struct Employee with fields Name as C-String, eID as int, Saraly as double (with eID as key). Suppose you have a file Salary.dat which has some number of records in it (of type Employee). Now read a key from user and modify its matching record's name with zahid iqbal
you are required to read input file containing data of countries or region, to compute and display the data in decreasing order, and some statistics in an output file. Structure of input file: The first two lines of input files contains the region information, date of taken data, and heading of the records. Each line of the rest in the input file contains country name, confirmed and death total cases. COVID_19_data class: used to store records from input file. You should provide generic methods to compute average of confirmed cases, to sort list in descending order using selection sortii , and any additional method(s) to solve the problem. Tester Class: your main method should class two methods to read the data and to display the result as shown below. Your class should be user friendly and control any unchecked errors