Python v.3 Spreadsheet programs such as Microsoft Excel or Open Office Calc have an option to export data into CSV files. In this exercise you will create a program that will read in a spreadsheet (in CSV format) and manipulate it. Provide the follo
Python v.3 Spreadsheet programs such as Microsoft Excel or Open Office Calc have an option to export data into CSV files. In this exercise you will create a program that will read in a spreadsheet (in CSV format) and manipulate it. Provide the following capabilities: -print data -delete row or column -insert row or column Change a value in a cell output the data in CSV format Issues to consider: -Use Pythons csv module to read in a spreadsheet. Choose an appropriate data structure to store the data. Should you use lists tuples or dictionaries? -Construct a driving loop in your program that will prompt for the operations specified previously. A useful interface is to allow choices to be specified with a single letter related to the operatione.g. d for delete.