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

1. Which of the following options can you use to format the contents of a cell?
Select all that apply.
a. Font Size
b. Sort
C. Italic
d. Underline

Answers

Answer:

a

Explanation:

The correct options are A, C, and D. Front Size, Italic, and Underline are the options can you use to format the contents of a cell.

You can also use the keyboard shortcuts Ctrl+B, Ctrl+I, and Ctrl+U to bold, italicize and underline a selection of text.

What is the use of format cells?

You can only alter how cell data appears in the spreadsheet by using cell formats. It's critical to remember that the data's value is unaffected; only how the data is presented has changed. The formatting options include options for fractions, dates, timings, scientific alternatives, and more.

Regular, Bold, Italic and Bold Italic are the four different sorts of font styles. Selected cells or ranges in a worksheet can have their font style changed. Changing the typeface involves the following steps: Pick the cell or cells that need to be changed. The text you want to format should be selected. Go to the Home tab and select Bold, Italic, or Underline. Ctrl + B will bold text. Ctrl + I will italicize text.

Thus, the correct options are A, C, and D.

Learn more about Format cell here:

https://brainly.com/question/24139670

#SPJ2

F= A· (B+C). draw the symbol for the logic gate​

Answers

Answer:

You need an AND gate and an OR gate.

Explanation:

see picture below

Turtle graphics windows do not automatically expand in size. What do you suppose happens when a Turtle object attempts to move beyond a window boundary

Answers

When a turtle object attempts to move beyond a window boundary, the turtle object stops because it cannot move outside the window boundary.

The turtle graphics window is simply a graphics window that is used as a playground when drawing turtles.

A turtle object is always in the turtle graphics window.

This in other words mean that, the turtle object cannot exceed the boundaries of the turtle graphics window

An attempt to move the turtle object outside its window will stop the turtle object;

This is so because the turtle object is always in the turtle graphic window, and it cannot move beyond it.

Read more about turtle graphics window at:

https://brainly.com/question/3070883

In order to send and receive packets in the Internet, hosts require an IP address. What are the 2 ways a host can obtain an IP address

Answers

Answer:

Explanation:

An IP address is a 32-bit number. It uniquely identifies a host (computer or other device, such as a printer or router) on a TCP/IP network.

IP addresses are normally expressed in dotted-decimal format, with four numbers separated by periods, such as 192.168.123.132. To understand how subnet masks are used to distinguish between hosts, networks, and subnetworks, examine an IP address in binary notation.

For example, the dotted-decimal IP address 192.168.123.132 is (in binary notation) the 32-bit number 110000000101000111101110000100. This number may be hard to make sense of, so divide it into four parts of eight binary digits.

These 8-bit sections are known as octets. The example IP address, then, becomes 11000000.10101000.01111011.10000100. This number only makes a little more sense, so for most uses, convert the binary address into dotted-decimal format (192.168.123.132). The decimal numbers separated by periods are the octets converted from binary to decimal notation.

For a TCP/IP wide area network (WAN) to work efficiently as a collection of networks, the routers that pass packets of data between networks don't know the exact location of a host for which a packet of information is destined. Routers only know what network the host is a member of and use information stored in their route table to determine how to get the packet to the destination host's network. After the packet is delivered to the destination's network, the packet is delivered to the appropriate host.

For this process to work, an IP address has two parts. The first part of an IP address is used as a network address, the last part as a host address. If you take the example 192.168.123.132 and divide it into these two parts, you get 192.168.123. Network .132 Host or 192.168.123.0 - network address. 0.0.0.132 - host address.

The second item, which is required for TCP/IP to work, is the subnet mask. The subnet mask is used by the TCP/IP protocol to determine whether a host is on the local subnet or on a remote network.

In TCP/IP, the parts of the IP address that are used as the network and host addresses aren't fixed. Unless you have more information, the network and host addresses above can't be determined. This information is supplied in another 32-bit number called a subnet mask. The subnet mask is 255.255.255.0 in this example. It isn't obvious what this number means unless you know 255 in binary notation equals 11111111. So, the subnet mask is 11111111.11111111.11111111.00000000.

Lining up the IP address and the subnet mask together, the network, and host portions of the address can be separated:

11000000.10101000.01111011.10000100 - IP address (192.168.123.132)

11111111.11111111.11111111.00000000 - Subnet mask (255.255.255.0)

The first 24 bits (the number of ones in the subnet mask) are identified as the network address. The last 8 bits (the number of remaining zeros in the subnet mask) are identified as the host address. It gives you the following addresses:

11000000.10101000.01111011.00000000 - Network address (192.168.123.0)

00000000.00000000.00000000.10000100 - Host address (000.000.000.132)

So now you know, for this example using a 255.255.255.0 subnet mask, that the network ID is 192.168.123.0, and the host address is 0.0.0.132. When a packet arrives on the 192.168.123.0 subnet (from the local subnet or a remote network), and it has a destination address of 192.168.123.132, your computer will receive it from the network and process it.

Almost all decimal subnet masks convert to binary numbers that are all ones on the left and all zeros on the right. Some other common subnet masks are:

Decimal Binary 255.255.255.192 1111111.11111111.1111111.11000000 255.255.255.224 1111111.11111111.1111111.11100000

Internet RFC 1878 (available from InterNIC-Public Information Regarding Internet Domain Name Registration Services) describes the valid subnets and subnet masks that can be used on TCP/IP networks.

Hope this helps!

The capability of moving a completed programming solution easily from one type of computer to another is known as ________. Group of answer choices

Answers

Answer: Portability

Explanation: I hope it helps you!

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

Write a program, using case statements, that mimics a calculator. The program should take as input two integers and the operation to be performed. It should then output the numbers, the operator, and the result. For division, of the denominator is zero, output an appropriate message.

Answers

Answer:#include<iostream>

using namespace std;

int main() {

int var1, var2;

char operation;

cout << "Enter the first number : ";

cin >> var1;

cout << endl;

cout <<"Enter the operation to be perfomed : ";

cin >> operation;

cout << endl;

cout << "Enter the second nuber : ";

cin >> var2;

cout << endl;

bool right_input = false;

if (operation == '+') {

cout << var1 << " " << operation << " " << var2 << " = " << (var1 + var2);

right_input = true;

}

if (operation == '-') {

cout << var1 << " " << operation << " " << var2 << " = " << (var1 - var2);

right_input = true;

}

if (operation == '*') {

cout << var1 << " " << operation << " " << var2 << " = " << (var1 * var2);

right_input = true;

}

if (operation == '/' && var2 != 0) {

cout << var1 << " " << operation << " " << var2 << " = " << (var1 - var2);

right_input = true;

}

if (operation == '/' && var2 == 0) {

cout << "Error. Division by zero.";

right_input = true;

}

if (!right_input) {

cout << var1 << " " << operation << " " << var2 << " = " << "Error;";

cout << "Invalid Operation!";

}

cout << endl;

system("pause");

return 0;

}

Explanation:

If there are over 1,000 websites about a certain topic, the information is reliable. A. True B. False

Answers

Answer:

If they all have the same answer it is true, but if they are all different check with trusted sources

Explanation:

3 3) Why computer is called non-inteligent , IN Dull machine?

Answers

Answer:

Computers are dull: The CPU is the Central Processing Unit or the brains of the computer. The CPU knows what to do with machine language instructions. It doesn't understand them; it just knows what to do with them.

Explanation:

Hope I could help.

                                 please mark as brainliest

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

What symbol must go at the end of an if statement?

Answers

::::::::
a period (.)

Answer: the pireod .

Explanation:

I love dogs & cats.

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

In this paper https://arxiv.org/pdf/2008.10150.pdf, I'm having a hard time understanding how the assignment in the picture is derived, can you please work this out?

Answers

Answer:

f*(i,z) = log pxz

Explanation:

they round

Yea I’m going home with you and I’m not going to sleep sleep early

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

If you were a hackathon team manager, how could you best address the conflict created by having more volunteers than open roles

Answers

There are various ways to resolve conflict. Addressing conflict by the  team manage is by:

Control conflict by expanding the resource base Eliminate conflict by assigning volunteers to another project team.

There are a lot of ways an individual can handle conflict. One of which is to expand the resource base.

Example: Supporting  team manager receives 4 budget requests for $150,000 each. If he has only $200,000 to distribute, there will be conflict at this stage because each group will believe its proposal is worth funding and will not be happy if not fully funded. So the best thing to do is to expand the resources allocated.

The right way to fix this conflict is to tell your volunteers in advance that some of them will not be doing different tasks etc.

See full question below

Capital One invites employees to work on special projects during hackathons. Employees can explore new technologies, rapidly push development forward, or just expand their network to include more colleagues interested in innovation. There's always the possibility that more employees want to participate in the hackathon than there are roles available. If you were a hackathon team manager, how could you best address the conflict created by having more volunteers than open roles? Control conflict by expanding the resource base. Eliminate conflict by assigning volunteers to another project team.Eliminate conflict by avoiding the volunteers. Stimulate conflict by making volunteers compete for the available roles.

Learn more from

https://brainly.com/question/18103914

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.

Question # 1 Multiple Select Which features are important when you plan a program? Select 4 options. Knowing what information is needed to find the result. Knowing what information is needed to find the result. Knowing what the user needs the program to accomplish. Knowing what the user needs the program to accomplish. Knowing how many lines of code you are allowed to use. Knowing how many lines of code you are allowed to use. Knowing what you want the program to do. Knowing what you want the program to do. Knowing how to find the result needed. Knowing how to find the result needed.

Answers

Answer:

c

Explanation:

Answer:

Knowing what the user needs the program to accomplish.Knowing how to find the result needed.Knowing what information is needed to find the result.Knowing what you want the program to do

Explanation:

:D

Describe the two problems that appear in the construction of large programs that led to the development of encapsulation constructs.

Answers

Two problems that can lead to the development of encapsulation constructs when creating large programs are the complexity of data and the lack of security in sensitive data.

We can arrive at this answer because:

Encapsulation constructs are designed to prevent data from being invaded by unauthorized person.These constructions must be done without causing inconsistencies in the system, interfering with codes, and increasing the complexity of data. For this reason, large programs that present high complexity and difficult codes, demand the use of encapsulation constructs, so that their data does not become more complex.Encapsulation constructs are also necessary when there are flaws in data security and it is not possible to keep them away from the attack by intruders.

Although there are other ways to accomplish these goals, encapsulation constructs are widely used because of their simplicity and efficiency.

More information:

https://brainly.com/question/13438419

the reasons why business processes are necessary in a company

Answers

What is a business process?

Before knowing why they are necessary, let me explain what a business process is to be clear so you can understand a little bit more before I get to the meat. When a group of people work together to accomplish a certain goal, the process is called a "business process." A participant is assigned a task at each step of a business process. To put it another way, it serves as the foundation for several related concepts such as business progress management and process automation

The importance of a business process.

In big firms, having a business process is a must, and the advantages of doing so are immediately apparent. Organizations are made up of processes, which allow them to streamline and maximize the utilization of resources at the same time.

Reasons to have a well-defined business processIdentify which tasks are the most important to your larger business goalsImprove efficiencyStreamline communicationSet approvals to ensure accountability and an optimum use of resourcesPrevent chaos from lurking and lingering in your daily operationsStandardize a set of procedures to complete tasks that really matter to your business and tie it togetherReduction of risks from BPM softwareElimination of redundanciesMinimized costsImproved collaborationImproved productivity so that means more moneyHigher efficiencyHigher compliance

Answer:

Key reasons to have well-defined business processes

Identify what tasks are important to your larger business goals. Improve efficiency. Streamline communication between people/functions/departments. Set approvals to ensure accountability and an optimum use of resources.

What are the steps to creating a text box? Use the drop-down menus to complete them.

1. Go to the
View
tab on the ribbon.

2. Click
.

3. Select any of the templates shown or
, which will open a blank text box.

4. Position the text box and adjust the text size, font, and color as desired.

Answers

Answer: The answers (in order) are

Insert

Text Box

Draw Text Box

Explanation: Just took the test on edgen, November 2021.

What is the difference between (IF instructions & WHILE instructions )
0
를 들
T
!

Answers

Answer:

While statements determine whether a statement is true or false. If what’s stated is true, then the program runs the statement and returns to the first step. If what’s stated is false, the program exits the while and goes to the next statement. An added step to while statements is turning them into continuous loops. If you don’t change the value so that the condition is never false, the while statement becomes an infinite loop.

If statements are the simplest form of conditional statements, statements that allow us to check conditions and change behavior/output accordingly. The part of the statement following the if is called the condition. If the condition is true, the instruction in the statement runs. If the condition is not true, it does not. The if statements are also compound statements. They have a header (if x) followed by an indented statement (an instruction to be followed is x is true). There is no limit to the number of these indented statements, but there must be at least one.

Ruzwana is a system administrator at an organization that has over 1000 employees. Each of the employees brings their own devices to work. She wants to find an efficient method that will allow her to make the various devices meet organizational standards. In addition, she would like to deploy various universal applications such as the VPN client, meeting software, and productivity software to these systems. Which of the following options should Ruzwana use to achieve the desired outcome in this scenario?
a. A provisioning package.
b. A catalog file.
c. A configuration set.
d. An answer filE.

Answers

In this scenario, the option which Ruzwana should use to ensure that the various devices meet organizational standards and for the deployment of various universal applications is: d. An answer file

An answer file can be defined as an XML-based file which contains the configuration settings and values that should be used during the installation of a software program on one or more devices in accordance with specific standards. Thus, each and every device using the same answer file would have the same configuration setting.

Additionally, an answer file allows a system administrator to automatically deploy various software programs such as meeting software and productivity software to a particular system or network.

In this context, the most appropriate option which Ruzwana should use to ensure that the various devices meet organizational standards and for the deployment of various universal applications is an answer file.

Read more on software here: https://brainly.com/question/25703767

Big Chungus is god. prove me wrong.

Answers

Answer:

who is Big chungus???

Believe in Lord Buddha !

Kiểm tra cặp số hứa hôn
Đầu vào : số nguyên n,m
Đầu ra : in ra n,m là cặp số hứa hôn và in ra không là số hứa hôn nếu ngược lại

Answers

Answer:

Sorry im not Vietnam so please explain it in English or ask someone who can speak Vietnam to help you


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 type of database replication relies on centralized control that determines when replicas may be created and how they are synchronized with the master copy

Answers

Database replication is very common in this Era. Traditional database replication is relies on centralized control that determines when replicas may be created and how they are synchronized with the master copy.

Database replication  is known to be the constant electronic copying of data from a database using one computer or server that is connected also to a database in another . this ensure that all users do share the same level of information.

Replication is often done to technologies which are used for copying and distributing data and database objects from one database to another and thereafter use in synchronizing between databases.

Conclusively, Replicas can only be made in the Traditional database replication through the power of centralized control.

See full question below

What type of database replication relies on centralized control that determines when replicas may be created and how they are synchronized with the master copy?

a distributed database model

b. traditional database replication

c. enterprise replication

d. local database model

Learn more about database replication from

https://brainly.com/question/6447559

Write a program that reads a list of integers, and outputs whether the list contains all even numbers, odd numbers, or neither. The input begins with an integer indicating the number of integers that follow.If the input is:5246810Then the output is:all evenIf the input is:513579

Answers

Answer:

uuuuu

Explanation:

Answer:

57677748957394209690369-34064666

Explanation:

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

Choose one piece of information your class can know, but you don’t want to share on your website. Why is it okay for your classmates and teacher to know it, but not to post it publicly?

Answers

Answer:

because other people you dont know can see it and it can sometimes not be good

Explanation:

How exactly do I answer questions?

Answers

Answer:

If you mean this website, click the add answer button on the question

Explanation:

Other Questions
Rockerfellar square has an outdoor skating rink.Rockerfellar SquareO correct as is.O Rockerfellar skatingO Square Rink What opinion do the other artisans now have of bottom since they think he is lost? 2) State the area of the given triangle.94512A) 24 square unitsB) 36 square units48 square unitsD) 60 square units an acorn falls from a tree. ignoring air resistance, what forces are on the acorn while its falling? La Madre de mi tio es mi? La esposa de mi padre que no es mi madre es mi? During a collision, a 63.9-kilogram driver of a car moving at 24 m/s is brought to rest by an inflating airbag in 1.2 seconds. What is the magnitude of the force exerted on the driver by the airbag? Help me pleaseeeeeeeee Help Im timed! The graph of an equation with a negative discriminant always has which characteristic?A: no x-interceptB:no y-interceptC: no maximumD: no minimum A special promotion for its 20-ounce bottle of soda, a soft drink company printed amessage on the inside of each cap. Some of the caps said, "Please try again," whileothers said, "You're a winner!" The company advertised the promotion with theslogan "] in 6 wins a prize.Suppose the company is telling the truth and that every 20-ounce bottle of soda itfills has a 1-in-6 chance of being a winner. Seven friends each buy one 20-ouncebottle of the soda at a local convenience store. Let X = the number who win a prize. Unit #2 - Lesson #13 Exit Ticket: A tour company for large groups charges a one time fee of $200 plus anadditional $25 per person who goes on the tour. They must make at least $1,650 to make the tour profitable. Letn be the number of people going on the tour. Write and solve an inequality in terms of n that represents all numbersof people who can go on the tour to make it profitable. Which selection from the article "Scientists study Persian Gulf reefs for coral survival clues" identifies the biggest threat to coral reefs?Question 5 options:Warming waters spark bleaching events. Along with the bleaching, the ocean is becoming more acidic.The researchers demonstrated that this new organism was the most commonly found algae throughout the gulf's coral reefs. They say it probably adapted as a result of the gulf's harsh conditions. According to the safety valve theory, what would occur once the American frontier was closed?A. Economic growth would halt because businesses would not have new markets to conquer.B. Social conflict would increase because citizens would not have any place to make a fresh start.C. The population of the country would quickly overwhelm its natural resources.D. The concept of what it meant to be American would be changed by influxes of immigrants. PLS HELP ME PLS HELP ME PLS HELP ME Any part of the body can be affected by diseaseA. TrueB. False Which expression uses the associative property to make it easier to evaluate 143 - )? 2 CAN O A. 7(a ) O B. (145) ( O C. 143.5) O D. (14.) SUBMIT Plz help I need help Another method in creating a temporary magnet is by using electricity. This can be done by wrapping an iron nail with a coil of wire. By passing electricity through the coil of wire the iron nail will become a temporary magnet or an electromagnet. The strength of the electromagnet depends on the size of the electric current and the number of times the coil is wrapped around the nail. If the electricity stops flowing through the coil the nail will no longer be magnetic.Write a one sentence summary of the above paragraph. An example of smooth muscle function in the body isa beating heart.excretion of waste.flexing a bicep.performing exercise. Heat is transferred from molecules with more kinetic energy to molecules with _________kinetic energy. Help please anyone!!!!!!