class7exercise
.pdf
keyboard_arrow_up
School
New York University *
*We aren’t endorsed by this school
Course
0232
Subject
Computer Science
Date
Dec 6, 2023
Type
Pages
1
Uploaded by BarristerResolve12942
1
measuring artificial intelligence discussion in earnings calls
On Brightspace, the zip file tech_earnings_call_transcripts.zip contains six “JSON” files containing
earnings calls information for recent earnings calls of the six tech companies we have studied. Download
it and unzip it into a folder on your computer. (Here is an example one of these earnings calls in video
format:
https://www.microsoft.com/en-us/Investor/events/FY-2023/earnings-fy-2023-q4.aspx
.)
The following code uses the package “json” to load one of the json files into an object called “json_data”
(you may need an os.chdir() prior to this code to move into the directory containing the .json files).
import json
file = open('transcript_id__2795186.json', 'r')
json_data = json.load(file)
file.close()
1.
Run the above code to load one of the earnings call transcripts. What’s the type of the json_data
object? Once you know the json_data object’s type, play around with it in order to figure out how it
is structured (“dumping it to the console” prints it out fairly readably, for example). In particular,
figure out where the text that people say is stored in the object (hint: if you are struck, try
type(json_data['components'])
, and
type(json_data['components'][0])
).
2.
For each of these six earnings calls, I want two measures: (1) how often did they talk about Artificial
Intelligence in the 'Presenter Speech'?, and (2) how often did they talk about Artificial Intelligence in
the other dialogue (the questions and answers)? Your code should create three lists (or arrays): a list
of company names, a list of measures for my first question, and a list of measures for my second
question. The lists should line up (so the first elements of each list correspond, second elements
correspond, etc.). To accomplish this:
a.
After loading an earnings call, use a for loop to create two variables of text:
presenterSpeechesBlob and questionsAndAnswersBlob. The for loop should concatenate the
spoken text to the first variable (blob of text) using + if it’s a presenter speech, otherwise,
concatenate to the second using +. Then you can analyze these blobs of text as strings.
b.
To loop over the json files, consider using:
json_files = [pos_json for pos_json
in os.listdir('./') if pos_json.endswith('.json')]
c.
Then write code to use these two variables containing strings of text to construct the desired
numeric measures. To do this:
-
The python string method “.contains()” counts the number of times the string contains a substring.
For example, try
"hi hi hey".contains("hi")
-
Some substrings that indicate “talk about AI” include “AI”, “Artificial Intelligence”, “OpenAI”,
“ChatGPT”, “Large Language”. Feel free to use these or come up with your own. Also feel free to
apply any weights you think appropriate (maybe you think mention of OpenAI should count more
than just AI?).
-
You’ll need to normalize your measure by the length of the blob of text, otherwise, longer text will
have more speech about AI, but this might just be because of the length of the text. One trick is to
use the
contains
method to count the number of spaces in the text. The number of spaces is
approximately the number of words, and so is a good denominator to normalize your measure by.
3.
For which companies is your Question & Answer index bigger than your Presenter Speech index?
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
This section has a total of 6 questions.
Upload all scanned documents/files/ compressed folder in the linH
the end of Question 26.
Use the expression F = ((AC) +B') (C Đ A O B) to draw the Truth Table.
A -
I
Use the upload link after Question 26 to upload the answer. (image, word, pdf, or any
practical files)
استخدم رابط التحميل بعد السؤال 26 لتحميل الإجابة. )صورة، كلمة، pdf، او الملفات العملية(
H Dacimal pumbers with necessary steps.
arrow_forward
PHP
According to table the in the image
(Build a file to link to your database and give it the file name config.php)
(Build a file to display matrixnum, name from students table, subject_code and sub_name from subjects table and total_marks, grade from assessment table.)
Build code using javascript, to calculate total_marks and determine grade. Where total_marks are calculated by adding quiz, assignment and project and divided by 3. Where the value range of each quiz, assignment and project is 0 to 100. Next the grade will be determined based on the grading system (refer to the grading table)
arrow_forward
AutoSave O ff
INT201_0OP_Lab7_2020-2 - Protected View - Saved to this PC -
Search
Anass Alhami
File
Home
Insert
Draw
Design
Layout
References
Mailings
Review
View
Help
A Share
O Comments
PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.
Enable Editing
Lab 7- Exercises
Consider the following class hierarchy:
Person
-name:String
-address:String
+Person(name:String, address:String)
+getName ():String
+getAddress():String
+setAddress(address:String):void
+printlnfo (): void
"name (address)"
Student
Teacher
-numCourses:int = 0
-numCourses:int = 0
-courses:String[] = {}
-grades:int[] = {}
-courses:String[] = {}
+Student (name:String,
address:String)
+addCourseGrade(course:String,
grade:int):void
+printGrades (): void
+getAverageGrade(): double
+printInfo ():void
+Teacher (name:String,
address:String)
+addCourse(course:String):boolean
+removeCourse(course:String):boolean
+printInfo (): void
Return false if the…
arrow_forward
Start Excel. Open the downloaded file named Excel_Ch10_PS2_Float.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.
0
2
The company would like to determine the number of customers it should book per day in order to break even. They would like to analyze this using a break-even analysis.On the Break-Even Analysis worksheet, enter the correct formula to calculate the Gross Revenue in cell D7.
5
3
Enter the correct formula to calculate the Total Fixed Costs in D13.
5
4
In cell D17 enter the correct formula to calculate the Total Variable Costs based upon the average number of guests per day and the days of operations per year.
5
5
Enter the correct formula to calculate the Net Income in D18.
5
6
Management thinks an average of 85 guests a day would be a realistic average. Use Goal Seek to find out what the price would need to be to come out exactly even with 85 guests per day and…
arrow_forward
CPE162_exer3_6 [Read-Only] [Compatibility Mode] - Word
Ace Jan C. Lape
File
Home
Insert
Design
Layout
References
Mailings
Review
View
Help
O Tell me what you want to do
& Share
X Cut
P Find -
Arial
- 11
A A Aa -
AaBbCc AAB6CCL AaBbC AaBbCc[ AaBbCcl AaBbCcD
akc Replace
A Select -
EE Copy
BI U
Paste
- abe x, x A- aly , A
1 Caption
Emphasis Heading 1 1 Normal
Strong
Subtitle
-
Format Painter
Clipboard
Font
Paragraph
Styles
Editing
Computer Engineering Department
Laboratory Activity Form
Course Number
ES 085
Course Title
Computer Programming 2
Topics Covered:
Array
Implement a program using the single-subscripted array and its
operations with emphasis on the creation of programmer-defined data
types and the use of separate files for the definition - .h, implementation -
.c and client code - .c.
Objectives:
Description
Airline Reservation System
A small airline has just purchased a computer for its new automated reservations system. The
president has asked you to program the new system. You…
arrow_forward
Ass
arrow_forward
. Create an anonymous block that returns the number of students in a section. Prompt for section id.Name the file
Create an anonymous block that return the average numeric grade for a section. Prompt for sectionid and return the average grade.
Complete the following:• Create a view called gl_stdV1 that returns the required data• Create an anonymous block that:o Accesses gl_stdV1o Uses the %ROWTYPE attribute to define a record structure for the view datao Prompts for student number and section ido Output the required information
• Create an anonymous block that inserts new rows into the gl_professors_copy table• Declare variables using the %ROWTYPE and %TYPE attributes• Use bind/host variables to prompt for the input data• Allow for mixed case when entering the school code• Allow for mixed case when entering the first and last names and format names with firstcharacter in upper case and the remaining character in lower case• Include an INSERT statement in the execution section that…
arrow_forward
Assignment
Create a well-formed valid XML file that contains this
information. The information does not have to be
correct only your name needs to be correct, you can
make up all other information. Then, create the proper
XSLT file to load that XML data and display it. When
displaying it, make sure you're using:
• Different font colors
• Tables
• header tags ( ...)
• Images where the image name is read from the
XML file
The information you must include:
• Name
• My Picture (this is an image file name. For
example: loay.jpg, or myphoto.jpg
• Address
o Street number
o City
o State
o Zipcode
• Movies I like
o Title
o Release Date
arrow_forward
Calculating baseball statistics in a file 5 points The Lahman Baseball Database is a comprehensive database of Major League
baseball statistics. The journalist Sean Lahman provides all of this data freely to the public. We will make use of some of his data in
this assignment. If you would like to learn more about the database, you can visit his website. We provide you with a CSV file
named batting.csv that contains the annual batting performance data for all Major League Baseball players dating back to the year
1871. The first row in the file is a header indicating what data is stored in each column of the file. For example, column 12 is labeled
"HR" and contains the number of home runs the player hit that year. Each of the next 99,846 lines contains a comma separated list
of the data for that player and year. For example, the fifth line in the file indicates that a player with the ID allisdo01 hit 2 home runs
in 1871. You should download batting.csv and place it in the same directory…
arrow_forward
Computer Science
Import data from anywhere by using Web Scraper and save data in a .csv file. By using google meet/Zoom/any media, record you’re your entire process with your voice. Preserve the recorded file, .csv file in the same folder where you have preserved the excel file for other questions. Rename the recorded file name with your ID and question number. Don’t forget to upload the .csv file. File name should be Your_ID_Question_number.csv.
arrow_forward
16-7. Automated Title: In eq_world_map_3.py, we specified the title manually when defining my_layout, which means we have to remember to update the title every time the source file changes. Instead, you can use the title for the data set in the metadata part of the JSON file. Pull this value, assign it to a variable, and use this for the title of the map when you’re defining my_layout.
arrow_forward
• Assignment to be completed on an individual basis.
• Open a new word document
Save as 60#######-Assignment 1
• Save as a word document any other format will not
be marked.
•
Answers are to be in complete sentences.
Turnitin® will be applied to all uploads to the
"Dropbox" of D2L.
• Each short answer question should have a minimum
of 250 words.
. All citations must be in APA Format o If your paper
does not contain any citations, your assignment will
receive a grade of '0'
• Assignment is to include a Cover Page, Table of
Contents, Body and Reference Page.
• Minimum of one external (NOT class PowerPoints)
reference per answer. You can also use class
PowerPoints to support your answers but you must
reference them.
Pa
F-
al
0
Part B Word Processing
Re-
PIC
Question 1
question 1
Discuss the history & evolution of Word Processing.
Hala ba
arrow_forward
Which Pandas function do you use to import data from a comma-separated value(CSV) file into a Pandas DataFrame?
read_csv()
read_todf()
read_datafile()
What are arff files in WEKA?
Association-Relation File Format (ARFF)
Attribute-Relation File Format (ARFF)
Attribute-Relationship File Format (ARFF)
Attribute-Relation FileExtension Format (ARFF)
What is generalisation?
a. Refers to the model's ability to adapt properly to new, previously unseen data
b. To produce reasonable outputs for inputs not encountered during the training
c. The built model works only for the specific data
b and c
a and c
a and b
Which of the following statements will import pandas?
import pandaspy as pd
import panda as py
import pandas as pd
All of the above
arrow_forward
4_6008298641649830002.doc [Compatibility Mode] - Word
Table Tools
Sign in
File
Home
Insert
Design
Layout
References
Mailings
Review
View
Help
Design
Layout
O Tell me what you want to do
& Share
X Cut
P Find -
Times New Ro
12
- A A Aa -
AaBbCcl AABBC AaBbC AaBbCc AaBbCcI AaBbCc]
ab. Replace
A Select
B Copy
Paste
BIU - abe x, x A - aly , A -
Emphasis T Heading 1 T Heading 2 T Heading 3 1 Normal
Strong
Format Painter
Clipboard
Font
Paragraph
Styles
Editing
secona semester - 2020/ZI
Injormanon 1есппогogy
Department of IT
Field of Study: General
VERSITE
Tuesday 06/04/2021
اسم الطالبارة
Midterm Exam
رقم الطالبارة
Question Paper
FIRST QUESTION:
An embassy records details of interviews of visa applicants in the table below. Interviews are
conducted by members of staff in some of the embassy rooms. In any given day, a member of
staff tends to use the same room throughout that day. An applicant cannot have two interviews in
the same day:
+ R:
applicant No
interview Date
interview Time
staff No…
arrow_forward
Instructions:
• Assignment to be completed on an individual basis.
• Open a new word document
Save as 60#######-Assignment 1
•
Save as a word document any other format will not
be marked.
• Answers are to be in complete sentences.
Turnitin® will be applied to all uploads to the
"Dropbox" of D2L.
• Each short answer question should have a minimum
of 250 words.
• All citations must be in APA Formato If your paper
does not contain any citations, your assignment will
receive a grade of '0'
• Assignment is to include a Cover Page, Table of
Contents, Body and Reference Page.
• Minimum of one external (NOT class PowerPoints)
reference per answer. You can also use class
PowerPoints to support your answers but you must
reference them.
T
P
Part B - Word Processing
Br
F
Research and discuss two advanced word processing features NOT covered in class that can
be used to increase productivity. Explain how they would help someone be able to do more
work.
CHEE AN
Question 2
arrow_forward
Ubunto please
arrow_forward
Downloads/
assum_sec X
+
English
localhost:8888/notebooks/Downloads/21201491_Nuzhat%20Tabassum_sec-17_CSE110_assignment-06.ipynb
C jupyter 21201491_Nuzhat Tabassum_sec-17_CSE110_assignment-06 Last Checkpoint: 8 hours ago (unsaved changes)
Logout
File
Edit
View
Insert
Cell
Kernel
Widgets
Help
Trusted
Python 3 O
+
> Run
Code
print(rem_duplicate(('Hi',1,2,3,3, 'Hi','a','a',[1,2])))
("Hi', 1, 2, 3, 'а', [1, 2])
Task 12
Write a python function that takes a list as an argument. Your task is to create a new list where each element can be present at max 2 times. Inside the
function, print the number of elements removed from the given list. Finally, return the new list and print the result.
========:
=======
Hint: You may use list_name.count(element) to count the total number of times an element is in a list. list_name is your new list for this problem.
Function Call:
function_name([1, 2, 3, 3, 3, 3, 4, 5, 8, 8])
Output:
Removed: 2
[1, 2, 3, 3, 4, 5, 8, 8]
Function Call:
function_name([10, 10,…
arrow_forward
Downloads/
assum_sec X
+
English
localhost:8888/notebooks/Downloads/21201491_Nuzhat%20Tabassum_sec-17_CSE110_assignment-06.ipynb
C jupyter 21201491_Nuzhat Tabassum_sec-17_CSE110_assignment-06 Last Checkpoint: 8 hours ago (unsaved changes)
Logout
File
Edit
View
Insert
Cell
Kernel
Widgets
Help
Trusted
Python 3 O
+
• Run
с
Markdown
Task 15
You have been hired as an app developer for the company. The company plans to make an app for a grocery store where the user can order groceries and
see the total amount to be paid in the cart section.
To build this feature, you have to write a function that takes 2 arguments. They are:
order_items (must be a list)
• location (default value should be set to "Dhanmondi")
Your first task is to take a list of items from the user. Pass the list into the function parameter along with the optional location (Use default argument technique).
(Also, no need to take location as input, pass this any value you want.)
Your second task is to implement the function.…
arrow_forward
PS5: Webscraping
Suggested Solutions
Import BeautifulSoup, json, requesrts, and pandas.
In [ ]: from bs4 import BeautifulSoup
import pandas as pd
import requests
import re
import json
IMDB top 50 rated films.
The following URL, https://www.imdb.com/search/title/?groups=top_250&sort=user_rating, is a link to the top 50 rated films on IMDB. Create a pandas
DataFrame with three columns: Title, Year, and Rating, pulling the data from the webpage.
We can do this in steps. First, get the HTML code that generated the webpage.
In [ ]:
Using the "Inspect Element" tool in a browser, see that each film is displayed in a DIV with the class lister-item. Use BS to find all such elements
and store them in a list called films.
Then, create a list of the title of each film. Notice, by inspecting the HTML, that the title is contained inside of a tag (a link) that is itself inside of a
DIV with class lister-item-content . That is, for each film in the list films, find the div with the class…
arrow_forward
The tasks are relevant to the dataset "College.csv"
college.csv file at the path: https://drive.google.com/file/d/1StNKOnI0IDQKgZ35b-VZf1_5a_Dono-N/view?usp=sharing
request code python : K nearest neighbor: a. Create a binary attribute Apps01 that contains a 1 if Apps contains a value equal to or above its median, and a 0 if Apps contains a value below its median. Create a single data set d containing both Apps01 and the other College features. Split the data into d.train training set and d.test test set 80:20.b. Perform k-NN with several values of k in order to predict Apps01 using all the features.c. Display the comparison of validation error rate for different values of k.
arrow_forward
WORD 2016
when creating envelopes using mail merge each envelope in the final, merged document is separated by a:
1, page break
2, continuous section break
3, next page section break
arrow_forward
Step 2: Create the insertartist.php file
Create the insertartist.php file that takes the data from the artist.html form, connects to the database, and successfully inserts the data into the artist table. A message should be displayed to confirm that the record has been added.
arrow_forward
Assignment: Staywell Student Accomodation
I don't understand what I need to do here, its in mySQL. Help would be appreciated!
arrow_forward
5
Import tips.csv. This dataset has a column named sex. Write a function named recode gender that has one
parameter (gender) and will recode Male to 0 and Female to 1, and will return np. nan if the value is neither Male nor
Female. Apply this function to the column sex of tips using apply (). Print the first five lines of the new dataframe.
Code and Output
arrow_forward
Q2:Write all naming conventions of Entity and attributes of the XML file. Create a DTD and XML file for a Directory of the Movies, where each Movie has the following elements-Title, MovieType, Year, Director, Producer. The Producer section has the sub-elements Executive Producer, Co-producer, Creative Producer, Associate Creative Producer, and Web Producer. Entities must be declared for the names of the movies. Please note that you have to define all entities and attributes with proper syntax .
arrow_forward
Create user Peter, Brian and Cindy, create group Family and Friend. Add user Peter and Brian to the Family group, add Cindy to the Friend group. Set up password for all three users.
Log in as Peter, create a file “Peter-file1”, set up permission to allow Brian to read and modify the file, but not Cindy.
Verify your set up to see Peter and Brian can read and modify the file, but not Cindy.
Take screenshot of your configuration.
arrow_forward
المحاولة رقم lab1:1
Create a table as the following:
1. three columns (company, contact, country)
2.7 rows
3. the company picture only shows on Company column
the picture must be in circle and has ink to company URL ; picture
must show alt for company name
4. choose different color for each row (even and odd)
محتوى إضافي؟
يمكنلك إضافة تص وملفات تدعم إجاباتك
إضافة محتوی
Juus!
الحفظ لوقت لاحق
arrow_forward
Question 16 Rk.Assume you are provided a file: course_registrations.csv with fields semester, year, studentID, courseID What Spark code would you use to read in this file, remove records with the years before 2010 and then provide a count of total enrollment for each year?
Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
arrow_forward
Q2
Every month there are millions of streamers
who stream in a variety of different categories.
for this challenge, you will be working on
writing a data structure that will be storing
the name of streamers streaming, the number
of views they currently have, as well as the
category they are streaming in
arrow_forward
Make up a table of data. Your table must have at least four rows and four columns. It must have
at least one rowspan and one colspan attribute. The value for these attributes must be
greater than 1.
You can make up your own data. However, the table does have to make sense. Please name
this file part one.html,
arrow_forward
Computer Science
Your task is to build an AJAX search form for this dataset that queries the City of Winnipeg Open Data API and displays search results below the form. Your form should include one or more inputs that correspond to fields within your selected JSON dataset. When the form is submitted you should use the form data to query the Open Data API. Your search should allow users to find a subset of records from a specific dataset. To do this you will be using the WHERE, ORDER and LIMIT capabilities of the Open Data API explained below. Your search form should return anywhere from 0 to a maximum of 100 results. If zero results are found, display a message letting the user know that nothing was found.
Only HTML, CSS and Javascript should be used for this portion of the assignment. No PHP code should be used. (Your form will request JSON data from the open data API.)
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Related Questions
- This section has a total of 6 questions. Upload all scanned documents/files/ compressed folder in the linH the end of Question 26. Use the expression F = ((AC) +B') (C Đ A O B) to draw the Truth Table. A - I Use the upload link after Question 26 to upload the answer. (image, word, pdf, or any practical files) استخدم رابط التحميل بعد السؤال 26 لتحميل الإجابة. )صورة، كلمة، pdf، او الملفات العملية( H Dacimal pumbers with necessary steps.arrow_forwardPHP According to table the in the image (Build a file to link to your database and give it the file name config.php) (Build a file to display matrixnum, name from students table, subject_code and sub_name from subjects table and total_marks, grade from assessment table.) Build code using javascript, to calculate total_marks and determine grade. Where total_marks are calculated by adding quiz, assignment and project and divided by 3. Where the value range of each quiz, assignment and project is 0 to 100. Next the grade will be determined based on the grading system (refer to the grading table)arrow_forwardAutoSave O ff INT201_0OP_Lab7_2020-2 - Protected View - Saved to this PC - Search Anass Alhami File Home Insert Draw Design Layout References Mailings Review View Help A Share O Comments PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing Lab 7- Exercises Consider the following class hierarchy: Person -name:String -address:String +Person(name:String, address:String) +getName ():String +getAddress():String +setAddress(address:String):void +printlnfo (): void "name (address)" Student Teacher -numCourses:int = 0 -numCourses:int = 0 -courses:String[] = {} -grades:int[] = {} -courses:String[] = {} +Student (name:String, address:String) +addCourseGrade(course:String, grade:int):void +printGrades (): void +getAverageGrade(): double +printInfo ():void +Teacher (name:String, address:String) +addCourse(course:String):boolean +removeCourse(course:String):boolean +printInfo (): void Return false if the…arrow_forward
- Start Excel. Open the downloaded file named Excel_Ch10_PS2_Float.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. 0 2 The company would like to determine the number of customers it should book per day in order to break even. They would like to analyze this using a break-even analysis.On the Break-Even Analysis worksheet, enter the correct formula to calculate the Gross Revenue in cell D7. 5 3 Enter the correct formula to calculate the Total Fixed Costs in D13. 5 4 In cell D17 enter the correct formula to calculate the Total Variable Costs based upon the average number of guests per day and the days of operations per year. 5 5 Enter the correct formula to calculate the Net Income in D18. 5 6 Management thinks an average of 85 guests a day would be a realistic average. Use Goal Seek to find out what the price would need to be to come out exactly even with 85 guests per day and…arrow_forwardCPE162_exer3_6 [Read-Only] [Compatibility Mode] - Word Ace Jan C. Lape File Home Insert Design Layout References Mailings Review View Help O Tell me what you want to do & Share X Cut P Find - Arial - 11 A A Aa - AaBbCc AAB6CCL AaBbC AaBbCc[ AaBbCcl AaBbCcD akc Replace A Select - EE Copy BI U Paste - abe x, x A- aly , A 1 Caption Emphasis Heading 1 1 Normal Strong Subtitle - Format Painter Clipboard Font Paragraph Styles Editing Computer Engineering Department Laboratory Activity Form Course Number ES 085 Course Title Computer Programming 2 Topics Covered: Array Implement a program using the single-subscripted array and its operations with emphasis on the creation of programmer-defined data types and the use of separate files for the definition - .h, implementation - .c and client code - .c. Objectives: Description Airline Reservation System A small airline has just purchased a computer for its new automated reservations system. The president has asked you to program the new system. You…arrow_forwardAssarrow_forward
- . Create an anonymous block that returns the number of students in a section. Prompt for section id.Name the file Create an anonymous block that return the average numeric grade for a section. Prompt for sectionid and return the average grade. Complete the following:• Create a view called gl_stdV1 that returns the required data• Create an anonymous block that:o Accesses gl_stdV1o Uses the %ROWTYPE attribute to define a record structure for the view datao Prompts for student number and section ido Output the required information • Create an anonymous block that inserts new rows into the gl_professors_copy table• Declare variables using the %ROWTYPE and %TYPE attributes• Use bind/host variables to prompt for the input data• Allow for mixed case when entering the school code• Allow for mixed case when entering the first and last names and format names with firstcharacter in upper case and the remaining character in lower case• Include an INSERT statement in the execution section that…arrow_forwardAssignment Create a well-formed valid XML file that contains this information. The information does not have to be correct only your name needs to be correct, you can make up all other information. Then, create the proper XSLT file to load that XML data and display it. When displaying it, make sure you're using: • Different font colors • Tables • header tags ( ...) • Images where the image name is read from the XML file The information you must include: • Name • My Picture (this is an image file name. For example: loay.jpg, or myphoto.jpg • Address o Street number o City o State o Zipcode • Movies I like o Title o Release Datearrow_forwardCalculating baseball statistics in a file 5 points The Lahman Baseball Database is a comprehensive database of Major League baseball statistics. The journalist Sean Lahman provides all of this data freely to the public. We will make use of some of his data in this assignment. If you would like to learn more about the database, you can visit his website. We provide you with a CSV file named batting.csv that contains the annual batting performance data for all Major League Baseball players dating back to the year 1871. The first row in the file is a header indicating what data is stored in each column of the file. For example, column 12 is labeled "HR" and contains the number of home runs the player hit that year. Each of the next 99,846 lines contains a comma separated list of the data for that player and year. For example, the fifth line in the file indicates that a player with the ID allisdo01 hit 2 home runs in 1871. You should download batting.csv and place it in the same directory…arrow_forward
- Computer Science Import data from anywhere by using Web Scraper and save data in a .csv file. By using google meet/Zoom/any media, record you’re your entire process with your voice. Preserve the recorded file, .csv file in the same folder where you have preserved the excel file for other questions. Rename the recorded file name with your ID and question number. Don’t forget to upload the .csv file. File name should be Your_ID_Question_number.csv.arrow_forward16-7. Automated Title: In eq_world_map_3.py, we specified the title manually when defining my_layout, which means we have to remember to update the title every time the source file changes. Instead, you can use the title for the data set in the metadata part of the JSON file. Pull this value, assign it to a variable, and use this for the title of the map when you’re defining my_layout.arrow_forward• Assignment to be completed on an individual basis. • Open a new word document Save as 60#######-Assignment 1 • Save as a word document any other format will not be marked. • Answers are to be in complete sentences. Turnitin® will be applied to all uploads to the "Dropbox" of D2L. • Each short answer question should have a minimum of 250 words. . All citations must be in APA Format o If your paper does not contain any citations, your assignment will receive a grade of '0' • Assignment is to include a Cover Page, Table of Contents, Body and Reference Page. • Minimum of one external (NOT class PowerPoints) reference per answer. You can also use class PowerPoints to support your answers but you must reference them. Pa F- al 0 Part B Word Processing Re- PIC Question 1 question 1 Discuss the history & evolution of Word Processing. Hala baarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L