程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
您现在的位置: 程式師世界 >> 編程語言 >  >> 更多編程語言 >> Python

Python read / write CSV file for Python data read / write

編輯:Python

Catalog

1. Read CSV file csv.reader()

2. write in CSV file

1. Read CSV file csv.reader()

The effect of this method is equivalent to that of ',' Division csv Formatted data , And store the segmented data in the list , It also removes the space at the end of the data generated by the final segmentation of each row 、 A newline 、 Tabs and so on .

import csvwith open('data.csv',mode='r',encoding='utf-8-sig',newline='') as File: # Use csv.reader() Read each line of data in the file into a list reader = csv.reader(File, delimiter=',', quotechar=',', quoting=csv.QUOTE_MINIMAL) # Traverse the list to output data in rows for row in reader: print(row)

Directly through Indexes To access the column elements of each row of data

for row in reader: print(row[0])

csv.DictReader()

This method saves each line of data in the file in OrderedDict in , This data type is similar to a list nested with tuples , The first element in each tuple is the key , The second element is the value , The key in the tuple comes from CSV Header information in data .

import csvresults = []with open('data.csv',mode='r',encoding='utf-8-sig',newline='') as File: reader = csv.DictReader(File) for row in reader: print(row)

Read some information through key value

for row in reader: print(row['MakeSpan'],row['WaitTime'])

About DictReader() More content of has not been learned yet , Please refer to other articles if necessary :CSV.DictReader() Method

2. write in CSV file

First, you need to import read / write csv Need a bag :

import csv

Use open() Function to open a file ,open() Common parameters of functions :

file: File path 、 file name

mode: Turn on mode ,r( read-only ),w( Just write ),a( Append mode )

newline: Whether there is an empty line between each line , There are blank lines by default ,' ': There is no vacancy .

myFile = open('example2.csv', 'w', newline='')

csv.writer modular , Used to write data to CSV:

csvfile: this can It's with write() Method .

dialect=‘excel’: An optional parameter , Used to define specific CSV A set of parameters for .

fmtparam: Optional parameters , Can be used to overwrite existing formatting parameters .

writer = csv.writer(myFile)

Use writerow() and writerows() Writes data to CSV In file :

writerow(): Save the data to csv In a line in the file , Each element occupies one cell

writerows(): Save each list in the data to CSV In a line in the file , Each element in the list occupies one cell

myData1 = [[" this ", " yes ", "writerow", " Of ", " effect ", " fruit "], [" this ", " yes ", "writerow", " Of ", " effect ", " fruit "], [" this ", " yes ", "writerow", " Of ", " effect ", " fruit "]]myData2 = [[" this ", " yes ", "writerows", " Of ", " effect ", " fruit "], [" this ", " yes ", "writerows", " Of ", " effect ", " fruit "], [" this ", " yes ", "writerows", " Of ", " effect ", " fruit "]]myFile = open('example2.csv', 'w', newline='')with myFile: writer = csv.writer(myFile) writer.writerow(myData1) writer.writerows(myData2)

The effect of writing a file is as follows :

This is about Python Data read / write Python Reading and writing CSV The article of the document is introduced here , More about Python Reading and writing CSV Please search the previous articles of software development network or continue to browse the relevant articles below. I hope you will support software development network more in the future !



  1. 上一篇文章:
  2. 下一篇文章:
Copyright © 程式師世界 All Rights Reserved