擅长:python、mysql、java
<p>如果您需要更通用的解决方案,请尝试:</p>
<pre><code>#number 15 in range(15) depends of max number of tabs, in my test data
df1 = pd.read_csv('JANAF-FeO.txt', delimiter='\t', names=(range(15)))
#remove columns with all NaN
df1 = df1.dropna(axis=1, how='all')
df1.columns = df1.iloc[1,:]
df1 = df1[2:]
#mask if there are not 7 times NaN in line
mask = df1.isnull().sum(axis=1) != 7
df1 = df1[mask]
print df1
</code></pre>