Omar Arain OmarArain
OmarArain
/ xldate_to_datetime.py
Created
April 3, 2014 17:48
convert Excel serial date to python datetime.datetime
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import datetime | |
| def xldate_to_datetime(xldate): | |
| temp = datetime.datetime(1900, 1, 1) | |
| delta = datetime.timedelta(days=xldate) | |
| return temp+delta |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| datetime.strftime(datetime.now(),'%Y%m%d %H:%M:%S') |
OmarArain
/ change_filepath_if_exists
Created
January 9, 2014 16:54
if file exists, adds an '_1' to filename. If '_x' (where x is a number) exists, then it increments x. Intelligent renaming of filepaths?
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| def change_filepath_if_exists(filepath): | |
| f, ext = os.path.splitext(filepath) | |
| if os.path.exists(filepath): | |
| if f[f.rfind('_')+1:].isdigit(): | |
| oldnum = f[f.rfind('_')+1:] | |
| newnum = str(int(oldnum)+1) | |
| newf = f[0:-len(oldnum)] + newnum | |
| f = newf |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| def printdict(inputdict,ix): | |
| attr = vars(inputdict[inputdict.keys()[ix]]) | |
| print ', '.join("%s: %s" % item for item in attr.items()) |