擅长:python、mysql、java
<p>添加列表连接内容:</p>
<pre><code>In [17]: [1] + [2,3]
Out[17]: [1, 2, 3]
</code></pre>
<p>即使内容本身是列表,也是如此:</p>
<pre><code>In [18]: [[1]] + [[2],[3]]
Out[18]: [[1], [2], [3]]
</code></pre>
<p>所以:</p>
<pre><code>In [13]: header = ['name','address','phonenum']
In [14]: data = [['Tom','dublin','12345'],['Bob','Kerry','56789']]
In [15]: [header] + data
Out[15]:
[['name', 'address', 'phonenum'],
['Tom', 'dublin', '12345'],
['Bob', 'Kerry', '56789']]
In [16]: pd.DataFrame(data, columns=header)
Out[16]:
name address phonenum
0 Tom dublin 12345
1 Bob Kerry 56789
</code></pre>
<p>注意,从数据库加载数据帧也可以通过<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_sql.html" rel="nofollow">pandas.read_sql</a>完成。你知道吗</p>