Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #19972

Re: Reading files in from the proper directory

Show key headers only | View raw

On 02/07/2012 01:14 PM, SMac2347@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 confident most of the code is correct, as the program runs
> without any errors and I found the base of it online, making changes
> as necessary for my own purposes. However, I am having trouble
> specifying the exact directory where my code should be pulling the
> files from. All the files are in the same folder, and I have put the
> folder on my desktop. Am I correct in thinking that I need to change
> the current working directory to this folder in order for Python to
> read in these files,
No, Python certainly does not constrain you to working with files only 
in the current working directory.  My rule of thumb is never to change 
the cwd in a Python program.  You can use relative paths to open files, 
or you can use absolute paths.  There is even a library function 
os.path.abspath() for converting a relative path to an absolute one.

If you do change cwd during the running of a program, then relative 
filenames that worked earlier might no longer work.  You could convert 
them all to absolute paths, but that's more work.

You can piece together path strings using os.path.join().  It's smart 
enough to know the path separator for your particular platform.

Check out this page: http://docs.python.org/library/os.path.html

> then generate my output? Or should I be doing
> something else?
>
> Any and all help is appreciated, thanks!
>


-- 

DaveA

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Reading files in from the proper directory SMac2347@comcast.net - 2012-02-07 10:14 -0800
  Re: Reading files in from the proper directory Dave Angel <d@davea.name> - 2012-02-07 13:40 -0500
    Re: Reading files in from the proper directory SMac2347@comcast.net - 2012-02-07 11:03 -0800
  Re: Reading files in from the proper directory Peter Otten <__peter__@web.de> - 2012-02-07 19:59 +0100
    Re: Reading files in from the proper directory SMac2347@comcast.net - 2012-02-07 11:13 -0800
      Re: Reading files in from the proper directory John Gordon <gordon@panix.com> - 2012-02-07 20:00 +0000
      Re: Reading files in from the proper directory Peter Otten <__peter__@web.de> - 2012-02-07 21:16 +0100
        Re: Reading files in from the proper directory SMac2347@comcast.net - 2012-02-09 12:32 -0800
          Re: Reading files in from the proper directory Peter Otten <__peter__@web.de> - 2012-02-09 22:07 +0100
          Re: Reading files in from the proper directory Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2012-02-09 23:05 -0500
        Re: Reading files in from the proper directory SMac2347@comcast.net - 2012-02-09 12:36 -0800
  Re: Reading files in from the proper directory John Gordon <gordon@panix.com> - 2012-02-07 19:46 +0000

csiph-web