writing pandas df to file using variable as file name

Question

I am trying to write pandas df to an output file with:

outFileName="myfile_" + gene_name #gene_name gets a new value from argparse 

df.to_csv('%.csv' %outFileName, sep=',', index=False)

the error I am getting::

TypeError: %c requires int or char

I tried

outFileName=str("myfile_" + gene_name)

and got the same error. Am I missing something? I can save the df if I do not use variable as outputfile name but I need to have the variable.

Mohit Motwani · Accepted Answer · 2019-07-15 07:26:05Z

5

Use to_csv:

df.to_csv(outFileName+".csv", sep=',', index=False)

edited Jul 15, 2019 at 7:26

Mohit Motwani

4,8124 gold badges21 silver badges50 bronze badges

answered Jul 15, 2019 at 7:25

Ramineni Ravi Teja

3,99631 silver badges41 bronze badges

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

Comments

jezrael · Accepted Answer · 2019-07-15 07:18:25Z

1

I think you can use format for new name for file:

df.to_csv('myfile_{}.csv'.format(gene_name), sep=',', index=False)

Or if use python 3.5+ is possible use f-strings:

df.to_csv(f'myfile_{gene_name}.csv', sep=',', index=False)

answered Jul 15, 2019 at 7:18

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Comments

user3265950 · Accepted Answer · 2020-11-30 11:13:10Z

1

name = x
nameFile = name +'.csv'

with open(nameFile, "a") as a_file:
    a_file.write(data)

answered Nov 30, 2020 at 11:13

user3265950

111 bronze badge

1 Comment

Boken Over a year ago

Please don't post only code as answer, but also provide an explanation what your code does and how it solves the problem of the question. Answers with an explanation are usually more helpful and of better quality, and are more likely to attract upvotes

Collectives™ on Stack Overflow

writing pandas df to file using variable as file name

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related