Aug-17-2021, 01:40 PM
(This post was last modified: Aug-17-2021, 01:40 PM by johnbernard.)
Hi All,
I have just begun learning Python for the last couple of months and I have got to grips with the very basics I think having no background in coding.
I want to build a script that:
1) Identifies the latest created folder in one of my document folders
2) Takes all the spreadsheets in the latest created folder and merges them into one single spreadsheet (they all have the same column headings) (previously I was using the excel "get data" function myself).
3) Extracts relevant rows from the merged spreadsheet by filtering for a list of URLs that I have compiled and outputting all these. i.e. output any rows that contain specific URLs
I do all this manually at the moment and I'm thinking the 30 mins I save doing this everyday could be put to a lot better use!
If anyone has any pointers/tips for getting started/ what I should be looking at to do this I would really appreciate it, thank you!
John B
I have just begun learning Python for the last couple of months and I have got to grips with the very basics I think having no background in coding.
I want to build a script that:
1) Identifies the latest created folder in one of my document folders
2) Takes all the spreadsheets in the latest created folder and merges them into one single spreadsheet (they all have the same column headings) (previously I was using the excel "get data" function myself).
3) Extracts relevant rows from the merged spreadsheet by filtering for a list of URLs that I have compiled and outputting all these. i.e. output any rows that contain specific URLs
I do all this manually at the moment and I'm thinking the 30 mins I save doing this everyday could be put to a lot better use!
If anyone has any pointers/tips for getting started/ what I should be looking at to do this I would really appreciate it, thank you!
John B