Python读写csv

# -*- coding: utf-8 -*-
"""
@Time:2019/5/27 11:54
@Author: Cai jz
"""
# import zipfile, os
# os.chdir('C:\\Users\\xa\\Desktop')
# exzip = zipfile.ZipFile('aa.zip')
# exzip.namelist()

# import webbrowser
# webbrowser.open('https://www.runoob.com/python3/python3-os-file-methods.html')

# import openpyxl
#
# wb = openpyxl.load_workbook('example.xlsx')
# type(wb)
# print(wb.sheetnames)
# #wb.get_sheet_names()
# sheet = wb.sheetnames[2]
# print(sheet)

import csv
example = open('1111.csv')
examplereader = csv.reader(example)
# print(examplereader)
# exampledata = list(examplereader)
# print(exampledata)
for row in examplereader:
    print('Row#'+str(examplereader.line_num)+' '+str(row))

import csv
outputFile = open('1111.csv', 'w', newline='')
outputWriter = csv.writer(outputFile)
outputWriter.writerow(['book', 'eggs', 'banana', 'table'])
outputWriter.writerow(['spam', 'eggs', 'bacon', 'ham'])
outputWriter.writerow(['spam', 'eggs', 'bacon', 'ham'])
outputWriter.writerow(['spam', 'eggs', 'bacon', 'ham'])
outputWriter.writerow(['spam', 'eggs', 'bacon', 'ham'])
outputWriter.writerow(['spam', 'eggs', 'bacon', 'ham'])
outputWriter.writerow(['spam', 'eggs', 'bacon', 'ham'])
outputWriter.writerow(['spam', 'eggs', 'bacon', 'ham'])
outputFile.close()

import csv, os
os.makedirs('headerRemoved', exist_ok=True)
# Loop through every file in the current working directory.
for csvFilename in os.listdir('.'):
    if not csvFilename.endswith('.csv'):
        continue # skip non-csv files
    csvRows = []
    csvFileObj = open(csvFilename)
    readerObj = csv.reader(csvFileObj)
    for row in readerObj:
        if readerObj.line_num == 1:
            continue  # skip first row
        csvRows.append(row)
    csvFileObj.close()

    # Write out the CSV file.
    csvFileObj = open(os.path.join('headerRemoved', csvFilename), 'w',newline='')
    csvWriter = csv.writer(csvFileObj)
    for row in csvRows:
        csvWriter.writerow(row)
    csvFileObj.close()
    print('Removing header from ' + csvFilename + '...')
# TODO: Read the CSV file in (skipping first row).
# TODO: Write out the CSV file.
# Read the CSV file in (skipping first row).
print(os.getcwd())