How to save a file in csv

Python Pandas module helps us to deal with large values of data in terms of datasets. Thus, by using the Pandas module, we can manipulate the data values of huge datasets and deal with it. Pandas deals with the data values and elements in the form of DataFrames.

A DataFrame consists of rows and columns which can be altered and highlighted. So, we use pandas. The big change that needs to be made here is moving your writer.

Just like print executes once for that range , you also need to writerow once per iteration in that range. If you only want one column, why use a CSV file? TimPietzcker I want one column with hi and I will create more than 5 columns like hi, hi, etc in different rows, that's why I'm using a CSV file. Add a comment. Active Oldest Votes. The following code will create a CSV file with one column of numbers ranging from to CodeMonkey CodeMonkey RasedulIslam - use writer.

Rasedul Islam is a new contributor. Be nice, and check out our Code of Conduct. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. If the fields of data in your CSV file contain commas, you can protect them by enclosing those data fields in double quotes ". The commas that are part of your data are kept separate from the commas which delimit the fields themselves. For example, let's say that one of our text fields is a user-created description that allows commas in the description. If our data looked like this:.

To retain the commas in our "Notes" column, we can enclose those fields in quotation marks. For instance:. The same goes for newlines which may be part of your field data.

Any fields containing a newline as part of its data need to be enclosed in double quotes. If your fields contain double quotes as part of their data, the internal quotation marks need to be doubled so they can be interpreted correctly. For instance, given the following data:.

Here, the entire data field is enclosed in quotes, and internal quotation marks are preceded escaped by an additional double quote. In these examples, " CRLF " is used to represent a carriage return and a linefeed which together constitute a newline.