擅长:python、mysql、java
<p>使用<code>pd.read_csv</code>和<code>nrows=1</code>从CSV中获取列标题,然后使用<code>usecols</code>执行后续读取,以提取除了要忽略的列之外的所有内容。</p>
<pre><code>headers = [*pd.read_csv('sample.csv', nrows=1)]
df = pd.read_csv('sample.csv', usecols=[c for c in headers if c != 'name']))
</code></pre>
<p>或者,您也可以使用CSV模块执行同样的操作(只读取标题)<strong>非常有效</strong></p>
<pre><code>import csv
with open("sample.csv", 'r') as f:
header = next(csv.reader(f))
# For python 2, use
# header = csv.reader(f).next()
df = pd.read_csv('sample.csv', usecols=list(set(header) - {'name'}))
</code></pre>