擅长:python、mysql、java
<p>可能检查列名是否已列出<code>confidence</code>,如果未列出,则中断</p>
<pre><code>import pandas as pd
import numpy as np
from pathlib import Path
import glob as glob
inp_dir = Path(r'C:/Users/jtharian/Desktop/bbc/')
for file in inp_dir.glob('*.csv'):
df = pd.read_csv(file, sep=',', quotechar='|',error_bad_lines=False)
if 'confidence' not in df.columns:
print('filename: ' + str(file))
break
df['confidence'] = df['confidence'].replace(np.nan, 0.01)
df.to_csv(file,index=False)
</code></pre>