logo

CSV Data Analysis for Borough Sales

   

Added on  2019-09-16

1 Pages173 Words291 Views
 | 
 | 
 | 
4. Problem solving with lists, strings, and files Write a program that reads a csv data file called borough-sales.csv (sample provided with the lab) that contains sales of land in various parts of the UK for years of 2012-2014. The file consists of 4 columns: the area and the 3 years of sales numbers. It will calculate the following stats (printing to screen optional): Areas with average sales across the three years in the ranges 0-3000, 3001-5000, >=5001. It should generate a CSV file (columns separated by commas, rows separated by newlines (\n). Note that the rows do not have to be in any particular order.It should create a table similar to the following (table incomplete):0-30003001-5000>=5001City of LondonBarnetBromleyBarking and DagenhamCroydenWandsworth.........----- THE END ------ 1 -
CSV Data Analysis for Borough Sales_1

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Removing Null Values and Data Integrity
|7
|661
|100

Business Decision Making
|20
|563
|162

Business Decision Making
|14
|684
|111

Business Decision Making (Task- 3.3).
|12
|430
|55

Business Decision Making (Task- 3.3).
|12
|426
|48

Eastern Mountain Sport’s Sales Analysis
|11
|1563
|43