Description
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
Goes above and beyond expectations!
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
Code and Test Run of Six Weddings and Programming Strategy Used Project
Expand the wedding class to include six weddings. Submit your heavily commented code and a test run of all six weddings. D ...
Code and Test Run of Six Weddings and Programming Strategy Used Project
Expand the wedding class to include six weddings. Submit your heavily commented code and a test run of all six weddings. Describe the programming strategy you used and cite sources.import java.time.*;public class TestWedding{public static void main(String[] args){LocalDate date1 = LocalDate.of(1986, 12, 14);LocalDate date2 = LocalDate.of(1984, 3, 8);LocalDate date3 = LocalDate.of(1991, 4, 17);LocalDate date4 = LocalDate.of(1992, 2, 14);LocalDate date5 = LocalDate.of(2016, 6, 18);LocalDate date6 = LocalDate.of(2016, 6, 25);Person bride1 = new Person("Kimberly", "Hanson", date1); // Create New personPerson groom1 = new Person("Mark", "Ziller", date2); // Create New personPerson bride2 = new Person("Janna", "Howard", date3); // Create New personPerson groom2 = new Person("Julius", "Nemo", date4); // Create New personCouple couple1 = new Couple(bride1, groom1); // Create New coupleCouple couple2 = new Couple(bride2, groom2); // Create New coupleWedding wedding1 = new Wedding(couple1, date5, "Mayfair Country Club");// create a wedding and send it couple1, date5 and a placeWedding wedding2 = new Wedding(couple2, date6, "Oceanview Park");// create a wedding and send it couple1, date5 and a placedisplayWeddingDetails(wedding1); // display wedding1 detailsdisplayWeddingDetails(wedding2); // display wedding2 details}public static void displayWeddingDetails(Wedding w){Couple couple = w.getCouple();LocalDate weddingDate = w.getWeddingDate();String location = w.getLocation();Person bride = couple.getBride();Person groom = couple.getGroom();String firstBride = bride.getFirstName();String lastBride = bride.getLastName();LocalDate brideBDate = bride.getBirthDate();String firstGroom = groom.getFirstName();String lastGroom = groom.getLastName();LocalDate groomBDate = groom.getBirthDate();System.out.println("\n" + lastBride + "/" + lastGroom + " Wedding");System.out.println("Date: " + weddingDate + " Location: " +location);System.out.println("Bride: " + firstBride +" " + lastBride + " " + brideBDate);System.out.println("Groom: " + firstGroom +" " + lastGroom + " " + groomBDate);}}import java.time.*;public class Person{private String firstName;private String lastName;private LocalDate birthDate;public Person(String first, String last, LocalDate date){firstName = first;lastName = last;birthDate = date;}public String getFirstName(){return firstName;}public String getLastName(){return lastName;}public LocalDate getBirthDate(){return birthDate;}}import java.time.*;public class Couple{private Person bride;private Person groom;public Couple(Person br, Person gr) // couple contructor{bride = br;groom = gr;}public Person getBride(){return bride;}public Person getGroom(){return groom;}}import java.time.*;public class Wedding{private Couple couple;private LocalDate weddingDate;private String location;public Wedding(Couple c, LocalDate date, String loc) // wedding constructor{couple = c;weddingDate = date;location = loc;}public Couple getCouple(){return couple;}public LocalDate getWeddingDate(){return weddingDate;}public String getLocation(){return location;}}Submission Details:Create the code and sample run files.
11 pages
Answer Maths Prog
1.NOW Multiply the matrices below using Strassen's algorithm. Write EVERY step of your # Splitting the matrices into quad ...
Answer Maths Prog
1.NOW Multiply the matrices below using Strassen's algorithm. Write EVERY step of your # Splitting the matrices into quadrants. This will be done ...
cow attack
Please check the attachment.. you will find the files that you will work on and please check the last part ( number 4 subm ...
cow attack
Please check the attachment.. you will find the files that you will work on and please check the last part ( number 4 submission). also there is a helpful tips file which tells you how to do it. http://www.cis.syr.edu/~wedu/seed/Labs_12.04/Softw...
ITS 83441 University of the Cumberlands Emerging Cyber Threats Paper
Subject: ITS834 - Emerging Threats & CountermeasuresTopic:For this assignment, review the article:Abomhara, M., & Koien, ...
ITS 83441 University of the Cumberlands Emerging Cyber Threats Paper
Subject: ITS834 - Emerging Threats & CountermeasuresTopic:For this assignment, review the article:Abomhara, M., & Koien, G.M. (2015). Cyber security and the internet of things: Vulnerabilities, threats, intruders, and attacks. Journal of Cyber Security, 4, 65-88. Doi: 10.13052/jcsm2245-1439.414Address the following:What did the authors investigate, and in general how did they do so?Identify the hypothesis or question being testedSummarize the overall article.Identify the conclusions of the authorsIndicate whether or not you think the data support their conclusions/hypothesisConsider alternative explanations for the resultsProvide any additional comments pertaining to other approaches to testing their hypothesis (logical follow-up studies to build on, confirm or refute the conclusions)The relevance or importance of the studyThe appropriateness of the experimental designWhen you write your evaluation, be brief and concise, this is not meant to be an essay but an objective evaluation that one can read very easily and quickly. Also, you should include a complete reference (title, authors, journal, issue, pages) you turn in your evaluation. This is good practice for your literature review, which you’ll be completing during the dissertation process.Your paper should meet the following requirements:Be approximately four to six pages in length, not including the required cover page and reference page.Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.
OSU Remove Certain Elements in Output Results from My Code Computer Coding Task
I have a running and executing code that works but I need to remove certain data from the output file. Furthermore, I need ...
OSU Remove Certain Elements in Output Results from My Code Computer Coding Task
I have a running and executing code that works but I need to remove certain data from the output file. Furthermore, I need another data entered as a header, "DBN", "School Name", "Number of Test Takers", "Critical Reading Mean", "Mathematics Mean", "Writing Mean"
My code will be provided:
import json
class SatData:
def __init__(self):
with open('sat.json', 'r') as f:
self._data = json.load(f)['data']
def save_as_csv(self, dbns):
sat_list = []
for data in self._data:
if data[8] in dbns:
sat_list.append(data)
with open('output.csv', 'w+') as outfile:
header = [str(i) for i in range(len(sat_list[3]))]
outfile.write
for row in sat_list:
sat_info = []
for item in row:
if ',' in str(item):
sat_info.append("\"" + item + "\"")
else:
sat_info.append(str(item))
outfile.write(','.join(sat_info))
outfile.write('\n')
outfile.close()
sd = SatData()
dbns = ["02M303", "02M294", "01M450", "02M418"]
sd.save_as_csv(dbns)
For this project, you will import the json module.
Write a class named SatData that reads a JSON file containing data on 2010 SAT results for New York City and writes the data to a text file in CSV format (CSV is a vendor-neutral format for spreadsheets, which uses commas to separate values). Your class just needs to read a local JSON file - it doesn't need to access the internet. Specifically, your class should have an init method that reads the file, and it should have a method named save_as_csv that takes as a parameter a list of DBNs (district bureau numbers) and saves a CSV file that looks like this, but with only the rows corresponding to the DBNs in the list (and also the row of column headers). Open the file as a text file rather than as a spreadsheet, so that you can see the CSV syntax. You may assume that all of the DBNs in the list passed to your method are all present in the JSON file. The rows in the CSV file must be sorted in ascending order by DBN. The name of the file must be output.csv. There is a csv module for Python, but you will not use it for this project. CSV is a very simple format - just commas separating columns and newlines separating rows (see note below about commas in field names). The JSON file will be named sat.json and will be provided - you do not need to submit it. Any data members of the SatData class must be private.
For example, your class could be used like this:
sd = SatData()
dbns = ["02M303", "02M294", "01M450", "02M418"]
sd.save_as_csv(dbns)
You may hardcode the column headers.
Some of the school names contain one or more commas. How should you preserve such a name as a single field in CSV format, since commas normally separate fields? The correct way to handle that is to enclose such names in double quotes in your CSV file. If you open up the example CSV file in a text editor, you can see that's what it does.
The file must be named: SatData.py
mySQL Worksheet
***Login information and student schema will be given***In this lab, you will learn how to write Advanced queries using Ag ...
mySQL Worksheet
***Login information and student schema will be given***In this lab, you will learn how to write Advanced queries using Aggregate Functions and Table Joins. You will write 10 SQL SELECT statements to query the STUDENT schema. Your Select Statements should run error-free and should be valid.Submit two separate files: one plain text file (.txt or .sql file) with your SELECT statements only; and the other document (doc/docx/pdf) include both your SELECT statements and your query results (copy and paste text or screen shots). The instructor and TA should be able to run your plain text source file as script and generate the same output as shown in your result document.Q1. List all courses that have "Intro to Information Systems" as prerequisite. (HINT: use a subquery)Q2. List all courses with above average cost. Display course description, cost, and the average cost of all courses. (HINT: use a subquery)Q3. For each zip that has at least one instructor, list the total number of instructors in that zipcode.Q4. For each city in the state of CT, list the total number of students live in that city. Display city, state, number of students in descending order.-- AGGREGATION OF FULL RESULT SETQ5. Find the minimum, maximum, and average grade of final exams in sections taught by Todd Smythe.Q6: For all students who took "Intro to Information Systems", calculate the highest, lowest, and average midterm exam grade for each section. Display Section No and calculation results.-- TABLE JOIN WITH HAVING-CLAUSEQ7. List the instructor id and name of the instructors that teach fewer than 10 sections regardless of student enrollment.Q8. Show which city has the most students. Display city and state, and number of students.Q9: List all zipcodes where at least three students AND at least four instructor reside. Show zip, state and city.Q10: List all cities that have 10 or more students and instructor combined. Show city, state, number of student residents, number of instructor residents, and total student/instructor residents in that city. Sort by total in descending order. Learning Resourceshttps://www.w3schools.com/sql/sql_join.asphttps://docs.oracle.com/database/121/SQLRF/functions.htm#SQLRF006
Similar Content
5 questions regarding databese
there are five questions that i need to answer.Please check the attached screen shot for the questions.The paper should be...
ABC Rentals implementation Project
Lab 4
COMP 121
Purpose
To assess your ability to apply the knowledge and skills developed in Modules 8, 9, 10, and 11.
E...
High Performance SQL Databases Distributed Systems Non Relational Paper
For this week you will be writing a two pages APA format paper that analyzes the difference between traditional SQL and No...
CMIS 102 University of Maryland Programming Test Report for Valid Password Program Worksheet
The fifth assignment involves writing a Python program to determine whether a password meets all the requirements for a se...
computer science assignment
you will write a club recommendation system for a social network. Based onthe scoring system described below, your program...
Database Management & Applications Speadsheet
Create a sheet in excel or sheets to identify tables that you would create to break down a seperation of what the tables s...
Antipattern In Software Project Management And Impacts On
❖ Antipattern refers to designs that are witnessed in software development that often introduces problems than the way t...
2 Peer Responsesssss.edited
From the peer’s post, I learned about formal software development, what the software is expected to do as well as docume...
Css Assignment 23
General instructions - please use bullet points to answer the questions, and make sure that 1. Explain the basic functiona...
Related Tags
Book Guides
The Catcher in the Rye
by J. D. Salinger
Dead Poets Society
by Nancy Horowitz Kleinbaum
Dr Jekyll And Mr Hyde
by Robert Louis Stevenson
The Two Towers
by J. R. R. Tolkien
The Good Earth
by Pearl S. Buck
Catching Fire
by Suzanne Collins
Moby Dick
by Herman Melville
Hiroshima
by John Hersey
Oliver Twist
by Charles Dickens
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
Code and Test Run of Six Weddings and Programming Strategy Used Project
Expand the wedding class to include six weddings. Submit your heavily commented code and a test run of all six weddings. D ...
Code and Test Run of Six Weddings and Programming Strategy Used Project
Expand the wedding class to include six weddings. Submit your heavily commented code and a test run of all six weddings. Describe the programming strategy you used and cite sources.import java.time.*;public class TestWedding{public static void main(String[] args){LocalDate date1 = LocalDate.of(1986, 12, 14);LocalDate date2 = LocalDate.of(1984, 3, 8);LocalDate date3 = LocalDate.of(1991, 4, 17);LocalDate date4 = LocalDate.of(1992, 2, 14);LocalDate date5 = LocalDate.of(2016, 6, 18);LocalDate date6 = LocalDate.of(2016, 6, 25);Person bride1 = new Person("Kimberly", "Hanson", date1); // Create New personPerson groom1 = new Person("Mark", "Ziller", date2); // Create New personPerson bride2 = new Person("Janna", "Howard", date3); // Create New personPerson groom2 = new Person("Julius", "Nemo", date4); // Create New personCouple couple1 = new Couple(bride1, groom1); // Create New coupleCouple couple2 = new Couple(bride2, groom2); // Create New coupleWedding wedding1 = new Wedding(couple1, date5, "Mayfair Country Club");// create a wedding and send it couple1, date5 and a placeWedding wedding2 = new Wedding(couple2, date6, "Oceanview Park");// create a wedding and send it couple1, date5 and a placedisplayWeddingDetails(wedding1); // display wedding1 detailsdisplayWeddingDetails(wedding2); // display wedding2 details}public static void displayWeddingDetails(Wedding w){Couple couple = w.getCouple();LocalDate weddingDate = w.getWeddingDate();String location = w.getLocation();Person bride = couple.getBride();Person groom = couple.getGroom();String firstBride = bride.getFirstName();String lastBride = bride.getLastName();LocalDate brideBDate = bride.getBirthDate();String firstGroom = groom.getFirstName();String lastGroom = groom.getLastName();LocalDate groomBDate = groom.getBirthDate();System.out.println("\n" + lastBride + "/" + lastGroom + " Wedding");System.out.println("Date: " + weddingDate + " Location: " +location);System.out.println("Bride: " + firstBride +" " + lastBride + " " + brideBDate);System.out.println("Groom: " + firstGroom +" " + lastGroom + " " + groomBDate);}}import java.time.*;public class Person{private String firstName;private String lastName;private LocalDate birthDate;public Person(String first, String last, LocalDate date){firstName = first;lastName = last;birthDate = date;}public String getFirstName(){return firstName;}public String getLastName(){return lastName;}public LocalDate getBirthDate(){return birthDate;}}import java.time.*;public class Couple{private Person bride;private Person groom;public Couple(Person br, Person gr) // couple contructor{bride = br;groom = gr;}public Person getBride(){return bride;}public Person getGroom(){return groom;}}import java.time.*;public class Wedding{private Couple couple;private LocalDate weddingDate;private String location;public Wedding(Couple c, LocalDate date, String loc) // wedding constructor{couple = c;weddingDate = date;location = loc;}public Couple getCouple(){return couple;}public LocalDate getWeddingDate(){return weddingDate;}public String getLocation(){return location;}}Submission Details:Create the code and sample run files.
11 pages
Answer Maths Prog
1.NOW Multiply the matrices below using Strassen's algorithm. Write EVERY step of your # Splitting the matrices into quad ...
Answer Maths Prog
1.NOW Multiply the matrices below using Strassen's algorithm. Write EVERY step of your # Splitting the matrices into quadrants. This will be done ...
cow attack
Please check the attachment.. you will find the files that you will work on and please check the last part ( number 4 subm ...
cow attack
Please check the attachment.. you will find the files that you will work on and please check the last part ( number 4 submission). also there is a helpful tips file which tells you how to do it. http://www.cis.syr.edu/~wedu/seed/Labs_12.04/Softw...
ITS 83441 University of the Cumberlands Emerging Cyber Threats Paper
Subject: ITS834 - Emerging Threats & CountermeasuresTopic:For this assignment, review the article:Abomhara, M., & Koien, ...
ITS 83441 University of the Cumberlands Emerging Cyber Threats Paper
Subject: ITS834 - Emerging Threats & CountermeasuresTopic:For this assignment, review the article:Abomhara, M., & Koien, G.M. (2015). Cyber security and the internet of things: Vulnerabilities, threats, intruders, and attacks. Journal of Cyber Security, 4, 65-88. Doi: 10.13052/jcsm2245-1439.414Address the following:What did the authors investigate, and in general how did they do so?Identify the hypothesis or question being testedSummarize the overall article.Identify the conclusions of the authorsIndicate whether or not you think the data support their conclusions/hypothesisConsider alternative explanations for the resultsProvide any additional comments pertaining to other approaches to testing their hypothesis (logical follow-up studies to build on, confirm or refute the conclusions)The relevance or importance of the studyThe appropriateness of the experimental designWhen you write your evaluation, be brief and concise, this is not meant to be an essay but an objective evaluation that one can read very easily and quickly. Also, you should include a complete reference (title, authors, journal, issue, pages) you turn in your evaluation. This is good practice for your literature review, which you’ll be completing during the dissertation process.Your paper should meet the following requirements:Be approximately four to six pages in length, not including the required cover page and reference page.Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.Support your answers with the readings from the course and at least two scholarly journal articles to support your positions, claims, and observations, in addition to your textbook. The UC Library is a great place to find resources.Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing.
OSU Remove Certain Elements in Output Results from My Code Computer Coding Task
I have a running and executing code that works but I need to remove certain data from the output file. Furthermore, I need ...
OSU Remove Certain Elements in Output Results from My Code Computer Coding Task
I have a running and executing code that works but I need to remove certain data from the output file. Furthermore, I need another data entered as a header, "DBN", "School Name", "Number of Test Takers", "Critical Reading Mean", "Mathematics Mean", "Writing Mean"
My code will be provided:
import json
class SatData:
def __init__(self):
with open('sat.json', 'r') as f:
self._data = json.load(f)['data']
def save_as_csv(self, dbns):
sat_list = []
for data in self._data:
if data[8] in dbns:
sat_list.append(data)
with open('output.csv', 'w+') as outfile:
header = [str(i) for i in range(len(sat_list[3]))]
outfile.write
for row in sat_list:
sat_info = []
for item in row:
if ',' in str(item):
sat_info.append("\"" + item + "\"")
else:
sat_info.append(str(item))
outfile.write(','.join(sat_info))
outfile.write('\n')
outfile.close()
sd = SatData()
dbns = ["02M303", "02M294", "01M450", "02M418"]
sd.save_as_csv(dbns)
For this project, you will import the json module.
Write a class named SatData that reads a JSON file containing data on 2010 SAT results for New York City and writes the data to a text file in CSV format (CSV is a vendor-neutral format for spreadsheets, which uses commas to separate values). Your class just needs to read a local JSON file - it doesn't need to access the internet. Specifically, your class should have an init method that reads the file, and it should have a method named save_as_csv that takes as a parameter a list of DBNs (district bureau numbers) and saves a CSV file that looks like this, but with only the rows corresponding to the DBNs in the list (and also the row of column headers). Open the file as a text file rather than as a spreadsheet, so that you can see the CSV syntax. You may assume that all of the DBNs in the list passed to your method are all present in the JSON file. The rows in the CSV file must be sorted in ascending order by DBN. The name of the file must be output.csv. There is a csv module for Python, but you will not use it for this project. CSV is a very simple format - just commas separating columns and newlines separating rows (see note below about commas in field names). The JSON file will be named sat.json and will be provided - you do not need to submit it. Any data members of the SatData class must be private.
For example, your class could be used like this:
sd = SatData()
dbns = ["02M303", "02M294", "01M450", "02M418"]
sd.save_as_csv(dbns)
You may hardcode the column headers.
Some of the school names contain one or more commas. How should you preserve such a name as a single field in CSV format, since commas normally separate fields? The correct way to handle that is to enclose such names in double quotes in your CSV file. If you open up the example CSV file in a text editor, you can see that's what it does.
The file must be named: SatData.py
mySQL Worksheet
***Login information and student schema will be given***In this lab, you will learn how to write Advanced queries using Ag ...
mySQL Worksheet
***Login information and student schema will be given***In this lab, you will learn how to write Advanced queries using Aggregate Functions and Table Joins. You will write 10 SQL SELECT statements to query the STUDENT schema. Your Select Statements should run error-free and should be valid.Submit two separate files: one plain text file (.txt or .sql file) with your SELECT statements only; and the other document (doc/docx/pdf) include both your SELECT statements and your query results (copy and paste text or screen shots). The instructor and TA should be able to run your plain text source file as script and generate the same output as shown in your result document.Q1. List all courses that have "Intro to Information Systems" as prerequisite. (HINT: use a subquery)Q2. List all courses with above average cost. Display course description, cost, and the average cost of all courses. (HINT: use a subquery)Q3. For each zip that has at least one instructor, list the total number of instructors in that zipcode.Q4. For each city in the state of CT, list the total number of students live in that city. Display city, state, number of students in descending order.-- AGGREGATION OF FULL RESULT SETQ5. Find the minimum, maximum, and average grade of final exams in sections taught by Todd Smythe.Q6: For all students who took "Intro to Information Systems", calculate the highest, lowest, and average midterm exam grade for each section. Display Section No and calculation results.-- TABLE JOIN WITH HAVING-CLAUSEQ7. List the instructor id and name of the instructors that teach fewer than 10 sections regardless of student enrollment.Q8. Show which city has the most students. Display city and state, and number of students.Q9: List all zipcodes where at least three students AND at least four instructor reside. Show zip, state and city.Q10: List all cities that have 10 or more students and instructor combined. Show city, state, number of student residents, number of instructor residents, and total student/instructor residents in that city. Sort by total in descending order. Learning Resourceshttps://www.w3schools.com/sql/sql_join.asphttps://docs.oracle.com/database/121/SQLRF/functions.htm#SQLRF006
Earn money selling
your Study Documents