
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
In python
>>> build_csv_string([["Sam", "Lab 01", 5.4]])
'name,assignment,grade\nSam,Lab 01,5.4'
>>> build_csv_string([["Sam", "Lab 01", 5.4], ["Zoe"]])
'name,assignment,grade\nSam,Lab 01,5.4\nZoe,N/A,0'
>>> build_csv_string([["Sam", "Lab 01", 5.4], ["Zoe"], ["Amanda", "Quiz 04", 100]])
'name,assignment,grade\nSam,Lab 01,5.4\nZoe,N/A,0\nAmanda,Quiz 04,100'

Transcribed Image Text:Write a function build_csv_string(data) that takes
in a list data. data will be a list of lists, where each
sub list is of length 1, 2, or 3.
●
Length 1 lists will contain a name (as a string).
Length 2 lists will contain a name and an
assignment title (as a string).
● Length 3 lists will contain a name, an assignment
title, and a score (as a float or int).
The function should return a valid csv string where
each sublist is a record in the string. The header (first
line) of the csv file should be 'name, assignment,
grade\n'. Lists missing a grade value should use as
the default, and missing assignment titles should be
defaulted to 'N/A'
Expert Solution

arrow_forward
Step 1
Code
Step by stepSolved in 2 steps with 3 images

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- A declared name is only valid within a region of code known as the name's scope. Example: A variable “globalVar_1” declared in main() is only valid within main(), from the declaration to main()'s end. True or falsearrow_forwardI need help with this one please, already tried but still getting a wrong answer Scenario You have been tasked with building a URL file validator for a web crawler. A web crawler is an application that fetches a web page, extracts the URLs present in that page, and then recursively fetches new pages using the extracted URLs. The end goal of a web crawler is to collect text data, images, or other resources present in order to validate resource URLs or hyperlinks on a page. URL validators can be useful to validate if the extracted URL is a valid resource to fetch. In this scenario, you will build a URL validator that checks for supported protocols and file types. Task Create two lists of strings – one list for Protocol called valid_protocols, and one list for storing File extension called valid_fileinfo. For this take the protocol list should be restricted to http, https and ftp. The file extension list should be .html, .csv and .docx. Split an input named url, and then use the first…arrow_forwardASP.NET MVC C# VS 2019Can you please help me with the syntax error? I was trying to display the calendar on the top of the page but I made an error. @model List<AdventureDB.Models.CalendarItem> @using System@using System.Web.Mvc @{var weeks = (int)Math.Ceiling((double)(Model.Count + 13) / 7);var startDate = Model.Count > 0 ? Model[0].Date : DateTime.Today; var endDate = startDate.AddYears(4);} @using (Html.BeginForm("Index", "Home", FormMethod.Get)){<label for="startDate">Training Start Date:</label><input type="date" id="startDate" name="startDate" /><input type="submit" value="Submit" />} @model IEnumerable<AdventureDB.Models.Training_Program>@using AdventureDB.Models@{// Create an instance of the data contextvar dbIEFW = new IEFWResourceDataContext();var dbIFE = new IFEResourcesDataContext();var dbREF = new REFDataContext();var dbAQC = new AQCDataContext();var dbAQCUSAF = new AQCUSAFDataContext();var dbIPC = new IPCDataContext();var dbIFTR =…arrow_forward
- Filename: runlength_decoder.py Starter code for data: hw4data.py Download hw4data.py Download hw4data.pyYou must provide a function named decode() that takes a list of RLE-encoded values as its single parameter, and returns a list containing the decoded values with the “runs” expanded. If we were to use Python annotations, the function signature would look similar to this:def decode(data : list) -> list: Run-length encoding (RLE) is a simple, “lossless” compression scheme in which “runs” of data. The same value in consecutive data elements are stored as a single occurrence of the data value, and a count of occurrences for the run. For example, using Python lists, the initial list: [‘P’,‘P’,‘P’,‘P’,‘P’,‘Y’,‘Y’,‘Y’,‘P’,‘G’,‘G’] would be encoded as: ['P', 5, 'Y', 3, ‘P’, 1, ‘G’, 2] So, instead of using 11 “units” of space (if we consider the space for a character/int 1 unit), we only use 8 “units”. In this small example, we don’t achieve much of a savings (and indeed the…arrow_forwardNEED HELP DEBUGGING THE FOLLOW JS CODE JS CODE /* JavaScript 7th Edition Chapter 3 Project 03-05 Application to generate a horizontal bar chart Author: Date: Filename: project03-05.js*/ // Array of phone models sold by the companylet phones = ("Photon 6E", "Photon 6X", "Photon 7E", "Photon 7X", "Photon 8P"); // Units sold in the previous quarterlet sales = (10281, 12255, 25718, 21403, 16142); // Variable to calculate total saleslet totalSales = 0; // Use the forEach() method to sum the sales for each phone model and add it to the totalSales variablesales.forEach(addtoTotal); // For loop to generate bar chart of phone salesfor (let i = 1; i <= phones.length; i++) { let barChart = ""; // Variable to store HTML code for table cells used to create bar chart // Calculate the percent of total sales for a particular phone model let barPercent = 100*sales/totalSales; let cellTag; // Variable that will define the class of td…arrow_forwardCreate a C++ program containing a deque container that possesses the unique property of expanding at both its front and back ends. Initially, the deque holds the elements (2, 3, 4). Modify the program to include values 1 and 5, inserting 1 at the front and 5 at the back. Consequently, when the program is executed, the deque container should exhibit the values (1, 2, 3, 4, 5).arrow_forward
- Expected Output: A) Success Case: B) Failure Case: Enter details of 1 Employee Enter Employee Id : 11 Enter details of 1 Employee Enter Employee Id : 101 Enter Employee Name : John Mathew Enter Enployee Name : KS Enter Employee Age : 23 Enter Enployee Age : 34 Enter Employee Salary : 6787.89 Enter Employee Salary : 2345.6 Enter details of 2 Enployee Enter Employee Id : 201 Enter details of 2 Employee Enter Enployee Id : 12 Enter Employee Name : Harry Bajwa Enter Employee Age : 34 Enter Enployee Name : WR Enter Employee Salary : 8765.43 Enter details of 3 Employee Enter Employee Id : 301 Enter Enployee Age : 35 Enter Employee Salary : 5678.99 Enter Employee Name : Sana Murshid Enter details of 3 Employee Enter Enployee Id : 13 Enter Employee Age : 25 Enter Employee Salary : 6784.34 Details of Employees (Original Data) Id Enter Employee Name : RT Name Age Salary Enter Enployee Age : 45 101 201 301 John Mathew 23 6787.89 Наггy Bajна Sana Murshid 34 8765.43 Enter Enployee Salary : 8974.35…arrow_forwardPythonarrow_forwardplease help fix the following Scenario: Your team is working with data where dates are caputred as a string, "9/15/2019". You are tasked to create a python function named 'mdy_date' that will accept a string input, convert it to a python datetime object, and return the datetime object. Create the function in the cell below.arrow_forward
- Write a Ruby program named format file.rb, which can be run by typing ruby widgets.rb. In your Ruby environment, the program must read an input file formatted in CSV format, named input.csv. Each record contains data about a student and their corresponding grades. The data will look similar to the following: Student Name, assignment 1, assignment 2, assignment 3, assignment 4 John Adams, 90, 91, 99, 98 Paul Newman, 90, 92, 93, 94 Mary Smith, 95, 96, 99 Be careful to follow the output format exactly, including spacing. The output of your program must look like the following: Student Assignment Average John Adams 94.5arrow_forwardin java Defining a local variable with the same name as a data field is known as?arrow_forwardCreate a new C++ project in Visual Studio (or an IDE of your choice). Add the files listed below to your project: BinaryTree.h Download BinaryTree.h BinarySearchTree.h Download BinarySearchTree.h main.cpp Download main.cpp Build and run your project. The program should compile without any errors. Note that function main() creates a new BST of int and inserts the nodes 12, 38, 25, 5, 15, 8, 55 (in that order) and displays them using pre-order traversal. Verify that the insertions are done correctly. You may verify it manually or use the visualization tool at https://www.cs.usfca.edu/~galles/visualization/BST.html. (Links to an external site.) Do the following: 1. add code to test the deleteNode and search member functions. Save screenshot of your test program run. 2. add code to implement the nodeCount member function of class BinaryTree. Test it and save screenshot of your test program run. 3. add code to implement the leafCount member function of class BinaryTree. Test it and…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education

Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON

Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON

C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON

Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning

Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education