RE: Total Beginner - Extracting Data from a Database Online (Screenshot)

2013-06-12 Thread Carlos Nepomuceno
> Date: Tue, 28 May 2013 07:40:07 +0100 > Subject: RE: Total Beginner - Extracting Data from a Database Online > (Screenshot) > From: pconn...@gmail.com [...] > > > > c11 = [tables[0][r][10] for r in range(len(tables[0]))] > >

RE: Total Beginner - Extracting Data from a Database Online (Screenshot)

2013-05-27 Thread Phil Connell
On 28 May 2013 02:21, "Carlos Nepomuceno" wrote: > > > > Date: Mon, 27 May 2013 17:58:00 -0700 > > Subject: Re: Total Beginner - Extracting Data from a Database Online (Screenshot) > > From: logan.c.gra...@gmail.

RE: Total Beginner - Extracting Data from a Database Online (Screenshot)

2013-05-27 Thread Carlos Nepomuceno
> Date: Mon, 27 May 2013 17:58:00 -0700 > Subject: Re: Total Beginner - Extracting Data from a Database Online > (Screenshot) > From: logan.c.gra...@gmail.com > To: python-list@python.org [...] > > Oh goodness, yes, I have no clue

Re: Total Beginner - Extracting Data from a Database Online (Screenshot)

2013-05-27 Thread logan . c . graham
On Saturday, May 25, 2013 6:33:25 PM UTC-7, John Ladasky wrote: > On Friday, May 24, 2013 4:36:35 PM UTC-7, Carlos Nepomuceno wrote: > > > #to create the tables list > > > tables=[[re.findall('(.*?)',r,re.S) for r in > > re.findall('(.*?)',t,re.S)] for t in > > re.findall('(.*?)',page,re.S)] >

Re: Total Beginner - Extracting Data from a Database Online (Screenshot)

2013-05-25 Thread John Ladasky
On Friday, May 24, 2013 4:36:35 PM UTC-7, Carlos Nepomuceno wrote: > #to create the tables list > tables=[[re.findall('(.*?)',r,re.S) for r in > re.findall('(.*?)',t,re.S)] for t in > re.findall('(.*?)',page,re.S)] > > > Pretty simple. Two nested list comprehensions, with regex pattern matchi

Re: Total Beginner - Extracting Data from a Database Online (Screenshot)

2013-05-25 Thread logan . c . graham
Sorry to be unclear -- it's a screenshot of the webpage, which is publicly accessible, but it contains sensitive information. A bad combination, admittedly, and something that'll be soon fixed. -- http://mail.python.org/mailman/listinfo/python-list

Re: Total Beginner - Extracting Data from a Database Online (Screenshot)

2013-05-24 Thread Chris Angelico
On Sat, May 25, 2013 at 3:32 AM, wrote: > http://i.imgur.com/KgvSKWk.jpg > > What this is is a publicly-accessible webpage... If that's a screenshot of something that we'd be able to access directly, then why not just post a link to the actual thing? More likely I'm thinking it's NOT publicly ac

Re: Total Beginner - Extracting Data from a Database Online (Screenshot)

2013-05-24 Thread Dave Angel
On 05/24/2013 07:36 PM, Carlos Nepomuceno wrote: page = urllib2.urlopen("http://example.com/page.html";).read().strip() #to create the tables list tables=[[re.findall('(.*?)',r,re.S) for r in re.findall('(.*?)',t,re.S)] for t in re.findall('(.*?)',page,re.S)] Pretty simple. Good luck!

RE: Total Beginner - Extracting Data from a Database Online (Screenshot)

2013-05-24 Thread Carlos Nepomuceno
### table_data_extraction.py ### # Usage: table[id][row][column] # tables[0]   : 1st table # tables[1][2]    : 3rd row of 2nd table # tables[3][4][5] : cell content of 6th column of 5th row of 4th table # len(table)  : quantity of tables # len(table[6])   : quantity of rows of 7th table # l

Re: Total Beginner - Extracting Data from a Database Online (Screenshot)

2013-05-24 Thread Dave Angel
On 05/24/2013 01:32 PM, logan.c.gra...@gmail.com wrote: Hey guys, I'm learning Python Welcome. and I'm experimenting with different projects -- I like learning by doing. I'm wondering if you can help me here: na What this is is a publicly-accessible webpage No, it's just a jpeg file, an