blob: cf3d205ec56045de4c6708f554394093ca8a9994 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
|
#! python3
# Chapter 14 Project Removing the Header from CSV Files
# Removes the header from all CSV files in the current working
# directory.
import os
import csv
os.makedirs('headerRemoved', exist_ok=True)
for csvFilename in os.listdir('.'):
if not csvFilename.endswith('.csv'):
continue
print('Removing header from ' + csvFilename + '...')
csvRows = []
csvFileObj = open(csvFilename)
readerObj = csv.reader(csvFileObj)
for row in readerObj:
if readerObj.line_num == 1:
continue
csvRows.append(row)
csvFileObj.close()
csvFileObj = open(os.path.join('headerRemoved', csvFilename), 'w', newline='')
csvWriter = csv.writer(csvFileObj)
for row in csvRows:
csvWriter.writerow(row)
csvFileObj.close()
|
