oracle avg 不忽略空值,忽略python中的空值列

你好像没有分离器。我为你的案子用了很多空格。并用空白填充空白。在

试试这个：#!/usr/bin/env python

# -*- coding:utf-8 -*-

aengg = []

iauth = []

with open('C:\\temp\\test.txt') as f:

for i, row in enumerate(f):

columns = row.split()

if len(columns) == 2:

# when there are more than 17 spaces between two elements, I consider it as a third element in the row, then I add a None between them

if row.index(columns[1]) > 17:

columns.insert(1, None)

# if there are less than 17 spaces between two elements, I consider it as the second element in the row, then I add a None to the tail

else:

columns.append(None)

print columns

aengg.append(columns[2])

iauth.append(columns[1])

print aengg

print iauth

这是输出。在

^{pr2}$