Need to to print out these columns

Assignment Help Python Programming
Reference no: EM132656843

You need to use python pandas using xlsx files

Within this xlsx file there are 4 columns i want to look at. The names of the columns is ASSNBRI ,DESCR,DEFECT_CODE and VAL_NUM22.

ASSNBRI=a number that defines the columns
DESCR=street names
DEFECT_CODE= what''s wrong with the road
VAL_NUM22= a ratin 1-5. rating 1 means that the road is not very damaged, a rating of 5 means that the road is very damaged

Need to to print out these 4 columns and filter them. Look at the first row of DESCR, you can see that the name of the road is CLEAR MOUNTAIN ROAD. If you look at the ASSNBRI you will see the number A00545627.

Now if you go to the third page of the excel file and search for A00545627 you will see that the defect_code for that number is AI.RDS.CRACKING. Now in the same page find the column names VAL_num22. You can see that the rating on that row is 2.

This means that: A00545627 is the id of clear mountain road it has a AI.RDS cracking with a rating of 2. So in other words You need the xlsx file to print a the data filtered.

Need a few lines of code that can print out these 4 columns next too eachother.

Attachment:- PYT_1test.rar

Reference no: EM132656843

Questions Cloud

What would take for the dmtc to reach global status : Conditions (societal, business, and cultural). If the DMTC is of regional or national status, what would it take for this DMTC to reach global status?
Explain product-driven-sales driven : Explain product-driven, sales driven, and market-driven business strategies and explain each type using an example.
What is a current biomedical ethics issue in health care : What is a current biomedical ethics issue in health care today that concerns you? Do you feel it is being handled appropriately? Explain.
Describe the market segment targeted : Select three different products one marketed online, one in newspaper, and one from a farm magazine. Describe the market segment targeted for each product.
Need to to print out these columns : Need to to print out these 4 columns and filter them. Look at the first row of DESCR, you can see that the name of the road is CLEAR MOUNTAIN ROAD
Evaluate the strengths and weaknesses of organization : Assume you are a manager of an agribusiness firm. How can you evaluate the strengths and weaknesses of your organization (business)?
How will organization recognize : As this DMTC continues to morph, how will your organization recognize and meet whatever challenges and/or opportunities emerge?
What is psychology : What is psychology? What do you think of when you think the word "psychologist?"
Describe the community approach in brief : How does community planning compare to the medical or behavioral models of mental health? Is a community approach more productive than an individualistic.

Reviews

Write a Review

Python Programming Questions & Answers

  Write a python program to implement the diff command

Without using the system() function to call any bash commands, write a python program that will implement a simple version of the diff command.

  Write a program for checking a circle

Write a program for checking a circle program must either print "is a circle: YES" or "is a circle: NO", appropriately.

  Prepare a python program

Prepare a Python program which evaluates how many stuck numbers there are in a range of integers. The range will be input as two command-line arguments.

  Python atm program to enter account number

Write a simple Python ATM program. Ask user to enter their account number, and print their initail balance. (Just make one up). Ask them if they wish to make deposit or withdrawal.

  Python function to calculate two roots

Write a Python function main() to calculate two roots. You must input a,b and c from keyboard, and then print two roots. Suppose the discriminant D= b2-4ac is positive.

  Design program that asks user to enter amount in python

IN Python Design a program that asks the user to enter the amount that he or she has budget in a month. A loop should then prompt the user to enter his or her expenses for the month.

  Write python program which imports three dictionaries

Write a Python program called hours.py which imports three dictionaries, and uses the data in them to calculate how many hours each person has spent in the lab.

  Write python program to create factors of numbers

Write down a python program which takes two numbers and creates the factors of both numbers and displays the greatest common factor.

  Email spam filter

Analyze the emails and predict whether the mail is a spam or not a spam - Create a training file and copy the text of several mails and spams in to it And create a test set identical to the training set but with different examples.

  Improve the readability and structural design of the code

Improve the readability and structural design of the code by improving the function names, variables, and loops, as well as whitespace. Move functions close to related functions or blocks of code related to your organised code.

  Create a simple and responsive gui

Please use primarily PHP or Python to solve the exercise and create a simple and responsive GUI, using HTML, CSS and JavaScript.Do not use a database.

  The program is to print the time

The program is to print the time in seconds that the iterative version takes, the time in seconds that the recursive version takes, and the difference between the times.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd