擅长:python、mysql、java
<p>当您读入csv时,应该使用<code>skipinitialspace</code>选项删除数据中的前导空格。请注意,由于列名是用引号括起来的,因此它们周围的空格将保留</p>
<pre class="lang-py prettyprint-override"><code># make fake csv
from io import StringIO
mock_csv = StringIO()
mock_csv.write("""\
" DATE TIME "," A "," C "," B "
12/11/2018 15:44:36, 5448, 0.00, NaN
12/11/2018 15:44:36, 5448, 0.00, NaN
12/11/2018 15:44:36, 5448, 0.00, NaN
12/11/2018 15:44:36, 5448, 0.00, NaN
12/11/2018 15:45:07, 5448, 0.00, NaN
12/11/2018 15:45:08, 5448, 0.00, NaN
12/11/2018 15:45:08, 5448, 0.00, NaN
12/11/2018 15:45:09, 5448, 0.00, NaN
12/11/2018 15:45:09, 5448, 0.00, NaN
""")
mock_csv.seek(0)
# disregard initial whitespace
df = pd.read_csv(mock_csv, skipinitialspace=True)
assert df[' B '].hasnans
</code></pre>
<p>参见文档<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_csv.html?highlight=skipinitialspace" rel="nofollow noreferrer">here</a></p>