python - How to export pandas csv format only with character double quotes

Question

I have a dataframe consists of numeric and character columns.

I want to export this as csv format and to apply double quotes only to character columns.

Is there any tips to export csv format with only character double quotes?

Below is my simple example.

Thanks.

test = pd.DataFrame({'char' : ['100', '200'], 'num' : [700, 800]})
test.to_csv('test_out.csv', sep=",", quotechar='"',index=False, quoting=csv.QUOTE_ALL)

>> actual result
"char","num"
"100","700"
"200","800"

>> result that I want...
"char","num"
"100",700
"200",800

Answer 1

Use csv.QUOTE_NONNUMERIC for quoting parameter:

test.to_csv('test_out.csv',  sep=",", quotechar='"',index=False, quoting=csv.QUOTE_NONNUMERIC)

Test:

test = pd.DataFrame({'char' : ['100', '200'], 'num' : [700, 800]})
print(test.to_csv( sep=",", quotechar='"',index=False, quoting=csv.QUOTE_NONNUMERIC))
"char","num"
"100",700
"200",800