擅长:python、mysql、java
<pre><code>import pandas as pd
data = pd.read_csv(filePath,header=None)
data['_1st_absent_on'] = None
for row in range(1, data.shape[0]):
for col in range(data.shape[1]-1):
#print(data[col][row])
if data[col][row] == '.':
print('{} 1st absent on: {}'.format(data[0][row], data[col][0]))
data.iloc[row, data.shape[1]-1] = col+1
break
</code></pre>