Python-сообщество

 import xlrd
 
file_location = "E:/FIRES.xls"
workbook = xlrd.open_workbook(file_location)
sheet = workbook.sheet_by_index(0)
print (sheet.nrows)
print (sheet.ncols)
 
date = sheet.cell_value(1, 0)
true = xlrd.xldate.xldate_as_datetime(date, workbook.datemode)
check_year = str(true).split('-')[0]
 
print (check_year)
 
array_one = []
array_two = []
test = []
 
for row in range(1, sheet.nrows, 1):
    del array_two[:]
    for col in range(sheet.ncols):
        array_two.append(sheet.cell(row, col))
 
    date = sheet.cell_value(row, 0)
    true = xlrd.xldate.xldate_as_datetime(date, workbook.datemode)
    year = str(true).split('-')[0]
    del array_two[0]
    array_two.insert(0, year)
    array_two.insert(0, true)
    array_one.append(array_two)
    if year == check_year:
        test.append(array_two)
    else:
        print (test)
        check_year = year
        test = []

 import pandas as pd                                                              
data = pd.read_excel('FIRES.xls')                                                
print(data.info()) # Информация о загруженных данных (до интерполяции)
print(data.interpolate().info())  # выводит информацио о данных после интерполяции (линейной) пропущенных данных

 <class 'pandas.core.frame.DataFrame'>
RangeIndex: 2760 entries, 0 to 2759
Data columns (total 11 columns):
date         2760 non-null datetime64[ns]
proton1      2712 non-null float64
proton2      2712 non-null float64
proton3      2712 non-null float64
electron1    2747 non-null float64
electron2    2747 non-null float64
fluks107     2760 non-null int64
speed        2754 non-null float64
np           2754 non-null float64
temp         2484 non-null float64
newfires     2664 non-null float64
dtypes: datetime64[ns](1), float64(9), int64(1)
memory usage: 237.3 KB
==================== Далее идет то, что после интерполяции:
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 2760 entries, 0 to 2759
Data columns (total 11 columns):
date         2760 non-null datetime64[ns]
proton1      2760 non-null float64
proton2      2760 non-null float64
proton3      2760 non-null float64
electron1    2760 non-null float64
electron2    2760 non-null float64
fluks107     2760 non-null int64
speed        2760 non-null float64
np           2760 non-null float64
temp         2760 non-null float64
newfires     2760 non-null float64
dtypes: datetime64[ns](1), float64(9), int64(1)
memory