HTML Code - Line Number

2012-04-27 Thread SMac2347
Hello, For scrapping purposes, I am having a bit of trouble writing a block of code to define, and find, the relative position (line number) of a string of HTML code. I can pull out one string that I want, and then there is always a line of code, directly beneath the one I can pull out, that begin

Re: Web Scraping - Output File

2012-04-26 Thread SMac2347
On Apr 26, 2:19 pm, Kiuhnm wrote: > On 4/26/2012 19:54, smac2...@comcast.net wrote: > > > > > > > > > > > Hello, > > > I am having some difficulty generating the output I want from web > > scraping. Specifically, the script I wrote, while it runs without any > > errors, is not writing to the outpu

Web Scraping - Output File

2012-04-26 Thread SMac2347
Hello, I am having some difficulty generating the output I want from web scraping. Specifically, the script I wrote, while it runs without any errors, is not writing to the output file correctly. It runs, and creates the output .txt file; however, the file is blank (ideally it should be populated

Python and Bloomberg

2012-04-03 Thread SMac2347
Hello, I was just wondering if anyone had experience using Python to interact with Bloomberg. Ideally, I'd look to use Python to feed Bloomberg's OVML calculator with a list of inputs, and then use an additional program to grab the results of the calculator for each calculation, and pull them into

Python to Combine Multiple Excel Worksheets into One Worksheet

2012-02-15 Thread SMac2347
Hello, I have one single Excel file with many separate worksheets, and for work I need to combine all these separate worksheets into one single worksheet (I am not worried about formatting, as the format is the same in each sheet, nor am I worried about Excel's row limit). Essentially, I am lookin

Re: Reading files in from the proper directory

2012-02-09 Thread SMac2347
On Feb 7, 3:16 pm, Peter Otten <__pete...@web.de> wrote: > smac2...@comcast.net wrote: > > xls_files   = glob.glob(in_dir + "*.xls") > > Try changing that to > > pattern = os.path.join(in_dir, "*.xls") > xls_files = glob.glob(pattern) > > os.path.join() inserts a (back)slash between directory and f

Re: Reading files in from the proper directory

2012-02-09 Thread SMac2347
On Feb 7, 3:16 pm, Peter Otten <__pete...@web.de> wrote: > smac2...@comcast.net wrote: > > xls_files   = glob.glob(in_dir + "*.xls") > > Try changing that to > > pattern = os.path.join(in_dir, "*.xls") > xls_files = glob.glob(pattern) > > os.path.join() inserts a (back)slash between directory and f

Re: Reading files in from the proper directory

2012-02-07 Thread SMac2347
On Feb 7, 1:40 pm, Dave Angel wrote: > On 02/07/2012 01:14 PM, smac2...@comcast.net wrote:> Hello. I am admittedly a > Python novice, and ran into some trouble > > trying to write a program that will pull multiple excel files all into > > one file, with each file on a different sheet. > > > I am

Re: Reading files in from the proper directory

2012-02-07 Thread SMac2347
Thanks for the responses. Below is the code I have thus far. while the program runs glitch-free, it only results in the printing of the message: "NOTE *** No xls files in C:/Documents and Settings/smacdon/." as specified by my code. Any idea as to why it might be unable to find the .xls documents

Reading files in from the proper directory

2012-02-07 Thread SMac2347
Hello. I am admittedly a Python novice, and ran into some trouble trying to write a program that will pull multiple excel files all into one file, with each file on a different sheet. I am confident most of the code is correct, as the program runs without any errors and I found the base of it onli