错误改正：import xlrd import numpy as np wb=xlrd.open("历年总人口.xls") sheet=wb.sheet_by_index(0) col_0=sheet.col_values(0) col_1=sheet.col_values(1) col_2=sheet.col_values(2) col_4=sheet.col_values(4) year=col_0[38:] total=col_1[38:] man=col_2[38:] woman=col_4[38:] year=[int(c) for c in year] total=[int(c) for c in total] man=[int(c) for c in man] woman=[int(c) for c in woman] arr=np.array(year).reshape(m,1) arr=np.insert(arr,1,values=total,axis=1) arr=np.insert(arr,1,values=man,axis=1) arr=np.insert(arr,1,values=woman,axis=1) file='历年总人口.csv' np.savetxt(file,arr,fmt='%i',delimiter=',',comments='',header='年份,年末总人口,男性人口,女性人口') x=np.loadtxt(file,dtype=np.int,,delimiter=',',skiprows=1) print(x)

import xlrd
import numpy as np

wb = xlrd.open_workbook("历年总人口.xls")
sheet = wb.sheet_by_index(0)

col_0 = sheet.col_values(0)[38:]
col_1 = sheet.col_values(1)[38:]
col_2 = sheet.col_values(2)[38:]
col_4 = sheet.col_values(4)[38:]

year = [int(c) for c in col_0]
total = [int(c) for c in col_1]
man = [int(c) for c in col_2]
woman = [int(c) for c in col_4]

m = len(year)

arr = np.array(year).reshape(m,1)
arr = np.insert(arr,1,values=total,axis=1)
arr = np.insert(arr,1,values=man,axis=1)
arr = np.insert(arr,1,values=woman,axis=1)

file='历年总人口.csv'
np.savetxt(file,arr,fmt='%i',delimiter=',',comments='',header='年份,年末总人口,男性人口,女性人口')

x = np.loadtxt(file,dtype=np.int,delimiter=',',skiprows=1)
print(x)