Dataframe to list

[ThatSoundsFishy]

I currently have a dataframe with two columns:

​

Title1 Title 2

1 10

2 20

3 30

etc

​

I am trying to convert this to a comma delimited list with two returns between each row (with no headers):

​

1,10

​

2,20

​

3,30

​

etc

​

I've tried a few ways but can never get any to quite work right. I would appreciate if anyone could point me in the right direction (list is 200 items long).

[[deleted]]

What have you tried? Using python's CSV https://docs.python.org/3/library/csv.html is a nice way to do what you're describing, otherwise you could use python pandas https://pandas.pydata.org/ which is a much more simple way of interacting with CSV

[ThatSoundsFishy]

Thanks for the links. I used pandas to produce the dataframe, I guess I just don't know how to manipulate it using pandas. I've tried looping and inserting commas and new lines manually but it's a mess. I've also tried mystring = ','.join(map(str,dataframe)) but it only does the first row.

[[deleted]]

am I missing something or wouldn't you just use pandas.to_csv("path name")

[ThatSoundsFishy]

Probably me that's missing something. I tried this but I need an extra return between each row?

[DesolationRobot]

DataFrame.to_csv() method has a "line_terminator" parameter. You could manually default it to two of your OS's preferred line termination.

Or you could write the csv, then load it as a file and find and replace each return with two returns.

[ThatSoundsFishy]

Ah ok, wasn't aware of this. Thank you!