Skip header of Excel file

preprocessing.py

# coding: utf-8

# In[1]:

import openpyxl
import csv


# In[2]:

wb = openpyxl.load_workbook('disaggreation_data.xlsx')


# In[12]:

for sheet_name in wb.get_sheet_names():
    sheet = wb.get_sheet_by_name(sheet_name)
    
    col1 = []
    cnt = 1
    for i in sheet['A']:
        if cnt <= 6:
            cnt += 1
            continue   
        col1.append(str(i.value).split(' ')[0])
    
    col2 = []
    cnt = 1
    for i in sheet['B']:
        if cnt <= 6:
            cnt += 1
            continue
        col2.append(i.value)
    
    data = zip(col1, col2)
        
    with open(str(sheet_name)+'.csv','wb') as out:
        csv_out=csv.writer(out)
        for row in data:
            csv_out.writerow(row)