Perform histogram analysis and plots for select variables

Assignment Help Python Programming

Reference no: EM133445956

Overview: In this week, you have studied additional Python language syntax including File I/O, Exceptions and Object-Oriented Programming.

• Python Data Analysis Code
• 2 Input Files (Same files supplied to you)
• Word, Excel or PDF file containing your test results

Python Applications for Lab:

This exercise (80 points) allows a user to load one of two CSV files and then perform histogram analysis and plots for select variables on the datasets. The first dataset represents the population change for specific dates for U.S. regions. The second dataset represents Housing data over an extended period of time describing home age, number of bedrooms and other variables. The first row provides a column name for each dataset. The following columns should be used to perform analysis:

• PopChange.csv:
• Pop Apr 1
• Pop Jul 1
• Change Pop

Housing.csv:
• AGE
• BEDRMS
• BUILT
• ROOMS
• UTILITY

Notice for the Housing CSV file, there are more columns in the file than are required to be analyzed. You can and should still load each column.

Specific statistics should include:

• Count
• Mean
• Standard Deviation
• Min
• Max
• Histogram

A user interface might look similar to this:

Select the file you want to analyze:
1. Population Data
2. Housing Data
3. Exit the Program

1
You have entered Population Data. Select the Column you want to analyze:
a. Pop Apr 1
b. Pop Jul 1
c. Change Pop
d. Exit Column

a
You selected Pop Apr 1
The statistics for this column are: Count = 10000
Mean = 32.5
Standard Deviation = 4.5 Min = 53.2
Max = 12.5
The Histogram of this column is now displayed.

Select the Column you want to analyze:
a. Pop Apr 1
b. Pop Jul 1
c. Change Pop
d. Exit Column

d
You selected to exit the column menu Select the file you want to analyze:
1. Population Data
2. Housing Data
3. Exit the Program

If an inappropriate entry is detected, the program should prompt for a correct value and continue to do so until a correct value is entered.
Hints:

1. Use the Pandas, Numpy, MatplotLib and other Python modules when appropriate.

2. Be sure to install the required Python modules in your environment before you import or try to use them in your code. For example, pip install each of the required modules that are external Python libraries that you need.

3. If an inappropriate entry is detected, the program should prompt for a correct value and continue to do so until a correct value is entered.

4. Use comments to document your code

5. Test with many combinations.

6. Use pylint to verify the code style - the goal is a 10!

7. The user Interface should continue to run until the user indicates they are ready to exit.

8. Be sure to review the previous readings and modules as you may need to use statistics and other modules to complete this lab.

2. Document your testing results using your programming environment. You should also include and discuss your pylint results for the application. The test document should include a test table that includes the input values, the expected results and the actual results. A screen capture should be included that shows the actual test results of running each test case found in the test table. Be sure to include multiple test cases to provide full coverage for all code and for each function you develop and test.

Attachment:- Lab data.rar

Reference no: EM133445956

Questions Cloud

What would be the consequences of that training : Would you rather have a really good memory or really good metacognition? How might you train someone to develop better metacognition if he or she doesn't have

How can gender roles impact identity development : How can gender roles impact identity development, and how can identity development impact gender roles?

Why might intentional human-made disasters be believed : Why might intentional human-made disasters be believed to have a greater negative psychological impact than those which occur accidentally or are caused by

What psychologists say can be done to treat it : At some time in their lives, most people will have sleep problems such as the following: insomnia, nightmares, sleepwalking, bed-wetting, snoring, etc.

Perform histogram analysis and plots for select variables : Perform histogram analysis and plots for select variables on the datasets. The first dataset represents the population change for specific dates for U.S. region

List an example of sociological imagination that applies : List an example of sociological imagination that applies the concept of personal issues as public issues.

What type of reliability does my pattern of results apply to : What type of reliability does my pattern of results apply to? Which type do you think seems most like you?

Discuss how it may have made the application of cit : Choose one of the evolutions of Critcal Incidents Theory (CIT) and discuss how it may have made the application of CIT to specific leadership consultations more

Explain what the consequences to aversive racism : According to The Nature of Contemporary Prejudice: Insights from Aversive Racism. explain what the consequences to aversive racism, in helping behavior

User Account

All Pages