擅长:python、mysql、java
<p>下面是一些示例代码,显示了一些可能有帮助的内容。我们使用带有过滤<code>if</code>语句的嵌套理解,以确保我们不会试图访问不存在的dict项。在</p>
<pre><code>In [3]: def importCSVtoTable(file, table, columns):
...: # 'mock' data to simulate a reader
...: reader = [{'SEGMENT': 2, 'Comp 1': 'dogs'}, {'Comp 2': 'cats', 'OTHERTHING': 4}
...: print [[row[label] for label in columns if label in row] for row in reader]
...:
In [4]: importCSVtoTable(None, None, ['SEGMENT', 'Comp 1'])
[[2, 'dogs'], []]
In [5]: importCSVtoTable(None, None, ['SEGMENT', 'Comp 1', 'Comp 2'])
[[2, 'dogs'], ['cats']]
</code></pre>