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

Business Decision Making

Business Decision Making

Business Decision Making (Task- 3.3).

Business Decision Making (Task- 3.3).

Eastern Mountain Sport’s Sales Analysis