Spreadsheets
Spreadsheet programs such as Microsoft Excel or OpenOffice 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 the data.
• Delete a row or column.
• Insert a row or column.
• Change a value in a cell.
• Output the data in CSV format.
Issues to consider:
• Use Python’s 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 operation—e.g., d for delete.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.