How to I get df.to_csv() to stop breaking my row over multiple lines in the output file?

I have a pandas DataFrame which contains a long np array as one of the elements. When I write it to csv using the to_csv() function each row is broken up over multiple lines in the output file. Is there a way to suppress this behavior and get each row of the DataFrame to only take up one line in my output csv?

## Create Example Data Frame  fruit_veg = pd.DataFrame({"category":["fruit","vegetable"],                            "items":[np.array(["apple","pear","banana","grapefruit","watermelon",                                               "lychee","dragonfruit","mango"]),                                     np.array(["asparags","cabbage","zuchinni","broccoli",                                               "cauliflower","carrot","celery"])]})    ## Output to csv  fruit_veg.to_csv(r'/my/file/path/EXAMPLE_PROBLEM.csv')  

The resulting csv file (actually) looks like this:

,category,items  0,fruit,"['apple' 'pear' 'banana' 'grapefruit' 'watermelon' 'lychee' 'dragonfruit'   'mango']"  1,vegetable,"['asparags' 'cabbage' 'zuchinni' 'broccoli' 'cauliflower' 'carrot'   'celery']"  

I want it to look like this:

,category,items  0,fruit,"['apple' 'pear' 'banana' 'grapefruit' 'watermelon' 'lychee' 'dragonfruit' 'mango']"  1,vegetable,"['asparags' 'cabbage' 'zuchinni' 'broccoli' 'cauliflower' 'carrot' 'celery']"  

https://stackoverflow.com/questions/66997016/how-to-i-get-df-to-csv-to-stop-breaking-my-row-over-multiple-lines-in-the-outp April 08, 2021 at 11:37AM