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

Answer 1

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

Design a chip that can complete four bit binary addition, subtraction, and, or operation. Complete the Verilog program and show simulation on Modelsim software , write the program list and screenshot of simulation results.

Answers

Answer:

How am I supposed to design a chip here?

Explanation:

Write javascript code for the form that appears in the image below. you are expected to add validation to the name field, email field, and radio button selection. The HTML code is given below, Insert the javascript validation code in the area of the HTML code shown below and save the file. Paste one screenshot of the validation you have written.

Couldn't find much on this, and don't rly know what to do.

Answers

Hope this helps. Please rate. Thanks.

In your own words, explain the process undertaken while testing the significance of a multiple linear regression model parameter Indicating clearly the hypothesis considered, test statistics used rejection criteria and conclusion.​

Answers

Multiple Linear Regression Analysis consists of more than just fitting a linear line through a cloud of data points. It consists of three stages: 1) analyzing the correlation and directionality of the data, 2) estimating the model, i.e., fitting the line, and 3) evaluating the validity and usefulness of the model.

Imagine you were going to use a dedicated workstation for an animation job rather than a personal PC. What differences would you expect to see between a dedicated 3D animation workstation and a typical PC

Answers

I'm no expert here, as I don't own a workstation but rather a gaming pc. But hey, I did tons of research on pc components and I think I can answer your question.

A dedicated workstation would be FAR more capable of running 3d applications, given how demanding they can get than a personal PC. You'd instantly regret using a typical pc for 3d rendering, even a top of the line gaming pc. Point is, gpus created by nvidia are far more capable of running graphic intensive programs specifically made for work than any other gpu. If you want to be satisfied, i'd advise you go for a workstation (Plus they're so much easier to get your hands on than a gaming rig).

Which invention made it possible to have an entire computer for a single circuit board

Answers

Answer:

ok lang                                                    

Explanation:


An engine that generates hot, expanding gases by burning fuel inside the machine.

Answers

Answer:

Piston engines, jet engines, and rocket engines all depend on the same basic principles to produce thrust. The engine mixes fuel with oxygen or another oxidizer in a combustion chamber. The mixture is ignited. The burning mixture creates hot, expanding gases.

Explanation:

PA BRAINLIEST

What is the full form of MPEG? The full form of MPEG is blank.

Answers

Answer:

Moving Picture Experts Group

Explanation:

Answer:

The full form of MPEG is Moving Picture Experts Group.

Explanation:

MPEG is a group of working experts to determine video or audio encoding and transmitting specifications/standards.

Differentiate between patent and copyright.

Answers

Answer: Patent - securing an invention

Copyrights - securing original ideas

Both are governed by different rules and regulations and both are for different purposes.

Would appreciate brainly <3

Leon wants an output from his tablet. What should he look at? A. the memory chip B. the processor C. the screen D. the power button

Answers

Answer:

he should look at the screen

Answer:

C. The screen

Explanation:

got it on edge

Imagine that you have an image that is too dark or too bright. Describe how you would alter the RGB settings to brighten or darken it. Give an example.

Answers

turn the brightness up

In which wireless configuration type do nodes communicate directly with each other, rather than with an access point?
1)802.11b
2)Mesh network
3)Ad-hoc
4)2.4Ghz

Answers

Ad-hoc

Explanation:

In which wireless configuration type do nodes communicate directly with each other, rather than with an access point? In an AD-HOC network, all nodes communicate and transmit directly to each other.

Why does a computer need an operating system?

Answers

Answer:

An operating system helps it to manage and run its designed duties.

If it lacks an operating system, it wouldn't be able to work

We can find out how robots work by looking in detail at the smaller parts. What do we call this?

Answers

Answer: This can be called the engineering.

Explanation:

Because the small parts is the bearings inside the robot

1. Where did the Industrial Revolution start and why did it begin there?​

Answers

Answer:

The first Industrial Revolution began in Great Britain in the mid-to-late 1700s, when innovation led to goods being produced in large quantities due to machine manufacturing.

This process began in Britain in the 18th century and from there spread to other parts of the world. Although used earlier by French writers, the term Industrial Revolution was first popularized by the English economic historian Arnold Toynbee (1852–83) to describe Britain's economic development from 1760 to 1840.

Answer:

This process began in Britain in the 18th century and from there spread to other parts of the world. Although used earlier by French writers, the term Industrial Revolution was first popularized by the English economic historian Arnold Toynbee (1852–83) to describe Britain’s economic development from 1760 to 1840  

Historians have identified several reasons for why the Industrial Revolution began first in Britain, including: the effects of the Agricultural Revolution, large supplies of coal, geography of the country, a positive political climate, and a vast colonial empire.

Explanation:

What are the three algorithm constructs?

Answers

Answer:

The algorithm constructs are sequence, decision/selection and repetition.

Explanation:

The three algorithm constructs in C are?

Sequence.Selection.Iteration.

What are three algorithm constructs?

There are known to be 3 basic constructs in an algorithm. They are:

Linear SequenceConditionalLoop

Note that  an algorithm is a combination of instructions for handling a problem or fulfilling a task.

Learn more about algorithm from

https://brainly.com/question/24953880

#SPJ2

Just a quick question, how do you set something == to char and int in an if statement (java)
Write a method checkCharacter() which has 2 parameters: A String, and a specified index (an int). Method checkCharacter() checks the character at the specified index of the String parameter, and returns a String based on the type of character at that location indicating if the character is a letter, digit, whitespace, or unknown character.


Ex: The method calls below with the given arguments will return the following Strings:


checkCharacter("happy birthday", 2) returns "Character 'p' is a letter"

checkCharacter("happy birthday", 5) returns "Character ' ' is a white space"

checkCharacter("happy birthday 2 you", 15) returns "Character '2' is a digit"

checkCharacter("happy birthday!", 14) returns "Character '!' is unknown"


Your program must define the method:

public String checkCharacter(String word, int index)



this is what i got to but im stuck on how to find out if its a char or int


public class TollCalculation {


public double calcToll(int hour, boolean isMorning, boolean isWeekend) {

Scanner scnr = new Scanner(System.in);

int timeHour; // Time of travel hour (24 hour format)

int timeMinute; // Time of travel minute

int inputColon; // Used to read time format

String userInput; // User specified time

double tollAmount;

}


public static void main(String[] args) {

TollCalculation tollObj = new TollCalculation();


// Test the three samples from the specification.

System.out.println(tollObj.calcToll(7, true, false));

System.out.println(tollObj.calcToll(1, false, false));

System.out.println(tollObj.calcToll(3, true, true));

}

}

Answers

This is the requested code in java.

public class CharTest {

   public static String checkCharacter(String text, int index) {

       if (0 <= index && index <= text.length()) {

           char ch = text.charAt(index);

           if (Character.isLetter(ch)) {

               return ch + " is a letter";

           } else if (Character.isDigit(ch)) {

               return ch + " is a digit";

           } else if (Character.isWhitespace(ch)) {

               return ch + " is a whitespace character";

           } else {

               return ch + " is an unknown type of character";

           }

       } else {

           return "index " + index.toString() + " is out of range";

       } // end if

   } // end function checkChar()

   public static void main(String[] args) {

       // Test the three samples from the specification.

       System.out.println(checkCharacter("happy birthday", 2));

       System.out.println(checkCharacter("happy birthday", 5));

       System.out.println(checkCharacter("happy birthday 2 you", 15));

   } // end function main()

} // end class CharTest

The function checkcharacter(text, index) returns a string value describing the kind of character found at the position in text specified by index; whether it was a letter, digit, whitespace, or an unknown kind of character.

How it does that is to make use of respective functions defined within the Character class in java. That is

isLetter(char) returns a bool specifying if the char parameter is a letter.isDigit(char) returns a bool specifying if the char parameter is a digit.isWhitespace(char) returns a bool specifying if the char parameter is a whitespace character.

It calls these functions in an if statement. These else part of the if statement is then executed if the character is neither a letter, digit, or whitespace.

Finally, the function main() calls checkCharacter() three times to test the function and return the results to the console.

Another example of a java program on characters is found in the link below

https://brainly.com/question/15061607

HELP ME ILL GIVE BRAINLY Input 50 numbers and then output the average of the negative numbers only. Write in pseudocode!

Answers

Answer:

The explanation is for 10 inputs though. You'd have to follow these steps to find input 50 numbers.

Explanation:

This is how I wrote it in the Plain English programming language which looks like pseudo-code but compiles and runs (to save you all the rest of the steps):

To run:

Start up.

Write "Enter 10 numbers separated by spaces: " on the console.

Read a reply from the console.

Loop.

If the reply is blank, break.

Get a number from the reply.

Add 1 to a count.

Add the number to a total.

Repeat.

Write "The total is: " then the total on the console.

Put the total divided by the count into an average.

Write "The average is: " then the average on the console.

Refresh the screen.

Wait for the escape key.

Shut down.

what is the difference between information poor and information rich

Answers

Answer:

The “Information poor” are consumers who use traditional mass media information such as television, DVDs, radios and magazines. ... On the opposite “information rich” stands for a new elite within the information society.

Explanation:

You arrive at your first client meeting with Jaba's Smoothie Hut. Jaba's owner, Kim, has asked you to install a Wi-Fi network for his customers. Kim has told you that the store needs the following:

Dedicated internet service with enough bandwidth to meet customer demand and run the store.
Be cost effective (Kim does not want the most expensive or the cheapest).
Customers will use Wi-Fi and the business will have 5 wired connections

Select the correct package for the Jaba's Smoothie Hut:

a. 20 Mbps service with 1 modem/Router, a 16 port switch, and 1 wireless access point
b. 100 Mbps service with 1 Modem/Router, a 24 port switch, 3 wireless access points (1 for office, 1 for retail, and 1 for outside)

Answers

The correct package which can be used to set up the Jaba's Smoothie Hut so that there would be dedicated internet service with enough bandwidth to meet customer demand and run the store is:

b. 100 Mbps service with 1 Modem/Router, a 24 port switch, 3 wireless access points (1 for office, 1 for retail, and 1 for outside)

According to the given question, we are asked to show the correct package which can be used to set up the Jaba's Smoothie Hut so that there would be dedicated internet service with enough bandwidth to meet customer demand and run the store

As a result of this, we can see that when using wireless networks (WiFi), there is a necessity to make use of a fast 100 Mbps service so that the connection would have sufficient bandwidth to meet the needs of the store and customers.

Therefore, the correct answer is Option B

Read more here:

https://brainly.com/question/18450917

If you will choose among the multimedia mentioned, what will you use to promote this advocacy: Stop strand discrimination. We are all equal.

Answers

The media that I would choose to promote the arrest of discrimination would be television, radio, newspaper, and social media.

When we want to transmit a message to many people, the most appropriate thing is to use mass media, that is, media that have a large coverage of people, such as:

TVRadioNewspapers

 

On the other hand, in recent years people can expose their ideas or disseminate information through social networks, because their messages can become a trend among people and have an even greater reach than conventional media.

Another positive aspect of social networks is that they reach a greater diversity of people with different characteristics such as:

ReligionPolitical positionSocioeconomic positionEducational levelAgeSexBirthplace

Therefore, to spread an anti-discrimination message the best option is to spread it through mass media such as television, radio, newspapers and social networks.

Learn more in: https://brainly.com/question/23228635

Write a python function to compute a certain number to a given power. The program should continue asking the user for number and power and display the result until the user enters 0 as the number. Note: don't use the power function of Python. Compute the power using a for or a while loop.

Answers

while True:

   number = int(input("input the number: "))

   exponent = int(input("input the exponent : "))

  if number == 0:

       break

   else:

       result = 1

       while exponent != 0:

           result *= number

           exponent-=1

       print("Answer = " + str(result))

   

we are asked not to use the power function of python. The question wants us to use a for or a while loop to compute the power.

The while loop makes sure the user is always asked to input the number and an exponent.

If the users number equals 0, the while loop will break.

Else the code will find the power of the number.

Finally, we print the answer if the user number is not zero

The bolded part of the code are python keywords.

read more: https://brainly.com/question/12992668?referrer=searchResults

A large company pays its salespeople on a commission basis. The salespeople receive $900 per week, plus 8.75 percent of their gross sales for that week. For example, a salesperson who sells $10000 worth of merchandise in a week receives $900 plus 8.75 percent of $10000, or a total of $1775. You have been supplied with a list of the products sold by each salesperson. The values of these products are as follows:
Item Value
1 100
2 200
3 300
4 400
Develop a script that inputs one salesperson’s items sold for last week, calculates the salesperson’s earnings and outputs HTML5 text that displays the salesperson’s earnings.

Answers

Answer:

Explanation:

please help!!!! what is the meaning of M,I,C,R,O,S,O,F,T word?
M-
I-
C-
R-
O-
S-
O-
F-
T-​

Answers

Answer:

Microsoft (the word being a portmanteau of "microcomputer software") was founded by Bill Gates and Paul Allen on April 4, 1975, to develop and sell BASIC interpreters for the Altair 8800. It rose to dominate the personal computer operating system market with MS-DOS in the mid-1980s, followed by Microsoft Windows

Explanation:

if you need full answer this is it

camera mount that is worn over the shoulders of a camera operator. What is it called?

Answers

It is called a camera stabilizer.
I hope this helped :)

Your company is building a new architecture to support its data-centric business focus. You are responsible for setting up the network. Your company's mobile and web-facing applications will be deployed on-premises, and all data analysis will be conducted in GCP. The plan is to process and load 7 years of archived .csv files totaling 900 TB of data and then continue loading 10 TB of data daily. You currently have an existing 100-MB internet connection. What actions will meet your company's needs

Answers

The actions will meet your company's needs is to Lease a Transfer Appliance, upload archived files to it, and send it to oogle to transfer archived data to Cloud Storage.

Data centric is simply known to be an architecture where data is said to be of primary and permanent asset, and applications is temporary.

Businesses is all about functionality, and as such, firms often buys or build application systems.

Each application system is known to have its own unique data model, and its code is often linked with the data model used.

Conclusively, Transferring large datasets needs manpower that is the right team, planning early, and testing your transfer plan before its use.

 

Learn more data-centric business from

https://brainly.com/question/21810261

What are two drawbacks of using netbook ?

Answers

Answer: They are becoming obsolete and they are usually low-performance. Also a 32-bit system.

Would appreciate brainly <3

Answer:

Laptop computers are difficult to repair, upgrade or modify due to their closed and integrated design. While storage drives and RAM are usually accessible because these are the things you will most likely upgrade, it is often difficult to modify or replace your CPU, graphics chip or motherboard. These jobs will usually require professional equipment and tools–or a hired professional technician. Additionally, while in a desktop computer the possible configurations are almost unlimited, laptop configurations are limited to those provided by laptop manufacturers. Some software may also be incompatible with laptop hardware, and installations of different operating systems than those bundled with the laptop may result in hardware failures.

Consider the following class. public class ClassicClass { private static int count = 0; private int num; public ClassicClass() { count++; num = count; } public String toString() { return count + " " + num; } } What is printed when the following code in the main method of another class is run? ClassicClass a = new ClassicClass(); ClassicClass b = new ClassicClass(); ClassicClass c = new ClassicClass(); System.out.println(a + ", " + b + ", " + c);

Answers

The the code in the main method is run, it will print

"3 1, 3 2, 3 3"

The static/class field count stores the number of instances of the class created. count is always incremented when the instance constructor is called.

The instance field num acts like an identifier/serial number for the instance created. When the constructor is called, the current count is stored in the num field of the instance.

Each instance's toString( ) method will output the total count (from count) and the serial of the instance (from num).

When the code runs in the main method, it creates three instances (making count==3), so that we have

a = {count: 3, num: 1}b = {count: 3, num: 2}c = {count: 3, num: 3}

and implicitly calls toString( ) in the println method for each of the three instances to produce the following output

"3 1, 3 2, 3 3"

Learn more about programs here: https://brainly.com/question/22909010

Which tab must be enabled to access the VBA Editor?
O Developer
O Insert
O Review
O View

Answers

The answer to your question is Developer.

Explain the role that the number of data exchanges plays in the analysis of selection sort and bubble sort. What role, if any, does the size of the data objects play

Answers

Answer:

The greater the number of exchanges are there greater is the complexity of the algorithm. Thus it is a measure to check for the complexity of the program.

What is the difference between a computer’s RAM and its hard disk?
A. RAM is not volatile, which means that it is more reliable than a hard disk. A hard disk is volatile, which means that it is vulnerable to electronic interference.

B. RAM is volatile, which means that it does not retain information in memory after powering down. A hard is not volatile, which means that it retains information in memory after powering down.

C. RAM is not volatile, which means that it retains information in memory after powering down. A hard disk is also not volatile, which means that it retains information in memory after powering down.

D. RAM is volatile, which means that it must be handheld with care when removed or replaced. A hard disk is not volatile, which means that it is much more resistant to movement during removal or replacement.

Answers

Answer:

D. RAM is volatile, which means that it must be handheld with care when removed or replaced. A hard disk is not volatile, which means that it is much more resistant to movement during removal or replacement.

Explanation:

Most RAM (random access memory) used for primary storage in personal computers is volatile memory. Volatile memory contrasts with non-volatile memory, which does not lose content when power is lost. Non-volatile memory has a continuous source of power and does not need to have its memory content periodically refreshed.

Answer:

Explanation:

RAM can be accessed faster than hard drive. – Any changes made to the file will be present in RAM while once the changes are saved it is copied to the hard drive permanently. – RAM needs power to store data, hard drives do not.

Other Questions
"If you cry, you'll not get anything from Santa." my mom said when I was youngNow, ig I'm on the naughty list :-( how old was winter the dolphin when she passed away How do energy transformations occur in a hydroelectric plant?The potential energy of water is converted to mechanical energy by a turbine.The kinetic energy of water is converted by a dam into potential energy.The kinetic energy of water is converted by a generator into electric energy.The potential energy of water is converted by a transformer into electric energy. The circumference of a circle is 20pi m. find its diameter,in meters Which of the following processes occurs during sexual reproduction? A. An organism splits in two. B. An egg cell and a sperm cell unite. C. A fragment regenerates into a new organism. D. An identical growth forms and then detaches. When Reggie is teaching the boys kung fu, what does he say will help them resist the temptation of drugs and violence?WE BEAT THE STREETS What was the effect of adding Texas and California to the union? intelligent industries recently purchased a $50,000, 10% 12-month bond. from intelligents point of view, this bond would be considered a 1/2x - 2=3 number line variables combining like terms 16. x+317. 5y+318. x+5y-5 What is gibbs free energy. If the radius of a circle equals 20 cm find its circumference correct to one decimal place What is friction ??? what do we call judgments about people, situations, objects, or thoughts? solve for q q/-2+17=13 q= A jet is flying in a direction N 70 E with a speed of 600 mi/h. Find the north and east components of the velocity. Round to two decimal places. What is a possible pH of acid rain?07.06.904.310.5 Whats the product of 2.6 do you believe that drug defense / abuse in the philippines is decreasing explain your answer A cell uses active transport to move sodium ions out of the cell. Why does the cell use active transport instead of diffusion to move sodium ions out of the cell?.