Top "Csv" questions

Comma-Separated Values or Character-Separated Values (CSV) is a standard "flat file database" format for storing tabular data in plain text, consisting of an optional header row that lists the table fields delimited by commas or tabs or other delimiter character, followed by one or more rows (newline separated) representing the table records as delimited lists of the values.

How to concatenate text from multiple rows into a single text string in SQL server?

Consider a database table holding names, with three rows: Peter Paul Mary Is there an easy way to turn this …

sql sql-server csv string-concatenation group-concat
Writing a pandas DataFrame to CSV file

I have a dataframe in pandas which I would like to write to a CSV file. I am doing this …

python csv pandas dataframe
How to output MySQL query results in CSV format?

Is there an easy way to run a MySQL query from the Linux command line and output the results in …

mysql csv quotes
How do I import CSV file into a MySQL table?

I have an unnormalized events-diary CSV from a client that I'm trying to load into a MySQL table so that …

mysql csv load-data-infile
How to split a comma-separated value to columns

I have a table like this Value String ------------------- 1 Cleo, Smith I want to separate the comma delimited string into …

sql-server sql-server-2008 csv
Reading CSV file and storing values into an array

I am trying to read a *.csv-file. The *.csv-file consist of two columns separated by semicolon (";"). I am able to …

c# .net arrays csv
(unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape

I'm trying to read a .csv file into Python (Spyder) but I keep getting an error. My code: import csv …

python csv unicode syntax-error
How to import CSV file data into a PostgreSQL table?

How can I write a stored procedure that imports data from a CSV file and populates the table?

postgresql csv postgresql-copy
Import CSV file into SQL Server

I am looking for help to import a .csv file into SQL Server using BULK INSERT and I have few …

sql sql-server csv bulkinsert bulk
TypeError: list indices must be integers or slices, not str

I've got two lists that I want to merge into a single array and finally put it in a csv …

python arrays list csv