擅长:python、mysql、java
<p>这就是编码问题</p>
<pre class="lang-python prettyprint-override"><code> ...: df = pd.DataFrame(np.random.randint(3,10,16).reshape(4,4), columns=['\ufeffa1', 'b1', 'a2', 'b2'])
...: df.head()
Out[3]:
a1 b1 a2 b2
0 7 7 9 6
1 5 9 6 7
2 4 8 4 3
3 6 9 8 7
In [4]: df.columns
Out[4]: Index(['a1', 'b1', 'a2', 'b2'], dtype='object')
In [5]: df.columns.to_list()
Out[5]: ['\ufeffa1', 'b1', 'a2', 'b2']
In [6]: df.columns = pd.Series(df.columns).apply(lambda x:x.encode('utf-8').decode('utf-8-sig'))
In [7]: df.columns
Out[7]: Index(['a1', 'b1', 'a2', 'b2'], dtype='object')
In [8]: df.columns.to_list()
Out[8]: ['a1', 'b1', 'a2', 'b2']
</code></pre>