报错data_weather[i][7] = data_weather[i][0].split(' ')[1] IndexError: list index out of range

报错data_weather[i][7] = data_weather[i][0].split(' ')[1] IndexError: list index out of range

问题描述:


import numpy as np
import pandas as pd


data1 = pd.read_csv('result.txt',sep='\t')
data2 = pd.read_csv('日.csv', encoding = 'gbk')
data_weather = pd.read_excel('天气表.xlsx')
data_weather = pd.DataFrame(data_weather)
data1 = pd.DataFrame(data1)
data2 = pd.DataFrame(data2)
data1 = data1['用气量'].groupby(data1['日期']).sum().reset_index()
data2 = data1['用气量'].groupby(data2['日期']).sum().reset_index()
data_weather = np.array(data_weather)

for i in range(data_weather.shape[0]):
        data_weather[i][7] = data_weather[i][0].split(' ')[1]
        data_weather[i][0] = data_weather[i][0].split(' ')[0]

print(data_weather)

data_weather[i][0].split(' ') 之后的数据可能只有一个元素 取不到索引[1],可以打印看看前面split之后的数据是怎样