Write a program that, given a file name typed by the user, reads the content of the file and determines the highest salary, lowest salary and average salary. The file contains employee records, and each record consists of the hours worked and the hourly rate. The salary is calculated as the product of the hours worked and the hourly rate.
An example of file containing three records is as follows:
10.5 25.0
40.0 30.0
30.9 26.5
Answers
Using the pandas packge in python, the program which performs the required calculation goes thus :
file_name = input()
#user types the filename
df = pd.read_csv(file_name, names=['hours_worked', 'rate']
#file is read into a pandas dataframe
df['salary'] = df['hours_worked'] * df['rate']
#salary column is created using the product of rate and hours worked
highest_salary = df['salary'].max()
#the max method returns the maximum value of a series
print('highest_salary)
lowest_salary = df['salary'].min()
#the min method returns the minimum value of a series
print('lowest_salary)
avg_salary = df['salary'].mean()
#the mean method returns the average value of a series
print('avg_salary)
Learn more : https://brainly.com/question/25677416
Related Questions
How do you know if a device is an input device or an output device?
Answers
Answer:
if a device is putting data into the computer in front of the text , sound , images then it's an input device & but if the device is outputting things from the computer such and sound movement an printing then it's an output .
A generator that is not producing voltage or current may have an open stator winding. True or False?
Answers
Answer:
True. An open stator winding is a common cause of a generator not producing any voltage or current. The stator winding is responsible for producing the electromagnetic field that induces voltage in the generator's rotor, which then produces the current. If the stator winding is open or broken, the magnetic field will not be produced, resulting in no voltage or current being generated.
In computer technology the term input means
Answers
Answer:
An input is data that a computer receives.
You would like the cell reference in a formula to remain the same when you copy
it from cell A9 to cell B9. This is called a/an _______ cell reference.
a) absolute
b) active
c) mixed
d) relative
Answers
Answer:
The answer is:
A) Absolute cell reference
Explanation:
An absolute cell reference is used in Excel when you want to keep a specific cell reference constant in a formula, regardless of where the formula is copied. Absolute cell references in a formula are identified by the dollar sign ($) before the column letter and row number.
Hope this helped you!! Have a good day/night!!
Answer:
A is the right option absolute5 operating systems from the best to the worst and why.
I'll give brainliest fr
Answers
Answer:
Microsoft windows.Mac Operating system.iOSLinux Operating system.Ubuntu Operating system.\(.\)
what is containment and why is it part of the planning process
Answers
Answer:
Isolating affected channels, processes, services, or computers; stopping the losses; and regaining control of the affected systems. It is part of the planning process to identify the best containment option for each scenario or system affected.
Explanation:
Pretend you are planning a trip to three foreign countries in the next month. Consult your wireless carrier to determine if your mobile phone would work properly in those countries. What would the costs be? What alternatives do you have if it would not work?
Answers
Upon consultation with the wireless carrier the repone was that the cost will go up by 25 % of the normal charges. This type of service is called roaming. The alternatives were to purchase new devices and plans compliant with the local network. These in themselves are additional costs and it is much more easier to go with the current provider.
Who is a wireless carrier?The term "wireless carrier" refers to a provider of commercial mobile services or any other radio communications service required by the FCC to offer wireless 9-1-1 service.
Mobile network operator, mobile phone operator, mobile operator, cellular corporation, and wireless service provider are all words that relate to the same entity.
Learn more about wireless carrier:
https://brainly.com/question/31943799
#SPJ1
Where are functions stored?
in the development environment or on the Internet
in the development environment or in an individual program
in an individual program or on a computer’s hard drive
in an individual program or in a lookup table
Answers
Answer:
In the development environment or in an individual program
Explanation:
A function in programming is a code or lines of code that perform a particular function.
They are stored in the development environment or in an individual program so they can be called up and execute when needed.
Why is open AI recognised for changing the industry
Answers
OpenAI's research has brought about the development of deep learning systems that can work more that humans in a variety of tasks, such as playing video games and seeing objects in images
What is the open AI?OpenAI has developed advanced language models like GPT-3 with impressive language generation capabilities for tasks like translation, answering questions, and text completion.
AI-generated text advances push boundaries for language understanding and generation, with OpenAI models showing impressive human-like abilities for diverse applications. OpenAI's models are used in content generation, virtual assistants, etc.
Learn more about open AI from
https://brainly.com/question/26101173
#SPJ1
what is digital logic?
Answers
bonsoir,
Il s'agit d'identifier la logique qui gouverne la séquence afin de déterminer le chiffre manquant en utilisant la plupart du temps les opérations de base (addition, soustraction, multiplication, division).
il suffit de trouver le chiffre manquant et ainsi de suite jusqu'à obtenir une suite logique
j'espère que ma réponse t'auras aidé !
(ps: peux-tu noter ma réponse meilleur réponse stp)
bonne soirée a toi !
Why is it important to isolate evidence-containing devices from the internet?
To save the battery
To hide their location
Devices can be remotely locked or wiped if connected
It is not important to isolate the devices
Answers
Answer:
C.
Devices can be remotely locked or wiped if connected
Explanation:
is a colon (:) and semicolon (;) important in CSS declaration?
Answers
Answer:
YES
Explanation:
this is very important
1. (+) Peter will be taken to the airport by his father tomorrow.
(-)………………………………………………………………….
(?)………………………………………………………………….
Answers
the figure shows cross-section of a ruler which is a rectangle of 2. 5 cm by 0.2 cm on which surmounted an isosceles trapezium (one in which the non- parallel sides area of equal length). the shorter of the parallel sides of the trapezium 0.7 cm long.if the greatest height of the ruler is 0. 4 cm and it is 33 cm long,calculate its surface area
I need help with this coding homework! I cant get right the Two Test Case's shown in the picture.
Instructions
Redo Programming Exercise 16 of Chapter 4 so that all the named constants are defined in a namespace royaltyRates.
Instructions for Programming Exercise 16 of Chapter 4 have been posted below for your convenience.
Exercise 16
A new author is in the process of negotiating a contract for a new romance novel. The publisher is offering three options. In the first option, the author is paid $5,000 upon delivery of the final manuscript and $20,000 when the novel is published. In the second option, the author is paid 12.5% of the net price of the novel for each copy of the novel sold. In the third option, the author is paid 10% of the net price for the first 4,000 copies sold, and 14% of the net price for the copies sold over 4,000. The author has some idea about the number of copies that will be sold and would like to have an estimate of the royalties generated under each option. Write a program that prompts the author to enter the net price of each copy of the novel and the estimated number of copies that will be sold. The program then outputs the royalties under each option and the best option the author could choose. (Use appropriate named constants to store the special values such as royalty rates and fixed royalties.)
THE FULL CODE:
#include
#include
using namespace std;
namespace royaltyRates {
const double FIXED_ROYALTY_1 = 5000.00;
const double FIXED_ROYALTY_2 = 20000.00;
const double ROYALTY_RATE_2 = 0.125;
const double ROYALTY_RATE_3_LOW = 0.1;
const double ROYALTY_RATE_3_HIGH = 0.14;
const int COPIES_THRESHOLD = 4000;
}
using namespace royaltyRates;
int main() {
double netPrice;
int estimatedCopies;
cout << "Enter price of each copy: ";
cin >> netPrice;
cout << "Estimated number of copies sold: ";
cin >> estimatedCopies;
double royalty1 = FIXED_ROYALTY_1 + FIXED_ROYALTY_2;
double royalty2 = ROYALTY_RATE_2 * netPrice * estimatedCopies;
double royalty3 = 0;
if (estimatedCopies > COPIES_THRESHOLD) {
royalty3 = (COPIES_THRESHOLD * netPrice * ROYALTY_RATE_3_LOW)
+ ((estimatedCopies - COPIES_THRESHOLD) * netPrice * ROYALTY_RATE_3_HIGH);
} else {
royalty3 = estimatedCopies * netPrice * ROYALTY_RATE_3_LOW;
}
cout << fixed << setprecision(2);
cout << "Royalties under option 1: $" << royalty1 << endl;
cout << "Royalties under option 2: $" << royalty2 << endl;
cout << "Royalties under option 3: $" << royalty3 << endl;
if (royalty1 >= royalty2 && royalty1 >= royalty3) {
cout << "Option 1 is the best option you can choose for maximum royalties.";
} else if (royalty2 >= royalty1 && royalty2 >= royalty3) {
cout << "Option 2 is the best option you can choose for maximum royalties.";
} else {
cout << "Option 3 is the best option you can choose for maximum royalties.";
}
return 0;
}
Answers
This Python script assists the author in comparing three options and determining which one to select.
The Script and ExplanationFirst, it requires the input of the net price for each copy and an estimated amount of copies sold. Subsequently, royalties are computed under each option and displayed. Finally, the script determines the optimal choice and displays it.
Option 1 involves fixed royalties valued at $20,000 plus $5,000. Option 2 provides royalties based on a percentage of the net price multiplied by estimated copies sold, while Option 3 uses tiered percentages applied to the net price until the maximum number of sales is reached (4,000), after which a different percentage applies.
The resulting royalty payouts are denoted individually for each option and presented as output formatted with two decimal places. The best alternative among them is calculated via conditional statements that establish whether Royale Options #1, #2, or #3 offers the highest payout. Then, the corresponding option tag is returned as output.
Read more about programs here:
https://brainly.com/question/23275071
#SPJ1
Your friend Alicia says to you, “It took me so long to just write my resume. I can’t imagine tailoring it each time I apply for a job. I don’t think I’m going to do that.” How would you respond to Alicia? Explain.
Answers
Since my friend said “It took me so long to just write my resume. I can’t imagine tailoring it each time I apply for a job. I will respond to Alicia that it is very easy that it does not have to be hard and there are a lot of resume template that are online that can help her to create a task free resume.
What is a resume builder?A resume builder is seen as a form of online app or kind of software that helps to provides a lot of people with interactive forms as well as templates for creating a resume quickly and very easily.
There is the use of Zety Resume Maker as an example that helps to offers tips as well as suggestions to help you make each resume section fast.
Note that the Resume Builder often helps to formats your documents in an automatic way every time you make any change.
Learn more about resume template from
https://brainly.com/question/14218463
#SPJ1
1. What are the main features of IEEE 802.3 Ethernet standard?
Answers
Answer:
Single byte node address unique only to individual network. 10 Mbit/s (1.25 MB/s) over thick coax. Frames have a Type field. This frame format is used on all forms of Ethernet by protocols in the Internet protocol suite.
Explanation:
802.3 is a standard specification for Ethernet, a method of packet-based physical communication in a local area network (LAN), which is maintained by the Institute of Electrical and Electronics Engineers (IEEE). In general, 802.3 specifies the physical media and the working characteristics of Ethernet.
In safety matters what comes first the people or the film
Answers
Answer:
the people.
Explanation:
if somebody dies, the person in charge is going to get held responsible.
the point of (18 ,0) lies on
Answers
Answer and Explanation:
The point of (18 ,0) lies on the x-axis.
On a graph, this point is put 18 units to the right of the origin (0,0), moving its' x digit, and it doesn't move its' y digit, so it doesn't change up or down.
#teamtrees #WAP (Water And Plant)
which statements describes the size of an atom
Answers
answer:
A statement that I always think about to understand the size of an atom. If you squish a person down to the size of an atom. It will make a black hole. and if you squish the whole Earth. down to the size of a jelly bean it will also make a black hole. This is just a approximation.
-----------------------
I use the scale to understand how small that is I am open to hear more principles if you were talking about math wise that would be glad to help.
if you have anymore questions I will try to answer your questions to what I know.
.
What is the 8-bit two's complement form of the decimal number -112? OA. 10001111 OB. 11111000 O C. 10010000 OD. 11111001
Answers
-128 +16 = -112
Therefore,
C is the appropriate answer
What is the name of the variable in the
following code?
Answers
Answer:
Lift
Explanation:
When coding, you use a variable name for an object, and assign it to move up, down, and/or sideways.
Your professor is advising a new crowd-funding app for women's self-help groups (SHGs) in Latin America on their database architecture. This is the business requirement she has worked on: All campaigns belong to a SHG. An SHG must exist before a campaign is created, and when an SHG is deleted from the database, all its campaigns are deleted. SHGs always belong to a country, and a country must be added to the app before SHGs are added to it. Which of the following is true of the entities defined in the database? Select all that apply.
Question 6 options:
An SHG entity depends on a Campaign entity
A Campaign entity is a depend on the SHG entity
A Country is not dependent on the Campaign entity
An SHG entity is dependent on a Country entity
A Campaign is an Independent entity
Answers
Based on the given information, the following statements are true:
An SHG entity depends on a Country entity.A Campaign entity is dependent on the SHG entity.What is a country entity?In the context of database design, a country entity refers to a logical representation of a country within a database system.
It typically stores information related to countries, such as their names, codes, demographics, or any other relevant data.
The country entity serves as a reference point for other entities in the database, such as self-help groups (SHGs) or campaigns, allowing for proper organization and association of data within the system.
Learn more about Entity at:
https://brainly.com/question/29491576
#SPJ1
Which database item would show details such as a customer’s name, their last purchase, and other details about a customer?
A. file
B. field
C. record
D. table
E. index
Answers
Answer:
The answer is C. Record
Explanation:
You are troubleshooting an issue where a PC can reach some hosts on the Internet (using either DNS name or IP address), while several other hosts on the Internet are not reachable. From the PC you can Ping all devices on your local subnet. What is most likely causing the problem?
Answers
The options are missing from the question,below are the options to choose from;
A) incorrect (or missing) routes in a routers routing table
B) incorrect DNS configuration on the PC
C) incorrect default gateway configuration on the PC
D) duplicate IP addresses on your LAN
Answer: The correct answer to the question is option A
INCORRECT (OR MISSING) ROUTES IN A ROUTERS ROUTING TABLE.
Explanation: When it is possible for a PC to ping some devices but not actually all,we can then make an assumption that either it has a wrong subnet that is configured or the router from the path to the remote device actually has an incorrect or a missing routes to the device.
Which of the following substances increases in quantity during repititive muscle contraction during oxygen deficti ?
Lactic acid
Answers
Answer:
Lactic acid
Explanation:
Lactic acid builds up during strenuous exercise with limited amounts of oxygen.
user intent refers to what the user was trying to accomplish by issuing the query
Answers
Answer:
: User intent is a major factor in search engine optimisation and conversation optimisation. Most of them talk about customer intent ,however is focused on SEO not CRO
Explanation:
what do the last two steps in the cyclical design process most likely involve
A. The research
B. The audience
C. The prototype
D. The project
Answers
Answer:
Well you would want to test the design, so it would be "c" then "d"
Explanation:
I hope this helps.
The last two steps in the cyclical design process most likely involve the prototype and the project. The correct options are C and D.
What is design process?The mechanical part is designed on the software with its all dimensions.
The design process is not completed until and unless a prototype is made. This is to analyze the working of the mechanical part. This must be done as a complete project.
The last two steps involved in the cyclical design process most likely involve the prototype and the project.
Thus, the correct options are C and D.
Learn more about design process.https://brainly.com/question/11914795
#SPJ2
who could be involved in the murder of Mr Douglas
Answers
Answer:
Freedy Thopson
Explanation:
asking questions is super in this education life
Write a program to create an array of size m X n and print the sum of all the numbers row wise in java
Answers
Answer:
Here is the program to create an array of size m X n and print the sum of all the numbers row wise in Java:
```
import java.util.Arrays;
public class ArraySumRowWise {
public static void main(String[] args) {
int m = 3;
int n = 4;
int[][] arr = {{1, 2, 3, 4}, {5, 6, 7, 8}, {9, 10, 11, 12}};
// Print the original array
System.out.println("Original Array:");
for (int[] row : arr) {
System.out.println(Arrays.toString(row));
}
// Compute and print the row wise sum
System.out.println("Row Wise Sum:");
for (int i = 0; i < m; i++) {
int rowSum = 0;
for (int j = 0; j < n; j++) {
rowSum += arr[i][j];
}
System.out.println("Row " + (i+1) + ": " + rowSum);
}
}
}
```
Explanation:
In this program, we have created an array of size 3 X 4 and initialized it with some values. We have then printed the original array and computed the row wise sum by iterating over each row and adding up all the elements. Finally, we have printed the row wise sums. You can replace the values of m, n, and arr with your own values to test the program with different array sizes and values.
A ___________ consists of a large number of network servers used for the storage, processing, management, distribution, and archiving of data, systems, web traffic, services, and enterprise applications.
Answers
Answer:
Data center
Explanation:
A network service provider can be defined as a business firm or company that is saddled with the responsibility of leasing or selling bandwidth, internet services, infrastructure such as cable lines to both large and small internet service providers.
Generally, all network service providers, internet service providers and most business organizations have a dedicated building or space which comprises of a large number of computer systems, security devices, network servers, switches, routers, storage systems, firewalls, and other network associated devices (components) typically used for remote storage, processing, management, distribution, and archiving of large amount of data, systems, web traffic, services, and enterprise applications.
Furthermore, there are four (4) main types of data center and these includes;
I. Managed services data centers.
II. Cloud data centers.
III. Colocation data centers.
IV. Enterprise data centers.