Python file format txt converted to CSV format

Source: Internet
Author: User

1 txt file read

Open (file, mode= ' R ', Buffering=-1, Encoding=none, Errors=none, Newline=none, Closefd=true, Opener=none)

The parameter file is a filename, such as ' file.txt '; mode is a pattern opened on a file, other parameters are generally not used.

Parameter explanation for function open:

The default is read-only in the open function. Other modes are:

W: Open in write mode

A: Open in Append mode

r+: Open in read-write mode

w+: Punch in read-write mode

RB: Open in binary read mode

WB: Open in binary write mode

AB: Open in binary append mode

rb+: Open in binary read/write mode

wb+: Open in binary read/write mode

ab+: Open in binary append mode

Common methods for open objects:

Read (): reads bytes into a string

ReadLine (): Open a line of the file, including line terminator

ReadLine (): Open file, read all rows

Write (): writes a string to the file and writes to the object as a string

Writelines (): Writes the list to a file, and the object is a list.

Seek (): offset

Tell (): Returns the position of the current file pointer

2 csv Read and write

Module CSV, read and write functions are required:

Read function

Reader (CSVFile, dialect= ' Excel ', **fmtparams)

Parameter description:

CSVFile, must be an object that supports iterations (Iterator), which can be a file object or a list object, or a file object that requires a "B" flag parameter when opened.

dialect, coding style, the default is the style of Excel, that is, separated by commas (,), dialect mode also supports customization, by calling the Register_dialect method to register, the following will be mentioned.

Fmtparam, a format parameter used to override the encoding style specified by the previous dialect object.

Write function

Writer (csvfile, dialect= ' Excel ', **fmtparams)

parameter meaning ibid.

3 examples
Reader = open ('Data.txt') List_data=reader.readlines () columns=List_data [0].split () List= [] forIinchList_data [1:]: List.append (I.split ()) with open ("Test.csv","WB") as Csvfile:writer=Csv.writer (csvfile)#Write Columns_name Firstwriter.writerow (columns)#write multiple lines with writerowsWriter.writerows (list)

Parsing of Write Data:

The open () function first opens the file with the name ' Test.csv ' under the current path and if the file does not exist, it is created, returning the CSVFile file object.

Csv.writer (CSVFile) Returns the writer object mywriter.

The Writerow () method is written one line at a time, and the Writerows method writes multiple rows at once.

Note: If the file ' Test.csv ' is pre-existing, calling the writer function empties the text in the original file before executing the Writerow/writerows method.

Python file format txt converted to CSV format

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.