issues changing the directory name in order to find files to be able to extract sheets from two excels and...
up vote
-1
down vote
favorite
I have a prior year file and a current year file. I want the sheets of both to be extracted and put into one file. I was also hoping later to improve this by using some sort of function that could identify which was the correct file to pick instead of specifying (the file from the current year and prior year with contain a code within the file name, but the file name and formats will still differ e.g. "AB123").
I've tried a few solution but I am struggling to understand them so if you could explain that would be much appreciated :)
Initially I tried using PBPython instructions which said to start with the folowing
!ls ../in
I got stuck on this as it wasn't working when I was typing this in. I then thought that I needed to set the correct directory or where it was looking at so I then searched up changing the directory using cd then typing the folder I wanted it to look at but then this kept changing.
[24]: cd
C:Usersxx In
[25]: cd documents
C:Usersxxdocuments In
[34]: cd
C:Usersxx
I was expecting my change to be retained but it didn't
I then tried using os.getcwd and chrdir but it didn't change the directory using cd...
python
edited Nov 19 at 14:33
toti08
1,69711523
asked Nov 19 at 13:56
jimmyjamjom
12
add a comment |
up vote
-1
down vote
favorite
I have a prior year file and a current year file. I want the sheets of both to be extracted and put into one file. I was also hoping later to improve this by using some sort of function that could identify which was the correct file to pick instead of specifying (the file from the current year and prior year with contain a code within the file name, but the file name and formats will still differ e.g. "AB123").
I've tried a few solution but I am struggling to understand them so if you could explain that would be much appreciated :)
Initially I tried using PBPython instructions which said to start with the folowing
!ls ../in
I got stuck on this as it wasn't working when I was typing this in. I then thought that I needed to set the correct directory or where it was looking at so I then searched up changing the directory using cd then typing the folder I wanted it to look at but then this kept changing.
[24]: cd
C:Usersxx In
[25]: cd documents
C:Usersxxdocuments In
[34]: cd
C:Usersxx
I was expecting my change to be retained but it didn't
I then tried using os.getcwd and chrdir but it didn't change the directory using cd...
python
edited Nov 19 at 14:33
toti08
1,69711523
asked Nov 19 at 13:56
jimmyjamjom
12
so initially I tried using PBPython instructions which said to start with the folowing !ls ../in I got stuck on this as it wasn't working when I was typing this in. I then thought that I needed to set the correct directory or where it was looking at so I then searched up changing the directory using cd then typing the folder I wanted it to look at but then this kept changing. [24]: cd C:Usersxx In [25]: cd documents C:Usersxxdocuments In [34]: cd C:Usersxx I then tried using os.getcwd and chrdir but it didn't change the directory using cd...
– jimmyjamjom
Nov 19 at 14:07
updated the question
– jimmyjamjom
Nov 19 at 14:29
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I have a prior year file and a current year file. I want the sheets of both to be extracted and put into one file. I was also hoping later to improve this by using some sort of function that could identify which was the correct file to pick instead of specifying (the file from the current year and prior year with contain a code within the file name, but the file name and formats will still differ e.g. "AB123").
I've tried a few solution but I am struggling to understand them so if you could explain that would be much appreciated :)
Initially I tried using PBPython instructions which said to start with the folowing
!ls ../in
I got stuck on this as it wasn't working when I was typing this in. I then thought that I needed to set the correct directory or where it was looking at so I then searched up changing the directory using cd then typing the folder I wanted it to look at but then this kept changing.
[24]: cd
C:Usersxx In
[25]: cd documents
C:Usersxxdocuments In
[34]: cd
C:Usersxx
I was expecting my change to be retained but it didn't
I then tried using os.getcwd and chrdir but it didn't change the directory using cd...
python
edited Nov 19 at 14:33
toti08
1,69711523
asked Nov 19 at 13:56
jimmyjamjom
12
I have a prior year file and a current year file. I want the sheets of both to be extracted and put into one file. I was also hoping later to improve this by using some sort of function that could identify which was the correct file to pick instead of specifying (the file from the current year and prior year with contain a code within the file name, but the file name and formats will still differ e.g. "AB123").
I've tried a few solution but I am struggling to understand them so if you could explain that would be much appreciated :)
Initially I tried using PBPython instructions which said to start with the folowing
!ls ../in
I got stuck on this as it wasn't working when I was typing this in. I then thought that I needed to set the correct directory or where it was looking at so I then searched up changing the directory using cd then typing the folder I wanted it to look at but then this kept changing.
[24]: cd
C:Usersxx In
[25]: cd documents
C:Usersxxdocuments In
[34]: cd
C:Usersxx
I was expecting my change to be retained but it didn't
I then tried using os.getcwd and chrdir but it didn't change the directory using cd...
python
python
edited Nov 19 at 14:33
toti08
1,69711523
asked Nov 19 at 13:56
jimmyjamjom
12
edited Nov 19 at 14:33
toti08
1,69711523
asked Nov 19 at 13:56
jimmyjamjom
12
edited Nov 19 at 14:33
toti08
1,69711523
edited Nov 19 at 14:33
toti08
1,69711523
edited Nov 19 at 14:33
toti08
1,69711523
1,69711523
asked Nov 19 at 13:56
jimmyjamjom
12
asked Nov 19 at 13:56
jimmyjamjom
12
asked Nov 19 at 13:56
jimmyjamjom
12
12
so initially I tried using PBPython instructions which said to start with the folowing !ls ../in I got stuck on this as it wasn't working when I was typing this in. I then thought that I needed to set the correct directory or where it was looking at so I then searched up changing the directory using cd then typing the folder I wanted it to look at but then this kept changing. [24]: cd C:Usersxx In [25]: cd documents C:Usersxxdocuments In [34]: cd C:Usersxx I then tried using os.getcwd and chrdir but it didn't change the directory using cd...
– jimmyjamjom
Nov 19 at 14:07
updated the question
– jimmyjamjom
Nov 19 at 14:29
add a comment |
so initially I tried using PBPython instructions which said to start with the folowing !ls ../in I got stuck on this as it wasn't working when I was typing this in. I then thought that I needed to set the correct directory or where it was looking at so I then searched up changing the directory using cd then typing the folder I wanted it to look at but then this kept changing. [24]: cd C:Usersxx In [25]: cd documents C:Usersxxdocuments In [34]: cd C:Usersxx I then tried using os.getcwd and chrdir but it didn't change the directory using cd...
– jimmyjamjom
Nov 19 at 14:07
updated the question
– jimmyjamjom
Nov 19 at 14:29
so initially I tried using PBPython instructions which said to start with the folowing !ls ../in I got stuck on this as it wasn't working when I was typing this in. I then thought that I needed to set the correct directory or where it was looking at so I then searched up changing the directory using cd then typing the folder I wanted it to look at but then this kept changing. [24]: cd C:Usersxx In [25]: cd documents C:Usersxxdocuments In [34]: cd C:Usersxx I then tried using os.getcwd and chrdir but it didn't change the directory using cd...
– jimmyjamjom
Nov 19 at 14:07
so initially I tried using PBPython instructions which said to start with the folowing !ls ../in I got stuck on this as it wasn't working when I was typing this in. I then thought that I needed to set the correct directory or where it was looking at so I then searched up changing the directory using cd then typing the folder I wanted it to look at but then this kept changing. [24]: cd C:Usersxx In [25]: cd documents C:Usersxxdocuments In [34]: cd C:Usersxx I then tried using os.getcwd and chrdir but it didn't change the directory using cd...
– jimmyjamjom
Nov 19 at 14:07
updated the question
– jimmyjamjom
Nov 19 at 14:29
updated the question
– jimmyjamjom
Nov 19 at 14:29
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53376187%2fissues-changing-the-directory-name-in-order-to-find-files-to-be-able-to-extract%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
so initially I tried using PBPython instructions which said to start with the folowing !ls ../in I got stuck on this as it wasn't working when I was typing this in. I then thought that I needed to set the correct directory or where it was looking at so I then searched up changing the directory using cd then typing the folder I wanted it to look at but then this kept changing. [24]: cd C:Usersxx In [25]: cd documents C:Usersxxdocuments In [34]: cd C:Usersxx I then tried using os.getcwd and chrdir but it didn't change the directory using cd...
– jimmyjamjom
Nov 19 at 14:07
updated the question
– jimmyjamjom
Nov 19 at 14:29