I have the following code f = open('01-01-2017.csv')
From f variable, I need to remove the ".csv" and set the remaining "01-01-2017" to a variable called "date". what is the best way to accomplish this
Asked
Active
Viewed 1,765 times
0
Jean-François Fabre
- 131,796
- 23
- 122
- 195
michaelg
- 223
- 1
- 6
- 25
-
`date = os.path.splitext('01-01-2017.csv')[0]` should do it. – Jean-François Fabre Sep 27 '17 at 13:40
-
you could use split `date='01-01-2017.csv'.split('.')[0]` – Macintosh_89 Sep 27 '17 at 13:43
-
I need to reference the variable f in my code since the file name could be changed at any time. your solutions worked with date = '01-01-2017.csv' but do not seem to work with the variable f @Jean-FrançoisFabre – michaelg Sep 27 '17 at 13:45
-
that's why your question should be more specific. Editing & Reopening – Jean-François Fabre Sep 27 '17 at 13:48
1 Answers
1
just retrieve the name of the file using f.name and apply os.path.splitext, keep the left part:
import os
date = os.path.splitext(os.path.basename(f.name))[0]
(I've used os.path.basename in case the file has an absolute path)
Jean-François Fabre
- 131,796
- 23
- 122
- 195