I have a dataframe in pandas which I would like to write to a CSV file. I am doing this using: df.to_csv(‘out.csv’) And getting the following error: UnicodeEncodeError: ‘ascii’ codec can’t encode character u’\u03b1′ in position 20: ordinal not in range(128) Is there any way to get around this easily (i.e. I have unicode characters … Read more
What is the easiest way to save PL/pgSQL output from a PostgreSQL database to a CSV file? I’m using PostgreSQL 8.4 with pgAdmin III and PSQL plugin where I run queries from. 17 s 17 Do you want the resulting file on the server, or on the client? Server side If you want something easy … Read more
Is there an easy way to run a MySQL query from the Linux command line and output the results in CSV format? Here’s what I’m doing now: mysql -u uid -ppwd -D dbname << EOQ | sed -e ‘s/ /,/g’ | tee list.csv select id, concat(“\””,name,”\””) as name from students EOQ It gets messy when … Read more
Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this into a single string of Peter, Paul, Mary? 4 47
