Instructions_SC_AC365_2021_CS4-7a

The file personnel_data.csv is stored in the local directory, and contains tabular data pertaining to the employees at a London-based business. The table contains column headers First, which gives each employee's first name, Second, which gives each employee's last name, and Time in Employment (Months), which gives the number of months since the employees contract began. Create a Pandas DataFrame pension that contains two columns. The first column should be labelled 'Full', and give both the first and last names of each employee (separated by a space). The second column should be labelled 'Pension Value', and give the total amount of money contributed towards the employee's pension. For each month the employee is employed, £248 is contributed towards their pension. You should not include the currency (£) in the data. The rows in the DataFrame should be indexed with integers from zero.

Case Problem 1 Data File needed for this Case Problem: Donation.xlsx Henderson Pediatric Care Center    Kari Essen is a fundraising coordinator for the Pediatric Care Center located in Henderson, West Virginia. Kari is working on a report detailing recent donations to the center and wants you to enter this data into an Excel workbook. Complete the following: 1. Open the Donation workbook located in the Excel1 > Case1 folder included with your Data Files. Save the workbook as Donation List in the location specified by your instructor. 2. In the Documentation sheet, enter your name in cell B3 and the date in cell B4. 3. Increase the font size of the text in cell A1 to 28 points. 4. Add a new sheet to the end of the workbook, and rename it as Donor List. 5. In cell A1 of the Donor List worksheet, enter Donor List as the title, and then set the font size to 28 points. 6. In the range A6:H13, enter the donor information shown in Figure 1-44. Enter the ZIP code data as text rather than as…

insert 5 records into your Courses_xxxx table The fid, rid, aid should not be all the same among the 5 records. The enrollment number should be less than the room size. mysql> select * from Hotel; +---------+---------------+--------+ | hotelno | hotelname     | city   | +---------+---------------+--------+ | ch01    | Omni Shoreham | London | | ch02    | Phoenix Park  | London | | dc01    | Latham        | Berlin | | fb01    | Grosvenor     | London | | fb02    | Watergate     | Paris  | +---------+---------------+--------+   mysql> select * from Room; +--------+---------+--------+-------+ | roomno | hotelno | type   | price | +--------+---------+--------+-------+ |    501 | fb01    | single | 19.00 | |    601 | fb01    | double | 29.00 | |    701 | ch02    | single | 10.00 | |    701 | fb01    | family | 39.00 | |    801 | ch02    | double | 15.00 | |    901 | dc01    | single | 18.00 | |   1001 | ch01    | single | 29.99 | |   1001 | dc01    | double | 30.00 | |   1001 | fb02…

adultsData.csv file: https://onq.queensu.ca/d2l/common/viewFile.d2lfile/Database/MzA1MzUwMzA/adultsData.csv?ou=748849

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.)

10

Q = insert 5 records into your Courses_xxxx table The fid, rid, aid should not be all the same among the 5 records. The enrollment number should be less than the room size.   mysql> select * from Hotel; +---------+---------------+--------+ | hotelno | hotelname     | city   | +---------+---------------+--------+ | ch01    | Omni Shoreham | London | | ch02    | Phoenix Park  | London | | dc01    | Latham        | Berlin | | fb01    | Grosvenor     | London | | fb02    | Watergate     | Paris  | +---------+---------------+--------+ 5 rows in set (0.00 sec)   mysql> select * from Room; +--------+---------+--------+-------+ | roomno | hotelno | type   | price | +--------+---------+--------+-------+ |    501 | fb01    | single | 19.00 | |    601 | fb01    | double | 29.00 | |    701 | ch02    | single | 10.00 | |    701 | fb01    | family | 39.00 | |    801 | ch02    | double | 15.00 | |    901 | dc01    | single | 18.00 | |   1001 | ch01    | single | 29.99 | |   1001 | dc01    |…

Open the start file EX2019-ChallengeYourself-6-3. The file will be renamed automatically to include your name.  If the workbook opens in Protected View, click the Enable Editing button in the Message Bar at the top of the workbook so you can modify the workbook.  On the Sales Data worksheet, enter a formula in cell J4 to find the sales associate's region by extracting the first three characters of the sales associate's ID in cell C4. Use cell references where appropriate. Fill the formula down through cell J64. On the Sales Data worksheet, calculate the commission rate and commission paid for each sales associate.  Beginning in cell F4, enter a formula using the IFS function to calculate the commission rate based on the following table. Hint: Do not include comma separators in numerical values in formulas. Excel interprets commas as function argument separators.Table EX 6.1 displays calculations for commission rates based on annual sales. IF ANNUAL SALES ARE: THEN THE COMMISSION…

please use store procedures to answer the following question Create a procedure to update Job Title for a given JOB_ID This procedure is called Update_Job_Title will have two INPUT parameters. p_job_id as VARCHAR2    as INPUT parameter and also p_new_job_title  as VARCHAR2 as INPUT parameter.   In BEGIN and END executable section               Execute UPDATE command on JOBS table to change title of a JOB_ID            Here is the command that you can use in BEGIN and END                       UPDATE JOBS  SET job_title= p_new_job_title WHERE job_id= p_job_id;       Test your code by executing procedure for below job_id. Currently in Jobs table you have Job_id = ‘MK_MAN’ and job_title=’ Marketing Manager’   Change  title from  Marketing Manager    to    Marketing Sr. Manager     execute Update_Job_Title(‘MK_MAN’, ‘Marketing Sr. Manager’ )

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,…

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.…

This one I don't get it I need help itn171

TABLEA and TABLEB have identical formats/layouts. To select records from TABLEA that are NOT in TABLEB, use the _________________ operator.   Question 8 options:   1)  UNION   2)  INTERSECT   3)  MINUS   4)  UNION ALL