python替换缺失值_用Python替换缺失值

I want to substitute missing values (None) with the last previous known value. This is my code. But it doesn't work. Any suggestions for a better algorithm?

t = [[1, 3, None, 5, None], [2, None, None, 3, 1], [4, None, 2, 1, None]]

def treat_missing_values(table):

for line in table:

for value in line:

if value == None:

value = line[line.index(value)-1]

return table

print treat_missing_values(t)

解决方案

This is probably how I'd do it:

>>> def treat_missing_values(table):

... for line in table:

... prev = None

... for i, value in enumerate(line):

... if value is None:

... line[i] = prev

... else:

... prev = value

... return table

...

>>> treat_missing_values([[1, 3, None, 5, None], [2, None, None, 3, 1], [4, None, 2, 1, None]])

[[1, 3, 3, 5, 5], [2, 2, 2, 3, 1], [4, 4, 2, 1, 1]]

>>> treat_missing_values([[None, 3, None, 5, None], [2, None, None, 3, 1], [4, None, 2, 1, None]])

[[None, 3, 3, 5, 5], [2, 2, 2, 3, 1], [4, 4, 2, 1, 1]]