BeautifulSoup get all the values of a particular column

Question

I am using BeautifulSoup to parse html. So far I have the following code: ``` url = "http://routerpasswords.com" data = {"findpass":"1", "router":"Belkin", "findpassword":"Find Password"} post_data = urllib.urlencode(data) req = urllib2.urlopen(url, post_data) html_str = req.read() parser = new BeautifulSoup(html_str) table = parser.find("table") ``` Is there a way to get a list of all of the cels under `column`? Here is an example: If I had this table: ```

Manufacturer	Model	Protocol	Username	Password
BELKIN	F5D6130	SNMP	(none)	MiniAP
BELKIN	F5D7150 Rev. FB	MULTI	n/a	admin
BELKIN	F5D8233-4	HTTP	(blank)	(blank)
BELKI…

Accepted Answer

```
from BeautifulSoup import BeautifulSoup
soup = BeautifulSoup(open("file.html",'r').read())
cols = [header.string for header in soup.find('thead').findAll('th')]
col_idx = cols.index('Username')
col_values = [td[col_idx].string 
              for td in [tr.findAll('td') 
                         for tr in soup.find('tbody').findAll('tr')]]
print(col_values)
```

results in:

[u'(none)', u'n/a', u'(blank)', u'admin']

BeautifulSoup get all the values of a particular column

Solution

Problem