Concatenate variable and string python script

Question

I am trying to write a Python script in Spyder to deal with several files at the same time.

Actual path is something like:

/TestCondition/TestDate-A1.txt

I want to control the TestCondition and TestDate only at the beginning.

FoldPath = TestCondition
FileName = TestDate

I want to do something like:

dfA1 = pd.read_csv(FoldPath&'/'Filename&'A1.txt'
dfA2 = pd.read_csv(FoldPath&'/'Filename&'A2.txt'
....
dfA12 = pd.read_csv(FoldPath&'/'Filename&'A12.txt'

#Code with Pandas and Numpy...

How do I concatenate the variable names FoldPath and FileName with the string "A1 to A12" specifically to call out a csv file ? I can't find the correct syntax.

Thanks, J-F

Edit Question solved. With the knowledge of "import os" and also "os.path.join", I can now find a bunch of examples to do what I intended to do. I know that this question has been asked several times, but with my limited knowledge of Python, and programming in general, I could not find the correct key words. Anyway, thanks again for your quick answers.

use os.path.join

rafaelc
– rafaelc

2018-07-31 23:00:19 +00:00
Commented Jul 31, 2018 at 23:00 — rafaelc
– rafaelc, Commented Jul 31, 2018 at 23:00
and the other os.path functions.

Mike 'Pomax' Kamermans
– Mike 'Pomax' Kamermans

2018-07-31 23:04:06 +00:00
Commented Jul 31, 2018 at 23:04 — Mike 'Pomax' Kamermans
– Mike 'Pomax' Kamermans, Commented Jul 31, 2018 at 23:04

Nerdrigo · Accepted Answer · 2018-07-31 23:31:14Z

1

You can use os.path.join and the + to concatenate

import os
filepath = os.path.join(FoldPath, FileName + '-A1.txt')
dfA1 = pd.read_csv(filepath ...

edited Jul 31, 2018 at 23:31

answered Jul 31, 2018 at 23:06

Nerdrigo

3281 gold badge5 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

rafaelc · Accepted Answer · 2018-07-31 23:22:40Z

1

first..

dfA1 = pd.read_csv("/{}/{}-A1.txt".format(FoldPath, Filename)

but this code not recommanded.

second.. use os.path.join

dfA1 = pd.read_csv(os.path.join(FoldPath, "{}-A1.txt".format(Filename, ))

edited Jul 31, 2018 at 23:22

rafaelc

59.4k15 gold badges64 silver badges87 bronze badges

answered Jul 31, 2018 at 23:15

Chunghui kim

111 bronze badge

1 Comment

Jean-François Beaubien Over a year ago

Hello. I made it work. Thanks. However, I find that the method proposed below with [...] Filename + '-A1'[...] to be a bit more intuitive.

Collectives™ on Stack Overflow

Concatenate variable and string python script

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related