Assume a file named “tiobeIndex” containing the ratings of programming languages as follows. There are six fields in each line separated by comma. The first filed is the ranking in September this year. The second filed is the ranking in September last year. The first row shows the meaning for each field, the remained rows show the rating information for the top 10 programming languages. Write commandsto finish following tasks. Sep 2020, Sep 2019, Change, Programming Language, Ratings, Change 1, 1, , Java, 12.687%, -5.55% 1) Output only the two fields: ranking in September this year and name of programming language using awk. Note: add text "Ranked" before the rank, and put a colon between the rank and the name. E.g. The info for Java should be displayed as Ranked 1:Java 2) Change the plus sign in the third field to text "increase". E.g. Info for PHP should be changed to 6, 7, increase, PHP, 2.210%, -0.64%

Assume a file named “tiobeIndex” containing the ratings of programming languages as follows. There are six fields in each line separated by comma. The first filed is the ranking in September this year. The second filed is the ranking in September last year. The first row shows the meaning for each field, the remained rows show the rating information for the top 10 programming languages. Write commandsto finish following tasks. Sep 2020, Sep 2019, Change, Programming Language, Ratings, Change 1, 1, , Java, 12.687%, -5.55% 1) Output only the two fields: ranking in September this year and name of programming language using awk. Note: add text "Ranked" before the rank, and put a colon between the rank and the name. E.g. The info for Java should be displayed as Ranked 1:Java 2) Change the plus sign in the third field to text "increase". E.g. Info for PHP should be changed to 6, 7, increase, PHP, 2.210%, -0.64%

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 2.11CP

See similar textbooks

Similar questions

8 An employee file contains records that show an employee's number, name, job code and pay code. The job codes and pay codes are three-digit codes that refer to cor- responding job descriptions and pay rates, as in the following tables: Job code Job description A80 Clerk A90 Word processor B30 Accountant B50 Programmer B70 Systems analyst C20 Engineer C40 Senior engineer D50 Manager Chapter 7: Array processing Pay code Pay rate 01 $9.00 02 $9.50 03 $12.00 04 $20.00 05 $23.50 06 $27.00 07 $33.00 Your program is to read the employee file, use the job code to retrieve the job description from the job table, use the pay code to retrieve the pay rate from the pay rate table, and print for each record the employee's number, name, job description and pay rate. At the end of the report, print the total number of employees.
Create a formula that provides the start date of a project as follows: In cell H4, begin to enter a formula using the INDEX Use the Lookup table (range A2:E23) as the array. For the row_num argument, use the MATCH Use the Project ID (cell H2) as the lookup_value for the MATCH function. Use the ID column (range A2:A23) as the lookup_array for the MATCH function. Specify an exact match (0) for the MATCH function. Use the Start Date column (column 4) as the column_num for the INDEX function.
Look at the code below and use the following comments to incdicate the scope of the static variables or functions. Place the comment below the relevant line. Module scope Class scope Function scope The code runs. Use onlinegdb.com to see it run. Module scope means global but only known in this source file. Class scope means global but only known by the class. Function scope means global but only known in the function. Hide Comments 1 #include 2 static const int MAX_SIZE=10; 5 // Return the max value 6 static double max(double d1) 7 { static double lastMax = 0; lastMax = (di > lastMax) ? di : lastMax; return lastMax; 8 10 11 } 12 13 // singleton class only one instance allowed 14 class singleton 15 { public: static Singleton& getsingleton() { return theone; } // Returns the Singleton 16 17 18 19 20 friend std::ostream& operator<< (std::ostream& o, const Singleton& s); private: Singleton() { }; // Prevents more instances 21 22 23 24 25 static Singleton theone; 26 }; 27 Singleton…
The function named findNote, which returns a student's letter grade according to the data(score out of 100, class average, standard deviation) sent to it.
Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. How many courses are there on each level? 2. What is the average grade of courses that have been taken by the student with student ID 861103-2438? 3. Which students (studentID only) have the highest grade for the course ‘CS052’? 4. Find the courses (course codes only) that have been taken by both the student 861103-2438 and the student 123456-0980.
Having this information. StudentsAttribute Name Data TypeStudentID char(11)FirstName varchar(20)LastName varchar(20)Gender char(1)DateofBirth date CoursesAttribute Name Data TypeCourseCode varchar(6)CourseName varchar(70)Level char(2)Credits int RegistrationAttribute Name Data TypeStudentID char(11)CourseCode varchar(6)Grade decimal(2, 1) Write SQL code to: 1. What are the student ID, the names, and birthday of the female students who were born before the last day of 1992? 2. How many students are registered in the course “PHY210”? 3. How many courses are offered by the department of Computer Science (i.e. course codes CS***)? 4. Which course(s) (couseCode and courseName) of level G1 give 5 credits?
PYTHON CODE Using Artists.csv (link below), write a query that returns all lines that are female artists only, with begin date greater than 1950 but no greater than 2000 Write a query that will return all lines of British Male artists, who's first names starts with the letter ‘A’ and has an end date earlier than 1990 Write a query that will write to a file all lines that have Japanese Artists who’s difference of end date and begin date exceeds 100 years. I.e. if artist begins in 1900 and ends in 2005, then they would be included in the output (2005-1900 = 105 years) Write a query that will write and find to a file the artist who’s been at the Museum the longest (the widest gap between Begin Date and End Date) Artists.csv: https://media.githubusercontent.com/media/MuseumofModernArt/collection/master/Artists.csv
For this week's assignment you will allow the user to add employee, view all employees, search employee by ssn, and edit employee information. Below this is what its supposed to look like when completed. I have also included what I started to do but I can't figure out how to add the search by SSN option or the edit employee option. If you can give me a step by step on how to do this in python I would greatly appreciate it.
• List the staff names whose last name ends with a “d”.• List the staff names whose last name does NOTbegins with a “B”.• List the staff names whose last name does NOT havea “e” in the 2 nd letter.• List the staff names whose last name begins with “B”and the 3 rd letter is a “e”.
Question 1: Create a structure to specify data of employees in CS Department. The data to be stored is: Employee ID, Name, designation, Date of Joining and a flag to know whether the current employee is still in service or not. Assume maximum of 20 employees in the CS Department. Your program must be menu driven with following options: 1. Add a record (Employee ID, Name, Designation and Date of Joining of each employee) 2. Print the Employee ID, Name, Designation, Date of Joining and Status (whether the employed still in service or left) of each employee in tabular format. 3. Search specific employee. 4. Calculate total service of each employee.
Which of the following is correct? (refer to the tables in the JustLee Books database.)a. A group function can be nested inside a group function.b. A group function can be nested inside a single-row function.c. A single-row function can be nested inside a group functiond. d. a and be. a, b, and c
Which of the following is correct? (refer to the tables in the JustLee Books database.)a. A group function can be nested inside a group function.b. A group function can be nested inside a single-row function.c. A single-row function can be nested inside a group function. d. a and be. a, b, and c