python之读取和写入csv文件

写入csv文件源码：

 #输出数据写入CSV文件

 import csv

 data = [

     ("Mike", "male", 24),

     ("Lee", "male", 26),

     ("Joy", "female", 22)

 ]

 #Python3.4以后的新方式，解决空行问题

 with open('d://write.csv', 'w', newline='') as csv_file:

     csv_writer = csv.writer(csv_file)

     for list in data:

         print(list)

         csv_writer.writerow(list)

读取csv文件源码：

 #读取csv文件内容

 import csv

 list  = []

 reader = csv.reader(open("d://demo.csv"))

 #csv中有三列数据，遍历读取时使用三个变量分别对应

 for title, year, director in reader:

   list.append(year)

   print(title, "; ",  year , "; ",  director)

 print(list)

读取运行结果：

 

 

读取csv文件内容更多方式：

 # 读取csv文件内容

 # date：2017-08-26

 import csv

 file = "d://write.csv"

 def csv_read(file):

     '''

     获取每个元素

     :param file: 读取文件

     :return: 元素列表

     '''

     with open(file) as file:

         list = []

         csv_reader = csv.reader(file)

         for id, data, *args in csv_reader:

             # 跳过表头

             if id == "   ":

                 continue

             print(id, data)

             list.append(data)

         return list

 def csv_read_by_next(file):

     '''

     逐行取值

     :param file: 读取文件

     :return: 逐行打印内容（列表形式）

     '''

     with open(file) as file:

         csv_reader = csv.reader(file)

         while True:

             try:

                 csv_next_row = next(csv_reader)

             except:

                 break

             else:

                 print(csv_next_row)

 csv_read_by_next(file)

 '''

 ['Mike', 'male', '24']

 ['Lee', 'male', '26']

 ['Joy', 'female', '22']

 '''