This exercise 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: ***************** Welcome to the Python Data Analysis App********** 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 3 *************** Thanks for using the Data Analysis App**********
This exercise 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:
***************** Welcome to the Python Data Analysis App**********
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
3
*************** Thanks for using the Data Analysis App**********
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 3 images