Informatics Practices
How can we create CSV file? Explain with steps.
Python Data Handling
1 Like
Answer
The steps to create CSV files are as follows:
- Launch Microsoft Excel.
- Type the data given in Table in the Excel sheet.
- Save the file with a proper name by clicking File -> Save or Save As or press Ctrl + S to open the Save As window.
- Type the name of the file and select file type as CSV from the drop-down arrow.
- Click the Save button. Excel will ask for confirmation to select CSV format.
- Click OK.
- It will display a dialog box asking permission to keep comma as delimiter for CSV file.
- Lastly, click Yes to retain and save the Excel file in CSV format.
Answered By
1 Like
Related Questions
What are CSV files ?
What is the use of nrows argument in read_csv() method?
How do you iterate over a dataframe? Explain with the help of code snippet.
Write commands to print following details of a Series object seal :
(a) if the series is empty
(b) indexes of the series
(c) The data type of underlying data
(d) if the series stores any NaN values