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 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.
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 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.
Need Solution email me:
topsolutions8@gmail.com
topsolutions8@gmail.com