Data Handling using Pandas — Question 7

The steps to create CSV files are as follows:

1. Launch Microsoft Excel.
2. Type the data given in Table in the Excel sheet.
3. Save the file with a proper name by clicking File -> Save or Save As or press Ctrl + S to open the Save As window.
4. Type the name of the file and select file type as CSV from the drop-down arrow.
5. Click the Save button. Excel will ask for confirmation to select CSV format.
6. Click OK.
7. It will display a dialog box asking permission to keep comma as delimiter for CSV file.
8. Lastly, click Yes to retain and save the Excel file in CSV format.