擅长:python、mysql、java
<p>我在从已处理的<code>read_html</code>中选择<code>DataFrame</code>并使用基于多索引的方法选择所需列时得到了解决方案。多亏了Adrew对这件事的想法。。在</p>
<p>代码如下所示。。。可能对某人有帮助</p>
<pre><code>import pandas as pd
##### Python pandas, widen output display to see more columns. ####
pd.set_option('display.height', None)
pd.set_option('display.max_rows', None)
pd.set_option('display.max_columns', None)
pd.set_option('display.width', None)
pd.set_option('expand_frame_repr', True)
###### Data Extraction ##################
'''
pd.read_html returns you a list with one element and that
element is the pandas dataframe, i.e.
Data = pd.read_html('url') will produce a list
Data[0] Will return a pandas DataFrame
'''
Data = pd.read_html('http://openstacksearch/vm_list.html', header=0, flavor='bs4')[0]
Data1 = Data[['VM Name', 'User Name', 'Network', 'Region']]
print(Data1)
</code></pre>